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?
