| A | B |
|---|
| maintaining the database | _____ means modifying data to keep it up-to-date. |
| Restructuring the database | _____ means changing the database structure. |
| searching | _____ means looking for records that satisfy some criteria. |
| filter | To have only the record or records that satisfy the criterion appear, use a _____. |
| structure | When you initially create a database, you define its _____, that is, you assign names and types to all the fields. |
| Lookup field | A _____ allows the user to select from a list of values. |
| multivalued fields | Fields that contain more than one value are called _____. |
| append | An ______ query adds a group of records from one table to the end of another table. |
| required | A _____ field is one in which a user must enter data. |
| Validation rules | ______ can make sure that a user’s entry falls within a range of values. |
| referential integrity | The property that ensures that the value in a foreign key must match that of another table’s primary key is called _____. |
| backing up | Periodically making a copy of a database is called _____ the database. |
| compact | To remove wasted space from a database, you must _____ the database. |
| greater than symbol | To format letters to always appear in uppercase, enter ____ as the format. |
