4. List of Relational Database Objects in MS Access

Objects are the types of items you can place in a database. They include:

• Tables
• Queries
• Forms
• Reports
• Pages
• Macros
• Modules

Tables:
All of the data in your database is stored in tables. A table consists of fields (columns) and records (rows). You need to design your table before you can enter data in your database.
Queries:
You can use a query to find data in your tables. You can display the results that match a certain criteria, sort the database, or combine data from different tables.
Forms:
These are the screens that you use to input data into your tables. You can only see one form at a time. The forms are similar to index cards.
Reports:
These are the output screens. If you are going to print something, you need to create a report.
Pages:
These are available in Access 2000 and Access XP. Pages are HTML files, with the data read to and written from the database. Pages are for entering or displaying data via the Internet.
Macros:
Macros are scripts for doing a job. Each line of a macro performs an action, and the bottom half of the macro screen provides the details of how the action is to apply.
Modules:
Modules are similar to Macros, but are much more powerful. They are used by advanced users who write their own functions and programs within Access. Most basic users will never use Modules.