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.