GO! with Microsoft Access 2013 Introductory: Database Management Flashcards
The area directly below the ribbon that displays information such as security alerts.
An area where you can view the security and privacy settings for your Access installation.
An association that you establish between two tables based on common fields.
A relationship between two tables, where one record in the first table corresponds to many records in the second table.
In the query design window, in the table area, the list of field names in a table.
The primary key field is connected to this field in the related table to create a relationship.
A set of rules that ensures that the data between related tables is valid.
The visual cue in the Relationships window that indicates tables are related by connecting common fields.
In Datasheet view, clicking the plus sign (+) displays the related records in this format.
The process of arranging data in a specific order based on the data in a field.
A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number.
A sorting order that arranges text alphabetically (Z to A) and numbers from the Highest number to the Lowest number.
In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting.
In Datasheet view, when sorting using multiple fields, the field that is used for the second level of sorting.
The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.
Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:
The lower area of the query design window where criteria is entered is the:
Min, Max, Avg, and Sum are examples of:
Conditions in a query that identify the specific data for which you are looking are known as:
A criteria that searches for fields that are empty is:
The symbols of =,>,and<, are known as:
A comparison operator that searches for values within a range is:
the logical operator that requires all criteria to be met is:
A wildcard character that serves as a placeholder for one or more unknown characters is the:
A field that stores the value of a mathematical operation is:
A calculated field
For a calculated field, the new field name must be followed by:
A query that uses an aggregate function and displays data grouped by two types of information is:
A crosstab query
A query that prompts you for criteria when it is run is a:
Criteria that can be changed when a query is run is a:
A good parameter for a City field is:
[Enter a City]