Chapter 17 Quiz
Innermost sort
The field that will be used for the second level of sorting
Join Line
The line connecting two tables that visually indicates the common fields and the type of relationship
Between and Operator
A comparison Operator that looks for values within a range
Relationship
An association that you establish between two tables based on common fields
Data Type
Classification identifying the kind of data that can be stored in a field, such as numbers, text, or dates
Metadata
Data that describes the properties or characteristics of other data; it refers to information like size or formatting of data
Select Query
Query that retrieves data from one or more tables or queries, displaying the selected data in data sheet also known as a simple query
Cascade Options
Relationship options that enable you to update records in related tables when referential integrity is enforced
Database
organized collection of facts about people, events, things, or ideas related to a specific topic or purpose
Table
A format for information that organizes and presents text and data in columns and rows; the foundation o a database
Primary Key
A required field that uniquely identifies a record in a table
Referential Integrity
A set of rules that Access uses to ensure that the data between related tables is valid
Field
A single piece of information that is stored in every record; represented by a column in a database data types
Data sheet View
Access View that displays data organized in columns and rows similar to an Excel worksheet
Form
Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records
Query
Database object that retrieves specific data from one or more database objects-either tables or other queries-and then, in a singe data sheet, displays only the data you specify
Design View
Displays the detailed structure of a table, query, form, or report. For forms and reports, may be the View in which some tasks must be performed, and only the controls, and not the data, display in this view
Cascade update related fields
Enables you to change data in the primary key field in the table on the one side of the relationship and update that change to any fields storing that same data in related tables
Cascade delete related records
Enables you to delete a record in a table and also delete all of the related records in related tables
Outermost sort
Field that will be used for the first level of sorting
Null Value
Fields that are empty
Comparison Operator
Symbols that are used to evaluate data in the field to determine if it is the same=greater than>, less than< or in between a range of values as specified by the criteria
Object
The basic parts of database that you create to store your data and work with your data; for example, tables, queries, forms, and reports
Relational Database
a sophisticated type of database that has multiple collections of data within the file that are related to one another
