Access 4 Simnet Quiz UPDATED ACTUAL
Exam Questions and CORRECT Answers
Use the Property Sheet of the form to select the desired settings to limit actions available in a
form - CORRECT ANSWER - True
When adding totals to a report, which of the following calculation options counts up the number
of records that meet a certain condition - CORRECT ANSWER - Count Values
Which of the following report layouts displays fields in a horizontal layout? - CORRECT
ANSWER -
A text box that gets its value from an expression is a calculated control. - CORRECT
ANSWER - True
To organize controls vertically on a form, use a tabular layout. - CORRECT ANSWER -
False
What does Access call a form that is directly connected to a table or query, the source of the
data? - CORRECT ANSWER - Bound form
Which of the following is used to perform an action such as Close Form, Open Form, Delete
Record, and so on? - CORRECT ANSWER - Command button
Access allows you to sort on multiple fields only if each field is sorted in ascending order. -
CORRECT ANSWER - False
The Conditional Formatting Rules Manager only displays rules for one field at a time. -
CORRECT ANSWER - True
, A split form allows you to see many records at once in the Datasheet view while giving you
access to edit a single record. - CORRECT ANSWER - True
Which of the following grouping options would you want to use to group records by the first
character of a field? - CORRECT ANSWER - By partial value
Some form controls are unbound, which means that they are not linked to a data source. -
CORRECT ANSWER - True
An ascending sort for a date field is 'from oldest to newest.' - CORRECT ANSWER - True
When using multiple conditional formatting rules, which of the following statements is true? -
CORRECT ANSWER - The order of the rules is important.
Which of the following creates a button and attaches all of the necessary functionality to the
button? - CORRECT ANSWER - Command Button Wizard
It is a good design practice to add a title to a form. - CORRECT ANSWER - True
Where are a report's title, the current date, and page numbers typically placed in a report? -
CORRECT ANSWER - Page Header and Page Footer areas
A stepped report layout displays the fields in a horizontal, justified layout. - CORRECT
ANSWER - False
When defining multiple conditional formatting rules, the order in which the rules are listed is not
important. - CORRECT ANSWER - False
For date fields, what is the default sort order? - CORRECT ANSWER -
Exam Questions and CORRECT Answers
Use the Property Sheet of the form to select the desired settings to limit actions available in a
form - CORRECT ANSWER - True
When adding totals to a report, which of the following calculation options counts up the number
of records that meet a certain condition - CORRECT ANSWER - Count Values
Which of the following report layouts displays fields in a horizontal layout? - CORRECT
ANSWER -
A text box that gets its value from an expression is a calculated control. - CORRECT
ANSWER - True
To organize controls vertically on a form, use a tabular layout. - CORRECT ANSWER -
False
What does Access call a form that is directly connected to a table or query, the source of the
data? - CORRECT ANSWER - Bound form
Which of the following is used to perform an action such as Close Form, Open Form, Delete
Record, and so on? - CORRECT ANSWER - Command button
Access allows you to sort on multiple fields only if each field is sorted in ascending order. -
CORRECT ANSWER - False
The Conditional Formatting Rules Manager only displays rules for one field at a time. -
CORRECT ANSWER - True
, A split form allows you to see many records at once in the Datasheet view while giving you
access to edit a single record. - CORRECT ANSWER - True
Which of the following grouping options would you want to use to group records by the first
character of a field? - CORRECT ANSWER - By partial value
Some form controls are unbound, which means that they are not linked to a data source. -
CORRECT ANSWER - True
An ascending sort for a date field is 'from oldest to newest.' - CORRECT ANSWER - True
When using multiple conditional formatting rules, which of the following statements is true? -
CORRECT ANSWER - The order of the rules is important.
Which of the following creates a button and attaches all of the necessary functionality to the
button? - CORRECT ANSWER - Command Button Wizard
It is a good design practice to add a title to a form. - CORRECT ANSWER - True
Where are a report's title, the current date, and page numbers typically placed in a report? -
CORRECT ANSWER - Page Header and Page Footer areas
A stepped report layout displays the fields in a horizontal, justified layout. - CORRECT
ANSWER - False
When defining multiple conditional formatting rules, the order in which the rules are listed is not
important. - CORRECT ANSWER - False
For date fields, what is the default sort order? - CORRECT ANSWER -
