College Computing

template

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

255

A Short Text field can hold up to _______ characters.

relational

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

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.

currency

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.

Yes/No

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

tables

Access _______ are the essential building blocks of the database.

fields

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

Navigation

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

objects

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

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 _______.

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.

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.

left

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.

Print Preview

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

input mask

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

errors

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

two

The Design view window is divided into _______ panes.

tables

The database ________ store all the data.

report

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

create the database file

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

Navigation Pane

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

Table Tools Fields

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.

row selector

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.

double-click

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

home

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

Print Preview view

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

underlying table design will not be changed

When rearranging fields in Datasheet view, the _______.

move to

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

field

You can change a field name by modifying the _______ properties.

sort

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

arrow

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

forms

_______ allow users to input data through a friendly interface.

primary key

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

65,535

A Long Text field can hold up to _______ characters.

table

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

Relationship Tools Design

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

database

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

Datasheet view

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

content

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

Field Size

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

three

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

Click to add

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.

field properties

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

Primary key

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

totals

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

Design View

_______ is used to modify the structure of the database object.