Microsoft Access Chapter 2

Data Integrity Rules

A set of rules that ensures data in a database is accurate and consistent.

Default Value Property

Adds a preset value to the field

Field Properties Pane

Allows you to set field properties in table design view.

Input Mask (Book)

An _______ forces a user to enter data using a specific format.

Record Validation Rules (Book)

Are used to create consistency data integrity rules that compare fields in the same table.

Relational Database

Database in which data is organized into a collection of related tables.

Compact & Repair Database

Database utility that removes unused space from a database to help improve performance; can be used to repair a database in which some objects have become corrupted.

Cascading options

Delete and update options that may be applied to relationships between tables. When they are enforced, actions on one table affect records in the related table.

Lookup Fields (Book)

Display a list of data values from which the user can choose.

Metadata

Document properties stored with the file.

Referential Integrity (book)

Ensures that records in associated tables have consistent data.

Primary Key

Field that contains a unique value for each record in a table; allows one record to be distinguished from another.

Lookup Fields

Field used to display a list of data values that users can select to store in the field.

Validation Text (Book)

Property to enter a custom message that displays instead of the default message.

Validation Text

Property used to enter a custom message that displays when a validation rule is violated.

Validation Rule

Property used to set limits on acceptable values that can be entered into a field.

Input Mask

Property used to specify the format for data entered into a field.

Cascade Update Related Fields

Referential integrity option that allows a primary key value to be changed in a record in one table and automatically updates the foreign key values in matching records in related tables

Cascade Delete Related Records

Referential integrity option that allows you to delete a record from a table even if there are matching records in related tables; also deletes all matching records from related tables.

One-to-many relationship

Relationship between tables in a database where a row of data in one table can be associated with many rows of data in a related table.

One-to-One Relationship

Relationship between tables in a database where a row of data in one table can be associated with only one row of data in a related table.

Many-to-Many relationship

Relationship between tables in a database where many rows of data in one table can be associated with many rows of data in a related table.

Wild Characters

Symbols used in an expression in a query to find records that match, or in a validation rule to require data being entered to match a specific character, number, or pattern.

Junction

Table created to link the two tables in a many-to-many relationship; also known as an intersection table.

Metadata (Book)

The descriptions about what the different data fields represent and their formats.

Referential Integrity

The policy that ensures that related database records remain accurate. If a relationship has _____________ enforced, than no modification can be made to either table that would violate the relationship structure.

Input Mask Wizard

Tool that guides you through the steps to define an input mask; only available on Short Text or Date Fields.

Expressions

Type of formula used to write validation rules, perform calculations, create query criteria, control macros, and group and sort data in a report.

Relationships window

Used to create, edit, and view the table relationship in a database.

Record Validation Rules

Validation rule that compares fields in the same table; entered into the Validation Rule property of a table.

Design View

View option that allows you to build or modify the basic structure or functionality of a database object. Design view is used to create a table from scratch.

Datasheet View

View option that allows you to enter, modify, view, or delete data; available in a table, query, or form.

Expression Builder

Window that provides easy access to tools used to create expressions.

Primary Key (Book)

________ is a field that contains a unique value for each record.

Design View (Book)

__________ is used to create a table from scratch

Data sheet View (book)

____________ is used to enter records into a table.