| A | B |
|---|
| Maintaining the Database | Modifing the data to keep it up to date by adding new records, changing the ddata for existing recrods, and deleting records. |
| Restructure the Database | Restructing can incluede adding new fields to a table, changing the characteristics of existing fields, and removing existing fields. |
| Split Form | Form that allows you to simultaneously view both simple form and datasheet views of the data. |
| Searching | looking for records that satisfy some criteria |
| Filter | To have only the record or records that satisfy the criterion appera |
| Common Filter | Access includes a collection of filters that perform common filtering tasks |
| Lookup Field | Allows the user to select from a list of values when updating the contents of the field |
| Multivalued Fields | Fields that can contain more than one value |
| Calculated Fields | A field that can be computed from other fields |
| Action Query | Adds, deletes, or changes data in a table |
| Update Query | Allows you to make the same change to all records satisfying some criterion |
| Delete Query | All you to make the same change to all records satisfying some criterion |
| Append Query | Adding the results of a query to an existing table |
| Make-table query | Adding the query results to a new table |
| Validation Rules | Rules that a user must follow when entring the data |
| Validation Text | The message that appers if a user attempts to violate the validation rule |
| Required Field | A field in which the user must enter data |
| Range of Values | The values in the current due field must be between 0-10,000 |
| Default Value | A value that access will display on the screen in a particular field before the user begins adding a record |
| Legal Value | For the account type field are SER, NON, and IND |
| Format | To affect the way data appears in a field |
| Format Symbol | To use a format with text field, you enter a special symbol |
| Subdatasheet | Subdatasheet is useful when you want to review or edit data in joined or related tables |
