Knox County. UT Extension serves the citizens of Knox County with educational programs in the areas of Agriculture, Family and Consumer Sciences, Community Resource Development, and 4-H Youth Development.
Both Excel and Access are capable of doing a lot of things that the other can do. Both can store data. Both allow you to manipulate data. Access is primarily for lists of data, such as names and addresses, while Excel mainly deals with numbers.
Access refers to this type of collection as a table. In Access terms, a database is a collection of all the tables, queries, forms, reports, macros, and modules that compose a complete system. Relational refers to concepts based on set theory.These concepts are covered in Chapter 10, âRelating the Information in Your Database.â.n this chapter, you learn what a relational database is. You then explore all the types of objects available in Microsoft Access. You are exposed to tables, relationships, queries, forms, reports, and modules.