ACESS PRACTICE EXAM

To add a new field to a table in Datasheet view, click the arrow in the _______ column to expand the list of available field types.

Click to Add

_______ fields are identified with a key icon next to the field name.

Primary key

Use the _______ to adjust margins and page orientation for your reports.

Print Preview view

The Design view window is divided into _______ panes.

Two

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

Yes/No

Access _______ are the essential building blocks of the database

tables

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.

Auto Number

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

Tables open in _______ where you can enter, sort, and filter data.

Datasheet view

_______ is used to modify the structure of the database object

Design view

The _______ property is used to limit the number of characters that can be entered in a text field.

Field Size

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

Form view

_______ allow users to input data through a friendly interface.

Forms

To switch to another view, click the _______ tab and then select your view from the View button arrow.

Home

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

Layout view

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

Navigation

To create a Single Record form based on a table or query, you must first select the table or query in the _______.

Navigation Pane

Reports include _______, which shows how the report will look when printed

Print Preview

You can display all the database relationships at once by clicking the All Relationships button on the _______ tab.

Relationship Tools Design

The easiest way to create a new report is to use the _______ button.

Report

To delete a field in Design view, select the field you want to delete by right-clicking the ______ to the left of the field name, and select Delete Rows.

Row Selector

You can control the order in which records appear in a table, query, or form by using the _______ feature.

Sort

To delete a field in Datasheet view, one method is to click anywhere in the field you want to delete and, on the _______ tab in the Add & Delete group, click the Delete button.

Table Tools Fields

_______ in a report display a calculation such as the sum or average of the values in a field or group.

Totals

You can use the _______ key(s) on your keyboard to navigate through fields in a record or between records.

arrow

The Input Mask Wizard offers a variety of common input masks including all the following except:

content

To begin a new Access database from scratch, you must first _______.

create the database file

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

To rename a field in Datasheet view, one method is to _______ the column header and type the new field name.

double-click

Storing each unique piece of data in a single table helps prevent data entry _______.

errors

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

field

You can change a field name by modifying the _______ properties

field

You can modify specific _______ to control the appearance of data in the field or the way in which users enter data.

field properties

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

fields

Some fields require a specific input format called a(n) _______.

input mask

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

When you enter data in a table, Access saves it each time you _______ a new field or begin a new record.

move to

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

objects

The _______ is the field that contains data unique to that record

primary key

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

When you use a form to enter data, you are actually adding data to the underlying _______.

table

The database ________ store all the data.

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

There are _______ types of relationships that can be established in Access.

three

When rearranging fields in Datasheet view, the _______.

underlying table design will not be changed