| A | B |
|---|
| Database | A collection of related data that is organized into objects that can provide information. |
| Row | A datasheet contains a list of data, and each row in a datasheet is called this. |
| Datasheet | A table of information that contains records about one aspect of the database, such as a table of members. |
| Field | Contains a specific piece of information within a record. |
| Database Objects | Tables, queries, forms, reports, etc. are examples are are found in the opening database window. |
| Primary Key | This may be placed on a field that is unique to each record, such as an account number. |
| Data type | When a field is defined in a database, you may also set this to reflect the field contents. |
| Form Design | You can enhance a form in this view. |
| Form | Data may be entered into this, which displays your records one at a time as they would be on index cards. |
| Lookup values | When entering data, rather than retyping several of the same entries in a field, you can create these that will appear in a list box. |
| Lookup wizard | Use this to automatically set up values for a drop-down list in a field. |
| Table Design | Any edits made in this view are reflected in the datasheet. |
| Query | A powerful search tool that can select data from several tables and combine it into one table to appear in any order. |
| Run | To find the results of a query you must do this. |
| Show | When you select a field to appear in a query, it will also be on the resulting table unless you deselect this field box. |
| Report Wizard | This will ask you to respond to some questions and then will create and display a sample report. |
| Sort | This procedure rearranges data so that it can be analyzed in diferent ways. |
| Wildcards | When searching for data, you may use these to substitute for unknown characters. |
| Question Mark | Used to substitute for an unknown single character. |
| Asterisk | Used to indicate an unknown group of characters. |
