ACC 2 - Completion and Modified T/F

The maximum field size for a text field is _.

255

When you want to import data from an Excel worksheet into an Access table, any _ property values set for the fields in the table are not considered in the import process.

Caption

You can quickly insert the value from the same field in the previous record using the _ _ _ (use abbreviation and symbols) keyboard shortcut.

Ctrl + '

The _ _ _ allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.

Data Type gallery

You can use the _ property to enter an optional description for a field to explain its purpose or usage.

Description

Access allows you to change a field's size in _ view.

Design

Access allows you to modify a table's structure in _ view.

Design

You can create a table by importing the structure of another table into your current database using the _ _ tab on the Ribbon.

External Data

You use the _ _ tab if you want to import data from an Excel worksheet.

External Data

When defining a field, you can obtain more complete Help information about the field's current property, as shown in the item marked 2 in the accompanying figure, by pressing the _ key.

F1

Pressing the _ key allows you to switch between the Table Design grid and the Field Properties pane.

F6

_ is the default Field Size property setting for fields with the Number data type.

Long Integer

If you have a Customer ID field with values like 1234AC, you should use the _ _ data type.

Short Text

Once you click the _ _ button to open the Show Table dialog box, you can choose a table to add to the Relationships window, as shown in the accompanying figure.

Show Table

The _ format is used for currency fields with no dollar signs.

Standard

You use a(n) _ field to connect one table logically with another table.

common

A primary key that is made up of more than one field is called a(n) _ key.

composite

If no one field can be used to make each record unique, you can use a(n) _ _ as the primary key.

composite key

The _ _ determines what field values you can enter for the field and what other properties the field will have.

data type

A _ text file is one in which fields of data are separated by a character such as a comma or a tab.

delimited

A(n) _ is not required for a field, but it is a useful way to explain its purpose or usage.

description

When a primary key has been specified, Access forces you to enter a value for the primary key field in every record in the table. This is known as _ _.

entity integrity

You create a database by first identifying all the _ needed to produce the required information.

fields

The process of relating tables is often called performing a(n) _.

join

The _ custom date format displays the full name of the month (January to December).

mmmm

A(n) _-_-_ relationship exists between the tables in the accompanying figure. (see Schoology)

one to many

A field or collection of fields that uniquely identifies a record within a table is the _ _.

primary key

A foreign key is a field in one table that is also defined as a(n) _ _ in a different table.

primary key

When you change a field's property in Design view, you can _ , or update, the corresponding property on forms and reports that include the field you have modified.

propagate

The characteristics of a field that determine how it is stored and displayed are called the field _.

properties

Unlike calculations with Number data type decimal values, calculations performed with the Currency data type are not subject to _ _.

round-off error

When you select or enter a value for a property, you _ the property.

set

Although you can reorder fields in Datasheet view by dragging a field's column heading to a new location, doing so rearranges only the display of the table's fields; the table _ is not changed.

structure

The name that you use to save a table must be _ within the database.

unique

When you resize a column to its best fit, only the _ field values are affected.

visible