Access 2016 Exam

A Short Text field can hold up to _______ characters.

255

A Long Text field can hold up to _______ characters.

65,535

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

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

Clear

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

A Number field uses an expression (a formula) to calculate a value.

False

A Split form contains the Datasheet view at the top and the Form view at the bottom.

False

A lookup field allows the user to select only one entry choice.

False

A table (or datasheet) looks similar to a PowerPoint slide.

False

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

Criteria are limited to text fields.

False

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

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

Find Duplicates

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

Hyperlink

A(n) _______ form is similar to a Datasheet form, but it is more flexible since you can easily modify its layout and design.

Multiple Items

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

Navigation

A(n) _______ form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Split

A control can display data from a table or query field.

True

A form does not contain records or data itself. It is only an interface to an underlying table or query.

True

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 allows you to import data from individual worksheets into separate database tables to define relationships and create user-friendly forms for future data entry.

True

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

True

By applying a filter to a database object, you display a subset of records that meet the filter criteria.

True

Criteria are conditions that records must meet in order to be included in query results.

True

If multiple databases share a common list of customers or employees, it makes sense to maintain the data in one database and then create linked tables in the other databases.

True

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

A(n) _______ control is a control that displays the field data.

bound

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

deleting

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

fields

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

filter

A(n) _______ displays data from an underlying table and allows database users to enter, edit, and delete data in a user-friendly format.

form

Although an attachment is not visible in the table, when you start working with _______, the attachment is available for display.

forms and reports

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

label

A Single Record Form can be based on either a Table or Query and it displays _______ record(s) at a time.

one

A(n) _______ 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

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

report

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

Filtering with AutoFilter is _______.

temporary

A(n) _______ control is a control that is not linked to a field.

unbound

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

visible