Access

255

A Short Text field can hold up to _______ characters.

find duplicates

A _______ Query will find all the records that have duplicate values in one or more fields.

bound

A control that displays data from a table or query is called a(n) _______ control.

template

A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.

tables

Access _______ are the essential building blocks of the database.

Backstage view

Access opens to _______ where you can select an existing database to open or begin a new one.

deleting

Access will prevent you from _______ records if it would violate the integrity of the database.

filter

By applying a(n) ________ to a database object, you display a subset of records that meet your criteria.

layout view

Forms and Reports also offer _______ where you can modify some (but not all) structural elements.

Form view

Forms open in _______, which provides a user-friendly interface for entering data.

Find

If you need to find multiple records that match your search parameters, not just the first one, use the _______ command.

from A to Z

Sorting query results in ascending order sorts them _______.

create

The Form button is located in the _______ tab of the Ribbon.

Clear Filter

To remove a filter from a database object, click the _______ option.

65,535

A Long Text field can hold up to _______ characters.

source

A new blank report does not have a record _______ defined until controls are added.

label

A(n) _______ control displays the field name on the left.

relational

A(n) _______ database is a group of tables related to one another by common fields.

report

A(n) _______ displays data from a table or query in a format suitable for printing.

Attachment

A(n) _______ field can include images, Word documents, or almost any other type of data file.

Autonumber

A(n) _______ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.

Hyperlink

A(n) _______ field stores a Web address or email address.

Yes/No

A(n) _______ field stores a true/false value as a ¿1 or 0.

theme

A(n) _______ is a unified color and font scheme.

grouping

Adding _______ organizes a report into sections by the value of a specific field.

two

Adding a field to a blank form places _______ control(s) in a stacked layout.

objects

Although you create and worAccess database file, inside the file, there are multiple _______.

cursor

Click and drag the _______ to make a control wider or narrower.

clear

Click the _______ filter option to remove the filter from the field.

Save

Clicking the _______ button on the Quick Access Toolbar will prompt you to name and save a newly-created table.

True

Duplicates of the primary key field are not allowed.

field

Each column in a table represents a specific data value called a(n) _______.

record

Each row in a table contains all the data for a single _______.

Default Value Property

Entering a value in the _______ can save time during data entry.

data

Fields can be inserted at the end of the field list in Design View by typing a new field name, and selecting a ________ type.

temporary

Filtering with AutoFilter is _______

asterick (*)

If you want to include all the fields from a table in your query, click and drag the _______ from the top of the table to the field row.

reports

In Access, normally _______ are the only database objects that are printed.

paperclip

In Datasheet view, attachment fields are designated by a(n) _______ icon.

no

In a new form there is(are) _______ record(s).

calculated field

In a query, a _______ displays a value returned by an expression (a formula).

detail

In the Simple Query Wizard, the _______ option shows every field you selected for every record.

print dialogue

In the _______ you can specify which pages to print and how many copies to print.

specific list of items

Lookup fields are useful to use for fields that reference a _______.

database

Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.

right click; insert field

One method you can use to insert a new field is to _______ any field name and select _______.

two

The Design view window is divided into _______ panes.

controls

The Expression Builder is used to create calculated _______ in forms and reports.

Toggle Filter

The _______ button on the Home tab will quickly apply or clear filters.

Datasheet

You can view the results of a query by switching to _______ view.