Which of the following can you add to a form to automate user tasks?

text box

label

command button

check box

Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?

When using multiple conditional formatting rules, which of the following statements is true?

The order of the rules is unimportant.

The order of the rules is important.

Access continues to evaluate rules after a match is found.

all of the above

Which of the following is true about blank reports?

They use the tabular layout.

They use the stacked layout.

They don't contain any controls.

The header area contains a default title.

Which of the following grouping options would you want to use to group records based on the entire value in a selected field?

By entire value

By partial value

Custom

Ascending or descending sort

23

What is a text box that gets its value from a field in a table?

bound control

unbound control

calculated control

stacked control

Which of the following indicates that a control has been selected?

an orange border

a green border

a red border

a red dashed border

26

Which of the following should you use to restrict a form to only allow data entry when you don't want the user to be able to view data already in the database?

Allow Edits property

Allow Deletions property

Data Entry property

Tabular control layout

When adding totals to a report, which of the following calculation options totals up the values in a particular field?

Sum

Count Values

Max

Standard Deviation

28

In addition to selecting the rule type and conditions, what else must you select when building a rule?

command buttons

bound controls

a control layout

desired formatting

Which of the following can you use to print the current form, close the current form, navigate to the next record, or open another form?

text box

label

command button

check box