Term
|
Definition
| Collection of organized data |
|
|
Term
|
Definition
| Another term for unique identifier |
|
|
Term
|
Definition
| Way of uniquely identifying each record in the database |
|
|
Term
|
Definition
| Used whenever you want something other than the field name displayed |
|
|
Term
|
Definition
| Questions the database can answer |
|
|
Term
|
Definition
| Storing the same fact in more than one place |
|
|
Term
|
Definition
| One records in the first table is related to many records in the second table but each record in the second table is related to only one record in the first |
|
|
Term
|
Definition
| Represent any character or combination of characters |
|
|
Term
|
Definition
| Query that prompts for input whenever it is used |
|
|
Term
|
Definition
| To create a relationship between tables created for a specific purpose |
|
|
Term
|
Definition
| Copying Access data for use in other applications |
|
|
Term
|
Definition
| Creating groups of records that share something in common |
|
|
Term
|
Definition
| Portion of the window where you specify fields and criteria for the query |
|
|
Term
|
Definition
| Used to select values in a given range |
|
|
Term
|
Definition
| Wildcard that represents any individual character |
|
|
Term
|
Definition
| To have only the records that satisfy the criterion appear |
|
|
Term
|
Definition
| List of values a user selects from when updating the contents of a field |
|
|
Term
|
Definition
| Query that adds the results of a query to an existing table |
|
|
Term
|
Definition
| Rules that a user must follow when entering data |
|
|
Term
|
Definition
| Ensures a value in a foreign key matches that of another table’s primary key |
|
|
Term
|
Definition
| Symbol to create uppercase letters |
|
|
Term
|
Definition
| Move between upper & lower panes |
|
|
Term
|
Definition
| indicated by a plus sign that appears in front of the rows in the table |
|
|
Term
|
Definition
| allows you to make the same changes to all records satisfying some criterion |
|
|
Term
|
Definition
| allows you to delete all records satisfying some criterion |
|
|
Term
|
Definition
| calculates a statistic for data that is grouped by two different types of information |
|
|
Term
|
Definition
| allows you to restrict the number of records that will appear |
|
|
Term
|
Definition
| a common wildcard that represents any collection of characters |
|
|
Term
|
Definition
| perform the necessary action to produce and display results in datasheet view |
|
|
