Access Module 3

Backstage View

A tool that offers quick access to commands for performing many file management tasks all displayed in a single navigation pane that can be customized to meet users' needs.

Maintaining the database

to add, change, and delete records in database tables to keep them current and accurate.

restructure the database

part of database maintenance that involves adding new fields to a table, changing the characteristics of existing fields, and removing existing fields, as well as creating validation rules and referential integrity.

split form

A form split into two panes; the upper pane allows you to display the fields of one record in any arrangement, and the lower pane maintains a datasheet view of the first few records.

searching

to look for records that satisfy some criteria.

filter

to specify a set of restrictions to only display specific database records, online images, or files

common filters

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

structure

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

lookup field

a field that has lookup properties, which are used to create a drop-down list of values to populate the field.

multivalued fields

fields that can contain more than one value.

calculated field

a field used in queries that are not contained in a database, but can be computed from fields that are.

computed field

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

action query

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 lets you add query results to a new table, which can be in the current database or another database.

validation rules

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

validation text

a field property that determines what message appears if a user attempts to make a field entry that does not pass the validation rule for that field.

required field

a field in which a user must enter data; neglecting to do so generates an error.

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 on the screen in a particular field before the user begins adding a record.

referential integrity

a set of rules that Access enforces to maintain consistency between related tables when you update data in a database, and prevents the creation of orphan records.

foreign key

a primary key field from one table that you include as a field in a second table to form a relationship between the two tables.