Access Module 3 Review

Flashcards from Access Module 3 Lecture Notes

Backstage View

A tool that offers quick access to commands for performing many file management tasks, displayed in a single, customizable navigation pane.

Maintaining the database

Adding, changing, and deleting records in database tables to keep them current and accurate.

Restructure the database

Adding new fields, changing field characteristics, removing fields, and creating validation rules.

Split form

A form split into two panes: one displays fields of one record, and the other is a datasheet view of the first few records.

Searching

Looking for records that satisfy specific criteria.

Filter

Specifying restrictions to display only specific database records, online images, or files.

Common filters

Access-provided filters to filter for specific values or a range of values.

Structure

The tables, fields, and field characteristics that comprise a database.

Lookup field

A field with lookup properties to create a drop-down list of values.

Multivalued fields

Fields that can contain more than one value.

Calculated field

A field used in queries that is computed from other fields but not stored in the database.

Computed field

A field used in a query that is not contained in a database but can be computed from other fields.

Action query

A query that adds, deletes, or changes data in a table.

Update query

An action query that updates the values in a field.

Delete query

An action query that deletes selected records from one or more tables.

Append query

An action query that adds selected records to an existing table.

Make-table query

A query that adds query results to a new table.

Validation rules

Rules that a user must follow when entering data to ensure valid data.

Validation text

A field property that determines the message if a user's entry fails validation.

Required field

A field in which a user must enter data.

Range of values

A validation rule that specifies that the values in a field must fall within a certain range.

Default value

A value that Access will display by default in a field before the user enters data.

Referential integrity

Rules that Access enforces to maintain consistency between related tables and prevent orphan records.

Foreign key

A primary key field from one table included in a second table to form a relationship.