Question 1

When editing a record using a form, how can you move from field to field in the same record?

Accepted Answer

A)   Press TAB.
B)   Click the Next field button in the navigation bar.
C)   Press the PAGE DOWN key.
D)   Click the right arrow button in the navigation bar.

Question 2

Besides reducing file size, what other benefit does compacting an Access database provide?

Accepted Answer

A)   sorting the records in the database
B)   repairing the database
C)   saving the database
D)   relating tables in the database

Question 3

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

Accepted Answer

A)   First record button
B)   Next record button
C)   TAB key
D)   DOWN ARROW key

Question 4

Compacting a database has the same result as backing up a database.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements describe a query datasheet? Select all the options that apply.

Accepted Answer

A)   You can edit the records in a query datasheet.
B)   You store data in a query by entering a record in a query datasheet.
C)   You can display a subset of records and fields from a table in a query datasheet.
D)   You can sort and filter a query datasheet.

Question 6

Which of the following are Access data types? Select all the options that apply.

Accepted Answer

A)   Number
B)   Street Address
C)   Date/Time
D)   Currency

Question 7

You can use a report to enter a record into the database.

Accepted Answer

A) True 
 B)False

Question 8

What should you do if you want to make a copy of a database in a secure location?

Accepted Answer

A)   Back up the database.
B)   Compact and repair the database
C)   Convert the database.
D)   Split the database.

Question 9

Which of the following are features of Access reports? Select all the options that apply.

Accepted Answer

A)   headers
B)   calculations on groups of records
C)   easy-to-use data entry screens
D)   footers

Question 10

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Accepted Answer

A)   modify the report's design
B)   continue by creating a second report
C)   send the report to a colleague
D)   print the report

Question 11

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Accepted Answer

False - qu...

Question 12

Before you close a database, you must save any changes you made to the data.

Accepted Answer

A) True 
 B)False

Question 13

Database templates create tables and queries, but not forms and reports.

Accepted Answer

A) True 
 B)False

Question 14

When you use the _____, Access asks you for the information it needs to create a query.

Accepted Answer

A)   Create Query Wizard
B)   Form Wizard
C)   Query Design command
D)   Simple Query Wizard

Question 15

You use the Report tool to quickly create a report based on the selected table.

Accepted Answer

A) True 
 B)False

Question 16

You can assign most but not all data types to a field in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 17

Which data type stores only one of two values?

Accepted Answer

A)   Hyperlink
B)   Date/Time
C)   Yes/No
D)   AutoNumber

Question 18

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)   values
B)   objects
C)   fields
D)   controls

Question 19

What data type should you assign to a field that stores postal codes?

Accepted Answer

A)   Number
B)   Address
C)   Required
D)   Short Text

Question 20

What is the most efficient way to navigate to the last record in a table containing 100 records?

Accepted Answer

A)   Press the END key.
B)   Press TAB as many times as necessary.
C)   Use the Next record button on the navigation bar.
D)   Use the Last record button on the navigation bar.

Exam 1: Getting Started With Excel

When you use the _____, Access asks you for the information it needs to create a query.

Correct AnswerverifiedShow Answer

Which of the following are features of Access reports? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following statements describe a query datasheet? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

Correct AnswerverifiedShow Answer

When editing a record using a form, how can you move from field to field in the same record?

Correct AnswerverifiedShow Answer

What data type should you assign to a field that stores postal codes?

Correct AnswerverifiedShow Answer

Compacting a database has the same result as backing up a database.

Correct AnswerverifiedShow Answer

Which of the following are Access data types? Select all the options that apply.

Correct AnswerverifiedShow Answer

Before you close a database, you must save any changes you made to the data.

Correct AnswerverifiedShow Answer

Tables, queries, and forms are examples of Access ____.

Correct AnswerverifiedShow Answer

You can use a report to enter a record into the database.

Correct AnswerverifiedShow Answer

Database templates create tables and queries, but not forms and reports.

Correct AnswerverifiedShow Answer

What is the most efficient way to navigate to the last record in a table containing 100 records?

Correct AnswerverifiedShow Answer

What should you do if you want to make a copy of a database in a secure location?

Correct AnswerverifiedShow Answer

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

Correct AnswerverifiedFalse - qu...View AnswerShow Answer

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Correct AnswerverifiedShow Answer

Besides reducing file size, what other benefit does compacting an Access database provide?

Correct AnswerverifiedShow Answer

Which data type stores only one of two values?

Correct AnswerverifiedShow Answer

You use the Report tool to quickly create a report based on the selected table.

Correct AnswerverifiedShow Answer

You can assign most but not all data types to a field in Table Datasheet view.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False - qu...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified