Exam 8: Advanced Report Techniques

To sign out of a Microsoft account, tap or click FILE on the ribbon to open the Backstage view and then tap or click the ____ tab.

If the primary key of the Seminar Offerings table contains the primary key for both the Customer table and Seminar table, there is a ____ relationship between customers and seminars.

Modified Multiple Choice The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting controls.

To add a concatenated field to a form, use the ____ tool in the Controls group on the FORM DESIGN TOOLS DESIGN tab.

To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

To use an item name that contains spaces, such as Amount Paid in a function, enclose the item name in ____.

To add a date to a report, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

If the ____________________ property is set to Yes, Access will remove blank lines that occur when the field is empty.

The contents of the ____ section are printed before the records in a particular group.

To concatenate text data, you use the asterisk (*) operator.

To add totals or other statistics to a footer, add a text box control.

Explain the difference between the Control Source property and the Record Source property.

A command button can display either text or a picture.

To preview a report when you are working in Design view, click Print Preview on the Report button menu.

To create a new query, tap or click the Query Design button on the CREATE tab.

When you change the font color using the ribbon, you tap or click the ____ button.

If a field on a form has the focus, a(n) ____________________ will appear in the field.

The row source for a report is the table or query that will furnish the data for the report.

To add a page number to a report, use the Report Footer button.

Modified Multiple Choice The aggregate functions available in Access are _____.