SIMnet Access Chapter 4 UPDATED
ACTUAL Exam Questions and CORRECT
Answers
When defining multiple conditional formatting rules, the order in which the rules are listed is not
important.
True or False - CORRECT ANSWER - False
To select multiple controls at once, what must you press and hold down while selecting controls?
a. F3
b. Alt
c. Ctrl
d. Shift - CORRECT ANSWER - d. Shift
For date fields, what is the default sort order?
a. newest to oldest
b. oldest to newest
c. largest to smallest
d. smallest to largest - CORRECT ANSWER - b. oldest to newest
Access allows you to sort on multiple fields only if each field is sorted in ascending order.
True or False - CORRECT ANSWER - False
When working with forms, which of the following views would you use if you want to view the
completed structure of the form so you can modify any aspect of the form?
a. Form view
b. Design view
c. Layout view
, d. Datasheet view - CORRECT ANSWER - b. Design view
Which of the following allows you to format only values that meet a specified condition?
a. Rules Manager
b. conditional formatting
c. split form
d. Report Wizard - CORRECT ANSWER - b. conditional formatting
Which of the following indicates that a control has been selected?
a. an orange border
b. a green border
c. a red border
d. a red dashed border - CORRECT ANSWER - a. an orange border
When adding totals to a report, which of the following calculation options totals up the values in
a particular field?
a. Sum
b. Report
c. Max
d. Standard Deviation - CORRECT ANSWER - a. Sum
What is the main advantage of using one of Access's control layouts when designing a form?
a. Control layouts provide structure.
b. Control layouts let you easily insert all of the fields in your data source into your form.
c. Control layouts provide visual appeal with varied themes.
d. Control layouts are compatible with other software applications. - CORRECT
ANSWER - a. Control layouts provide structure.
ACTUAL Exam Questions and CORRECT
Answers
When defining multiple conditional formatting rules, the order in which the rules are listed is not
important.
True or False - CORRECT ANSWER - False
To select multiple controls at once, what must you press and hold down while selecting controls?
a. F3
b. Alt
c. Ctrl
d. Shift - CORRECT ANSWER - d. Shift
For date fields, what is the default sort order?
a. newest to oldest
b. oldest to newest
c. largest to smallest
d. smallest to largest - CORRECT ANSWER - b. oldest to newest
Access allows you to sort on multiple fields only if each field is sorted in ascending order.
True or False - CORRECT ANSWER - False
When working with forms, which of the following views would you use if you want to view the
completed structure of the form so you can modify any aspect of the form?
a. Form view
b. Design view
c. Layout view
, d. Datasheet view - CORRECT ANSWER - b. Design view
Which of the following allows you to format only values that meet a specified condition?
a. Rules Manager
b. conditional formatting
c. split form
d. Report Wizard - CORRECT ANSWER - b. conditional formatting
Which of the following indicates that a control has been selected?
a. an orange border
b. a green border
c. a red border
d. a red dashed border - CORRECT ANSWER - a. an orange border
When adding totals to a report, which of the following calculation options totals up the values in
a particular field?
a. Sum
b. Report
c. Max
d. Standard Deviation - CORRECT ANSWER - a. Sum
What is the main advantage of using one of Access's control layouts when designing a form?
a. Control layouts provide structure.
b. Control layouts let you easily insert all of the fields in your data source into your form.
c. Control layouts provide visual appeal with varied themes.
d. Control layouts are compatible with other software applications. - CORRECT
ANSWER - a. Control layouts provide structure.
