Holly Harper
Quiz by , created more than 1 year ago

Access 1 final review

4
0
0
Holly Harper
Created by Holly Harper over 4 years ago
Close

Access 1

Question 1 of 10

1

Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?

Select one of the following:

  • Currency

  • AutoNumber

  • Calculated

  • Large Number

Explanation

Question 2 of 10

1

Which of the following shortcuts opens the Backstage view with the New button selected?

Select one of the following:

  • Ctrl+B

  • Ctrl+N

  • Ctrl+O

  • Ctrl+S

Explanation

Question 3 of 10

1

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?

Select one of the following:

  • Home

  • Ctrl+Home

  • Tab

  • Ctrl+Tab

Explanation

Question 4 of 10

1

Which of the following enables you to enter, modify, delete, or view data records?

Select one of the following:

  • Design view

  • Datasheet view

  • Form view

  • Layout view

Explanation

Question 5 of 10

1

Which of the following statements is not true when adding records in a table?

Select one of the following:

  • 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.

Explanation

Question 6 of 10

1

Which of the following statements is not true for adding a total row?

Select one of the following:

  • 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.

Explanation

Question 7 of 10

1

Which of the following options enables you to connect different tables to each other?

Select one of the following:

  • field

  • record

  • table

  • object

Explanation

Question 8 of 10

1

Which of the following should you use if you are going to apply several changes to the datasheet layout?

Select one of the following:

  • Navigation Pane

  • Table Layout

  • Datasheet Formatting dialog box

  • Properties dialog box

Explanation

Question 9 of 10

1

Which of the following is used to create an interface to view, add, update, and delete data in a table?

Select one of the following:

  • report

  • form

  • query

  • module

Explanation

Question 10 of 10

1

Which of the following is used to view and print the data in a database?

Select one of the following:

  • report

  • form

  • query

  • table

Explanation

Previous
Next