Access section 1 – Flashcards
Unlock all answers in this set
Unlock answersquestion
What happens when you open an Access 2013 database from outside a trusted location?
answer
A security warning appears in the message bar.
question
What does it mean when a pencil icon appears in the record selector bar?
answer
The record is being edited.
question
You select a column in a table and then click the Filter button. What is displayed in the filter list box?
answer
each unique field value from the column
question
By default, Access prints a datasheet on
answer
letter size paper in portrait orientation.
question
Where will you find the Ascending button?
answer
in the Sort & Filter group on the HOME tab
question
A ____ is used to view only those records that meet the specified criteria.
answer
filter
question
You are using a form to view data in a table. Clicking the New button in the Records group on the HOME tab has this effect.
answer
adds a new, blank record to the table
question
In an Access table, each row is one ____ in the table.
answer
record
question
In a table with a primary key field, how are records displayed by default?
answer
sorted in ascending order by the primary key field values
question
For a table containing a primary key field called DistID, which of the following statements would be true?
answer
When a record is deleted from the table, the value in its DistID field will not be used again.
question
A ____ is a collection of data that has been organized so that the data can be easily stored, sorted, extracted, and reported.
answer
database
question
Where is the Delete button located?
answer
in the Records group on the HOME tab
question
As you drag a column to move it in a table, this appears between the columns indicating the position in which the column will be moved when you release the mouse.
answer
thick black line
question
Where are the Print and Print Preview options located in Access 2013?
answer
at the Print backstage area
question
Where is the Microsoft Access Help button located?
answer
in the upper right corner of the screen
question
The first object you create in an Access database is a
answer
table.
question
A _____ holds data that uniquely identifies each record in the table.
answer
primary key
question
How is Access different from other Microsoft Office applications?
answer
Only one file (in this case, a database) can be open at a time.
question
When scrolling in the middle of an Access table, pressing the Tab key will move you to the
answer
next field in the current record.
question
When a filter has been applied to a datasheet, clicking the Toggle Filter button will
answer
remove the filter.
question
The object at the left side of the Access screen that displays the objects in the database
organized into groups is the
answer
Navigation pane.
question
New records can be added to an Access table in either Datasheet view or ____ view.
answer
Form
question
This is the default file extension for an Access 2013 database.
answer
.accdb
question
Which of the following view is available for a report object but not for a table, query, or form?
answer
Print Preview
question
To move to the next record in Form view, use this keyboard shortcut.
answer
Page Down
question
Which of the following is not a component of an Access database?
answer
worksheet
question
To add a new record to a table in Datasheet view, begin by clicking the New record button located in the
answer
Record Navigation bar.
question
Which of the following database objects automates repetitive tasks?
answer
macro
question
What is the keyboard shortcut for selecting all records in a table, query, report, or form?
answer
Ctrl + A
question
Each _____ in an Access database represents a field.
answer
column
