Chapter 1 Terminology
Chapter 2 Terminology
Chapter 3 Terminology
Chapter 4 Terminology
5 & 6 Terminology
100
An organized collection of facts about people, events, things, or ideas related to a specific topic.
What is a Database
100
An association that you establish between two tables based on common fields.
What is a Relationship
100
An object on a form or report that displays data, performs actions, and lets you work with information.
What is a Control
100
An attribute or characteristic of a field that controls the display and input of data.
What is a Field Property
100
Data that does not change.
What is Static Data
200
Facts about people, events, things, or ideas.
What is Data
200
A list of field names in a table.
What is a Field List
200
Information at the bottom of the screen in Form view that prints after the last detail section on the last page.
What is a Form Footer
200
To make a copy of the original database for use if data is lost or becomes corrupt.
What is Backup
200
A formula that performs a calculation.
What is an Expression
300
A single piece of information that is stored in every record and represented by a column in a table.
What is a Field
300
A database object that retrieves
What is a Select Query
300
An Access view that displays the detailed structure of a query, form, or report.
What is Design View
300
A special list created in Access to speed up searches and sorting.
What is an Index
300
A query that enables you to create a new table or change data in an existing table.
What is an Action Query
400
The basic parts of a database; for example tables, forms, queries, and reports.
What is an Object
400
A set of rules that ensures that the data between related tables is valid.
What is Referential Integrity
400
The Access view in which you can make changes to a form or report while viewing the data.
What is the Layout View
400
A good way to create a table when you know exactly how fields will be set up.
What is Design View
400
An Access object that provides you with a way to enter, edit, and display data from underlying tables.
What is a Form
500
A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.
What is a Record.
500
The lower area of the Query window that displays the design of the query
What is Design Grid
500
A control that contains an expression, often a formula, that uses one or more fields from the underlying table or query.
What is a Calculated Control
500
A feature used to create formulas in query criteria, form and report properties, and table validation rules.
What is an Expression Builder
500
Displays the properties that affect the appearance and behavior of an object.
What is a Property Sheet
M
e
n
u