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