BCIS Exam #3

A Short Text field can hold up to _______ characters.

255

A Long Text field can hold up to _______ characters.

65,535

A(n) _______ field is automatically assigned its value by Access. D

AutoNumber

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

Clear

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

Clear Filter

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

Yes/No

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

bound

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

cursor

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

deleting

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

filter

Sorting query results in ascending order sorts them _______.

from A to Z

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

grouping

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

label

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

no

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

objects

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

record

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

relational

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

source

Access _______ are the essential building blocks of the database.

tables

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

template

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

theme

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

two

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

Attachment

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

Backstage view

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

Create

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

Datasheet

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

Default Value property

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

Detail

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

Find

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

Find Duplicates

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

Form view

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

Hyperlink

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

Layout view

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

Print dialog

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

Reports

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

Save

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

Toggle Filter

Duplicates of the primary key field are not allowed.

True

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.

asterick (*)

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

calculated field

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

controls

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

data

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

database

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

field

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

paperclip

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

report

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

right-click; Insert Field

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

specific list of items

Filtering with AutoFilter is _______

temporary

The Design view window is divided into _______ panes.

two