final

The logical operator that requires all conditions to be met is

and

To add on to the end of an object, such as to add records to the end of an existing table, is to

append

To add one or more records from a source table to a destination table is to:

append records

Which data type should be used to add one or more files to the records in a database?

attachment

To make a copy of the original database for use if data is lost or becomes corrupt.

back up

A comparison operator that looks for values within a range is:

between...and

The term used to describe objects and controls that are based on data that is stored in tables

bound

A control that retrieves its data from an underlying table or query

bound control

Which data type should be used to enter an expression that will compute the entry displayed?

calculated

A control that contains an expression, often a formula, that uses one or more fields from the underlying table or query.

calculated control

Which option should be used to ensure that orphan records are not left in the database?

cascade delete

Options that update records in related tables when referential integrity is enforced.

cascade options

A temporary storage area in windows

clipboard

A field in one or more tables that stores the same data.

common field

The symbols of =, >, and < are known as

comparison operators

An object on a form or report that displays data, performs actions, and lets you work with information.

control

The grouped arrangement of controls on a form or report.

control layout

Which option sends a duplicate version of the selected table to the Clipboard, leaving the original table intact

copy

Conditions in a query that identify the specific records for which you are looking are known as

criteria

Facts about people, events, things, or ideas.

data

The characteristic that defines the kind of data you can enter into a field is the

data type

Rules that help prevent individuals from entering invalid data and help ensure that individuals enter data in a consistent manner.

data validation

The Access view that displays data in columns and rows like an Excel worksheet is

datasheet view

A control on a form or report that inserts the current date each time the form or report is opened.

date control

Which field property is used to display a value in a field for all new records

default value

The lower area of the Query window that displays the design of the query is the:

design grid

A good way to create a table when you know exactly how fields will be set up.

design view

An Access view that displays the detailed structure of a query, form, or report

design view

The section of a form or report that displays the records from the underlying table or query

detail section

A feature used to create formulas in query criteria, form and report properties, and table validation rules.

expression builder

A single piece of information that is stored in every record and represented by a column in a table.

field

A list of field names in a table

field list

Characteristics of a field that control how the field displays and how data is entered are

field properties

To apply an attribute or characteristic to a field that controls the display and input of data, use:

field properties

An attribute or characteristic of a field that controls the display and input of data.

field property

The process of displaying only a portion of the total records (a subset) based on matching a specific value is:

filtering

A principle stating that data is organized in tables so that there is no redundant data

first principle of good database design

A simple database file that is not related or linked to any other collection of data.

flat database

The field that is included in the related table so the field can be joined with the primary key in another table for the purpose of creating a relationship

foreign key

An Access command that filters the records in a form based on one or more fields, or based on more than one value in the field is Filter by

form

An Access object to enter new records into a table, edit or delete existing records in a table, or display existing records is a:

form

Information at the bottom of the screen in Form view that prints after the last detail section on the last page.

form footer

Information, such as a forms title, that displays at the top of the screen in Form view and is printed at the top of the first page when records are printed as forms.

form header

Information printed at the end of each group of records and that is used to display summary information for the group is called a:

group footer

A special list created in Access to speed up searches and sorting

index

Data that is organized in a useful manner

information

hen sorting on multiple fields in Datasheet view, the field that is used for the second level of sorting

inner most

Determines the data that can be entered and how the data displays.

input mask

A condition in which records that match at least one of the specified values are displayed is:

or

A record that references a deleted record in a related table.

orphan records

when sorting on multiple fields in Datasheet view, the field that is used for the first level of sorting.

outermost

The action of filling a database with records

populate

The field that uniquely identifies a record in a table is known as the

primary key

A list of characteristics for controls on a form or report in which you can make precise changes to each property associated with the control is the

property sheet

The object that retrieves specific data and then displays only the data that you specify is a:

query

A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.

record

The box at the left of a record in Datasheet view that you click to select an entire record is the

record selector box

Information repeated in a database in a manner that indicates poor design is said to be

redundant

A set of rules that ensures that the data between related tables is valid

referential integrity

The tables in a database can relate to or connect to other tables through common fields because Access databases are:

relational

A predefined format that can be applied to the entire database or to individual objects in the database is called a:

theme

A security feature that checks documents for macros and digital signatures

trust center

An area where you can view the security and privacy settings for your Access installation

trust centre

A control that does not have a source of data, such as a title in a form or report

unbound control

An expression that precisely defines a range of data that will be accepted in a field.

validation rule

The error message that displays when an individual enters a value prohibited by the validation rule.

validation text

A wildcard character that serves as a placeholder for one or more unknown characters is the:

*

An organized collection of facts about people, events, things, or ideas related to a specific topic

Database

A field that stores the value of a mathematical operation is:

a calculated field

A query that uses an aggregate function for data that can be grouped by two types of information is

a crosstab query

A criteria that searches for fields that are empty is

is null

The line joining two tables that visually indicates the common fields and the type of relationship

join line

A control on a form or report that contains descriptive information, typically a field name.

label control

A small symbol that displays in the upper left corner of a selected control layout in a form or report that is displayed in Layout view and that is used to move an entire group of controls is the:

layout selector

The Access view in which you can make changes to a form or report while viewing the data.

layout view

The area below the Ribbon that displays information such as security alerts.

message bar

A field that holds multiple values, such as a list of people to whom you have assigned the same task.

multivalued field

The window area that organizes the database objects and from which you open objects

navigation pane

The process of applying design rules and principles to ensure that a database performs as expected

normalization

The basic parts of a database; for example tables, forms, queries, and reports

object

The window area that displays each open object on its own tab.

object window

A relationship between two tables where one record in the first table corresponds to many records in the second table.

one to many relationship

An association that you establish between two tables based on common fields.

relationship

A database object that summarizes the fields and records from a table or query in an easy-to-read format suitable for printing is a:

report

The object that displays fields and records from a table or query in a printable format is a:

report

Which field property is used to ensure that a field contains data and is not left empty?

required

The process in which Access searches the records in the table, finds the records that match specified criteria, and then displays the records in a datasheet is:

run

A principle stating that techniques are used to ensure the accuracy of data entered into a table

second principle

A gray bar in a form or report that identifies and separates one section from another.

section bar

Opening a database from a location in the Trust Center avoids the appearance of a(n):

security warning

A database object that retrieves selects specific data from one or more tables and then displays the results in Datasheet view

select query

The process of arranging data in a specific order based on the value in a field.

sorting

The underlying design of a table is referred to as the:

structure

A format for displaying related records in a datasheet when you click the plus sign next to a record in a table on the one side of a relationship.

subdatasheet

A table that is used to keep track of the multiple entries in a field but cannot be viewed or worked with

system label

The order that the insertion point moves from one field to another in a form when you press Tab is the

tab order

The database object that stores the data, and which is the foundation of an Access database.

table

The graphical object on a form or report that displays the data from the underlying table or query

text box control