Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?
Currency
AutoNumber
Calculated
Large Number
Which of the following shortcuts opens the Backstage view with the New button selected?
Ctrl+B
Ctrl+N
Ctrl+O
Ctrl+S
If the active cell is the last field of a record, which key moves to the first field of the next record in a datasheet?
Home
Ctrl+Home
Tab
Ctrl+Tab
Which of the following enables you to enter, modify, delete, or view data records?
Design view
Datasheet view
Form view
Layout view
Which of the following statements is not true when adding records in a table?
Click the first empty cell in the append row.
The append row asterisk changes to a pencil icon indicating that you are editing a record.
Press Shift+Tab to move to the next field.
If you enter a duplicate value for the primary key, Access displays an error message when you navigate out of the record.
Which of the following statements is not true for adding a total row?
You can summarize data in a table with a Total row.
A Total row is added above the append row.
You can add totals to multiple fields in the table.
As records are added or deleted, the totals automatically recalculate.
Which of the following options enables you to connect different tables to each other?
field
record
table
object
Which of the following should you use if you are going to apply several changes to the datasheet layout?
Navigation Pane
Table Layout
Datasheet Formatting dialog box
Properties dialog box
Which of the following is used to create an interface to view, add, update, and delete data in a table?
report
form
query
module
Which of the following is used to view and print the data in a database?
