Access

record

A group of related fields, such as all the demographic information for one customer, is called a(n) _____.

True

A primary key field uniquely identifies each record.

field

A specific category of data such as a customer's name, city, state, or phone number is called a(n) _____.

False

Access databases cannot be password protected.

False

An Access database is limited to a size of 1 gigabyte.

Database

Microsoft Access 2016 can best be described as _____ software.

True

More than one person can enter, update, and analyze data in an Access database at the same time.

True

No two records can have the same value in the primary key field.

True

Press [Esc] once to undo a change to the current field.

True

Pressing [Ctrl] [;] will insert the current date in a Date field.

True

The linking field on the "many" side of a one-to-many relationships is called the foreign key field.

False

The navigation buttons on a datasheet display the total number of fields in the datasheet.

[Home]

Which shortcut key moves focus to the first field of the current record?

[Shift] [Tab]

Which shortcut key moves focus to the previous field of the current record?

Field name and data type

Which two properties are required for every field?

Removes all changes to the records you are currently editing

While editing a record, pressing [Esc] a second time _____.

Referential

_____ integrity refers to a set of Access files that govern data entry and helps to ensure data accuracy.

Table design

_____ view provides the most options for defining fields.

shuttle bar open/close button

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

[Enter]

In Navigation mode, press [Tab] or _____ to move to the next field within the same record.

Edit mode

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

True

Values in an AutoNumber field are automatically created by Access.

Recalibrating an existing database

Which of the following is NOT available to you as you start Access?

True

"Focus" refers to which data you would edit if you started typing.

True

A Subdatasheet shows the records on the "many" side of a one-to-many relationship.

navigation pane

Each object in an Access database application displays at the left side of the Access window in the _____.

True

Field properties change depending on the data type of the field.

False

If a number has already been incremented beyond 1 for a first record in a fields of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

True

Tables contain all of the data in the database.

object

Tables, queries, and forms are examples of Access _____.

True

The [F2] key switches between Edit and Navigation modes.

Table

Which Access object contains all of the raw data within the database?

Form

Which Access object provides an easy-to-use data entry screen?

AutoNumber

Which data type is used for sequential integers controlled by Access?

Attachment

Which data type links files created in other programs such as pictures or documents?

Hyperlink

Which data type stores Web addresses?

Yes/No

Which data type stores only one of two values?

Formula

Which if the following is NOT a data type?

Easy-to-use data entry screen

Which is NOT a feature of Access reports?

Reporting is limited to 20 saved reports

Which is NOT true about Access?

[Ctrl] [End]

Which keystroke combination moves focus to the last field of the last record?