Access

A Short Text field can hold up to _______ characters.

255

A Long Text field can hold up to _______ characters.

65,535

Text files that use a comma as the delimiter may be saved as a(n) _______ file.

CSV(comma-separated value)

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

Clear

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

Default Value property

The Expression Builder can be used to create complex expressions including functions similar to those in _______.

Excel

Deleting a record in a form will also delete it from the underlying ________.

Table

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.

asterisk (*)

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

calculated field

Instead of preventing updates or deletions when enforcing referential integrity, you can set relationship options to delete or update the related records in the secondary table. These options are known as _______ options

cascading

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

controls

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

Expand the _______ list to select from predefined format options for AutoNumber, Number, Currency, and Date/Time data types

format

Sorting query results in ascending order sorts them _______.

from A to Z

In Datasheet view, the number next to the attachment icon in each record tells you _______.

how many attachments there are

If the field you want to change to a lookup field uses the Date/Time or Currency data type, you will need to change the data type to ____________ before you can modify it to be a lookup field

number

Although you create and work with a single Access database file, inside the file, there are multiple _______.

objects

Access _______ are the essential building blocks of the database.

tables

Filtering with AutoFilter is _______.

temporary

Duplicates of the primary key field are not allowed.

true

By hiding a field in a query, you can use it to define criteria without making the field _______ in the final query results.

visible

Criteria in the same row implies _______. Records must meet both criteria.

AND

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

Attachment

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

AutoNumber

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

Backstage view

In the _______ box, type the field name as it should appear in labels and column headings.

Caption

If you want to set up a table without entering data, use the _______ heading at the far right side of the table.

Click to add

The Query Wizard button is located in the _______ tab of the Ribbon.

Create

A(n) _______ field stores a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal). Access will not round these fields.

Currency

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

Database

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

Detail

Access allows program files (for example, .exe or .bat files) as attachments only if you have administrator privileges in this particular database.

False

Access does not provide any method to sharing or exporting of data to other applications.

False

Access offers database designers only one template for creating forms.

False

In order to reuse a query in the future, click the Run Later option in the Query Tools Design tab.

False

In Design view, the bottom pane is the ____________ pane which displays details about the selected field

Field Properties

If a record that contains the data you want to filter for is visible, you can click the field and use the _______ feature.

Filter by Selection

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

In a select query, typing _______ in the Criteria cell for a particular field will show all records that are missing data in that field.

Is Null

in the _______ box, type the new field name. This is the name as it will be referenced by other objects in your database

Name

All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.

Navigation

Different criteria in multiple rows implies _______. Records must match one criterion, but not all

OR

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

Reports

The Run button is located near the left side of the Ribbon on the Query Tools Design tab, in the ____________ group.

Results

If you want to include a field in your query, but do not want that field to show in Datasheet view, click the _______ box to remove the checkmark for the field you want to hide.

Show

A select query displays data from one or more related tables or queries, based on the fields that you select.

True

A select query displays data from one or more tables or queries, based on the fields that you select.

True

Access allows you to delete and rename forms, reports, and other database objects.

True

Access is the only Office application that uses a dedicated Print Preview page.

True

All records in a table have the same fields.

True

In a query, expressions can reference fields, mathematical operators, functions, and constants.

True

If you are working on data entry in the Datasheet view or Form view, the _______ command is applied to the entire record, not each individual field within the record

Undo

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

Yes/no

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

If you no longer need an object or want to use a different name, Access allows you to _______ and rename forms, reports, and other database objects.

delete

Calculated fields can include references to fields in other tables or queries.

false

Each column in a table represents a specific data value called a

field

Access is a relational database—objects in your database are related to one another through relationships defined by common _______ between tables.

fields

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

If you right-click any field name and select Insert Field to insert a new blank text field, it is inserted to the _______ of the field you selected.

left

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

paperclip

In a parameter query, instead of specific criterion, enter _______ for the user in the Criteria row.

prompts

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

record

A _____ database is a group of tables related to one another by common fields.

relational

Access will warn you if you try to delete a table that would invalidate

relationships

If you confirm that you want to delete a table, Access will automatically delete the _______, and then delete the table

relationships

Objects in Access are related to one another through _______ defined by common fields between tables.

relationships

If the field you are changing is the primary or foreign key in a relationship, Access may _______ before changing the data type.

require you to delete the relationship

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

save

If you want to control how records are displayed, set the _______ order as part of the query design.

sort

a ______ is a file with predefined settings that you can use as a base to create a new database of your own.

template