|
|
|
Queries, as the name implies, form the "questions" the database is given to search and find information.
After all, the purpose for creating a database is to be able to find and retrieve specific pieces of information. Queries do just that.
Forms are created to simplify data entry and provide a simple tool for users to view information in the database. Reports are created to print out selected information in desired formats.
|
Macros are created to allow the user to issue instructions to the computer without using complicated computer code. Macros generate computer code, but they do it automaticaly as a result of the user's input in plain English.
Next I'll explain how to generate the table for the address book. First do the following two-step path procedure from the main database window: Tables \ Create table in Design view If you followed the path correctly, you will see something like the following: |
| The above picture is an empty table, ready for field names (that is column titles) to be defined. Each field needs a Name, Data Type and if |
desired a Description, which is optional.
The following picture shows the table all filled out.
|