MQ Access S4 Exam
At a minimum, how many fields are used in a crosstab query?
3
Which of the following query wizards must be run using two tables?
Find Unmatched
Display a form in this view to add a text box control object.
Layout
Begin the Find Duplicates Query Wizard by clicking the Create tab, clicking the Query Wizard button, clicking Find Duplicates Query Wizard in the _____, and then clicking OK.
New Query dialog box
Click the Totals button in the Show/Hide group on the Query Tools Design tab and a Total row is added to the query design between the Table and _____ rows.
Sort
A calculation can be inserted in a report using the _____ button in the gallery in the Controls group on the Report Layout Tools Design tab.
Text Box
What happens when you complete the Label Wizard steps?
The labels report opens in Print Preview
What feature does Access use to apply font formatting options to values in a report that meet certain criteria?
conditional formatting
A(n) _____ query calculates an aggregate function in which field values are grouped by two fields.
crosstab
You want to create a list of employees with no absences. Which query should you use?
find unmatched
Use the Add a group button in the Group, Sort, and Total pane to choose the field by which records should be
grouped.
What information do you supply in the first dialog box of the Find Duplicates Query Wizard?
the table or query you want to search for duplicate field values
Which of these statements is true concerning mailing labels and Access?
Use the Label Wizard in the Reports group to create mailing labels in Access.
Files in a database can become fragmented when records and objects have been deleted. What Access button helps remedy such a situation?
Compact & Repair Database
To compact a database, begin by clicking the
Compact & Repair Database button at the Info backstage area.
Click the _____ button on the Report Layout Tools Format tab to open the dialog box in which you specify the criterion and the formatting to apply to a field based on its value.
Conditional Formatting
Which button in the Position group on the Report Layout Tools Arrange tab is used to control spacing between rows in a report?
Control Padding
The gallery in the _____ group on the Form Layout Tools Design tab contains buttons for inserting control objects in a form.
Controls
Use the Ascending button or _____ button in the Sort & Filter group on the Home tab to sort data in a form.
Descending
What icon appears on the Text Box button?
a lowercase a and b
What information do you supply in the final dialog box in the Find Duplicates Query Wizard?
a name for your query
Sum, Avg, Max, Min, and Count are considered a(n) _____ function.
aggregate
What icon appears on the Label button on the Form Layout Tools Design tab?
an uppercase A and a lowercase a
You are working with a report in Layout view and you click the Group & Sort button. Where does the Group, Sort, and Total pane appear?
at the bottom of the work area
What default time interval does the crosstab query use to summarize the data?
quarter
The first field you choose in the Crosstab Query Wizard becomes the
row heading.
