Copy and Edit

Access 1

Description

Access 1 final review
Holly Harper
Quiz by Holly Harper, updated more than 1 year ago
Holly Harper
Created by Holly Harper over 4 years ago
4
0
0

Resource summary

Question 1

Question
Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?
Answer
  • Currency
  • AutoNumber
  • Calculated
  • Large Number

Question 2

Question
Which of the following shortcuts opens the Backstage view with the New button selected?
Answer
  • Ctrl+B
  • Ctrl+N
  • Ctrl+O
  • Ctrl+S

Question 3

Question
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?
Answer
  • Home
  • Ctrl+Home
  • Tab
  • Ctrl+Tab

Question 4

Question
Which of the following enables you to enter, modify, delete, or view data records?
Answer
  • Design view
  • Datasheet view
  • Form view
  • Layout view

Question 5

Question
Which of the following statements is not true when adding records in a table?
Answer
  • 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.

Question 6

Question
Which of the following statements is not true for adding a total row?
Answer
  • 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.

Question 7

Question
Which of the following options enables you to connect different tables to each other?
Answer
  • field
  • record
  • table
  • object

Question 8

Question
Which of the following should you use if you are going to apply several changes to the datasheet layout?
Answer
  • Navigation Pane
  • Table Layout
  • Datasheet Formatting dialog box
  • Properties dialog box

Question 9

Question
Which of the following is used to create an interface to view, add, update, and delete data in a table?
Answer
  • report
  • form
  • query
  • module

Question 10

Question
Which of the following is used to view and print the data in a database?
Answer
  • report
  • form
  • query
  • table
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Browse Library