| A | B |
|---|
| Maintaining the database | Includes modifying data, adding new records, changing existing records, and deleting records |
| Restructure the database | Includes adding new fields to a table, changing characteristics of existing fields, removing existing fields, creating validation rules and referential integrity |
| Split Form | Form that allows you to simultaneously view a simple form and the database view |
| Searching | Looking for records that satisfy some criteria |
| Filter | Used to display records that satisfy a certain criteria |
| Common Filter | A collection of filters that Access includes to perform often used filtering tasks |
| Structure | Assigning names and types to all fields in a database |
| Lookup Field | Allows the user to select from a list when updating contents of fields |
| Multivalued Fields | Fields that can contain more than one value |
| Calculated Field | A field computed from other fields |
| Computed Field | Another name for calculated field |
| Action Query | Adds, deletes, or changes data in a table using Query Design |
| Update Query | Allows you to make the same changes to all records in a database |
| Delete Query | Allows the user to delete records from a database that satisfies a certain criteria |
| Append Query | Adding the results of a query to the end of an existing database table |
| Make-Table Query | A query that creates a new table from records from an existing table |
| Validation Rules | Rules a user must follow when entering data in a database |
| Validation Text | Message to a user that appears if a user attempts to add information to a database that violates validation rules |
| Required Field | A field in a database that is designated as a "must" entry field |
| Range of Values | A validation rule that requires the user to only enter values between a minimum and maximum value |
| Default Value | The value that will display on the screen in a particular field before a user enters text or a value |
| Legal or Allowable Values | The values entered as acceptable for entry as a validation rule |
| Format | The way data appears in a field |
| Format symbol | Used to designate to an Access database what type of formatting should appear in a field |
| Referential Integrity | Property that ensures that the value in a foreign key must match that of another table's primary key |
| Foreign Key | A field in one table whose values are required to match the primary key of another table |
| One-to-Many Relationship | A record in one table is related to, or matches, many records in a second table, but each record in the second table only relates to one record in the first. |
| Cascade the Delete | Access deletes all related records in in multiple tables |
| Cascade the Update | Allowing a change in one table and make a corresponding change to data in related records |
| Subdatasheet | Useful when you want to review or edit data in joined or related tables |
