Question 1

What is the main purpose of a form?

Accepted Answer

A)   to provide an easy-to-use format for entering and editing records
B)   to prevent changes to the data in tables
C)   to display records without allowing changes to them
D)   to preview the contents of reportsE) A) and C)
F) A) and D)

Question 2

To navigate to the first record in a form, first switch to Form Design view.

Accepted Answer

A) True 
 B)False

Question 3

You can create a table in Table Datasheet view or Table Design view.

Accepted Answer

A) True 
 B)False

Question 4

When you export table data to a PDF file, you need software such as _____ to view the data.

Accepted Answer

A)   Microsoft Excel
B)   an Access web template
C)   Microsoft Outlook
D)   Adobe ReaderE) A) and B)
F) B) and C)

Question 5

When you add a Yes/No field in Report Design view, what control(s)  does Access typically add to the report?

Accepted Answer

A)   a text box and a label
B)   a check box and a label
C)   only a check box
D)   only an option buttonE) None of the above
F) All of the above

Question 6

When you create a(n)  _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

Accepted Answer

A)   parameter
B)   summary
C)   action
D)   crosstabE) A) and D)
F) B) and C)

Question 7

_____ view provides the most options for defining fields.

Accepted Answer

A)   Field Create
B)   Field Define
C)   Table Create
D)   Table DesignE) None of the above
F) All of the above

Question 8

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Accepted Answer

A) True 
 B)False

Question 9

To rename a field in Table Datasheet view, you change the text in the _____.

Accepted Answer

A)   column heading
B)   first record
C)   primary key
D)   Navigation PaneE) All of the above
F) A) and B)

Question 10

What could you use to display the amount of a 25% discount on a form?

Accepted Answer

A)   a Total row
B)   a command button
C)   a calculated control
D)   a logoE) C) and D)
F) B) and C)

Question 11

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

Accepted Answer

A) True 
 B)False

Question 12

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

Accepted Answer

A)   Linked Table Manager
B)   Database Connector
C)   Database Documenter
D)   Table Location ManagerE) B) and D)
F) None of the above

Question 13

Which built-in Access function returns today's date?

Accepted Answer

A)   TodayDate
B)   Now
C)   Day
D)   DateAndTimeE) A) and D)
F) A) and C)

Question 14

The Display Control property of a _____ field is set to Combo Box by default.

Accepted Answer

A)   Short Text
B)   primary key
C)   lookup
D)   Date/TimeE) None of the above
F) B) and D)

Question 15

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

Accepted Answer

A)   Send
B)   Email
C)   Share
D)   AttachE) A) and B)
F) A) and C)

Question 16

To add a heading to the Detail section of a form, you use a text box control.

Accepted Answer

A) True 
 B)False

Question 17

What property would you use in an If statement to display a label in some records but not others?

Accepted Answer

A)   Visible
B)   On Current
C)   Else
D)   On DisplayE) C) and D)
F) A) and B)

Question 18

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

Accepted Answer

A)   Decrease the number of decimal places.
B)   Increase the number of decimal places.
C)   Apply the Percent format to the field.
D)   Apply the Comma Number format to the field.E) All of the above
F) None of the above

Question 19

Query Design view presents the fields you can use for a query in small windows called field _____.

Accepted Answer

A)   categories
B)   filters
C)   properties
D)   listsE) A) and D)
F) A) and B)

Question 20

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

Accepted Answer

A)   criterion
B)   data type
C)   validation rule
D)   relationshipE) All of the above
F) None of the above

Exam 8: Access

What could you use to display the amount of a 25% discount on a form?

Correct AnswerverifiedShow Answer

You can create a table in Table Datasheet view or Table Design view.

Correct AnswerverifiedShow Answer

The Display Control property of a _____ field is set to Combo Box by default.

Correct AnswerverifiedShow Answer

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

Correct AnswerverifiedShow Answer

Which built-in Access function returns today's date?

Correct AnswerverifiedShow Answer

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

Correct AnswerverifiedShow Answer

When you export table data to a PDF file, you need software such as _____ to view the data.

Correct AnswerverifiedShow Answer

To navigate to the first record in a form, first switch to Form Design view.

Correct AnswerverifiedShow Answer

What property would you use in an If statement to display a label in some records but not others?

Correct AnswerverifiedShow Answer

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Correct AnswerverifiedShow Answer

When you add a Yes/No field in Report Design view, what control(s) does Access typically add to the report?

Correct AnswerverifiedShow Answer

What is the main purpose of a form?

Correct AnswerverifiedShow Answer

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

Correct AnswerverifiedShow Answer

_____ view provides the most options for defining fields.

Correct AnswerverifiedShow Answer

Query Design view presents the fields you can use for a query in small windows called field _____.

Correct AnswerverifiedShow Answer

To add a heading to the Detail section of a form, you use a text box control.

Correct AnswerverifiedShow Answer

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

Correct AnswerverifiedShow Answer

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

Correct AnswerverifiedShow Answer

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

Correct AnswerverifiedShow Answer

To rename a field in Table Datasheet view, you change the text in the _____.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified