Understanding Access Databases
As you already know, a database is a collection of information. In Access, every database is stored in a single file. That file contains database objects, which are simply the components of a database.
Database objects are the main players in an Access database. Altogether, you have six different types of database objects:
Tables store information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information. A fitness database could track your daily running log, your inventory of exercise equipment, and the number of high-protein whey milkshakes you down each day, as three separate tables.
Queries let you quickly perform an action on a table. Usually, this action involves retrieving a choice bit of information (like the 10 top-selling food items at Ed's Roadside Dinner, or all the purchases you made in a single day). However, you can also use queries to apply changes.
Forms are attractive windows that you create, arrange, and colorize. Forms provide an easy way to view or change the information in a table.
Reports help you print some or all of the information in a table. You can choose where the information appears on the printed page, how it's grouped and sorted, and how it's formatted.
Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer.
Modules are files that contain Visual Basic code. You can use this code to do just about anythingfrom updating 10,000 records to firing off an email. For more on Visual Basic, see Access 2007: The Missing Manual.
Access gurus refer to all these database ingredients as objects because you manage them all in essentially the same way. If you want to use a particular object, then you add it to your database, give it a name, and then fine-tune it. Later on, you can view your objects, rename them, or delete ones you don't want anymore.
Tip: Designing a database is the process of adding and configuring database objects. For those keeping score, an Access database can hold up to 32,768 separate objects.
In this chapter, you'll consider only the most fundamental type of database object: tables. But first, you need to learn a bit more about databases and the Access environment.