-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?

By entire value

By partial value

Custom

Ascending or descending sort

-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

-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

-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

-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

-Some form controls are unbound, which means that they are not linked to a data source.

True

False

-Which of the following creates a button and attaches all of the necessary functionality to the button?

Conditional Formatting Rules Manager

control layouts

Property Sheet

Command Button Wizard

-An ascending sort for a date field is 'from oldest to newest.'

True

False

-It is possible to click and drag a field into the report window to add it into the control layout.

True

False

-When a new blank form is created, there are no controls initially placed on the form.

True

False

-The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

True

False

-When adding totals to a report, which of the following calculation options counts up the number of records that meet a certain condition?

Sum

Count Values

Max

Standard Deviation