Exam 7: Advanced Report Techniques

To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

The expression =[First Name]&' '&[Last Name] is entered in a text box on the Business Analyst Master List. What is the result of this expression?

To use a wizard to add a subreport, the ____________________ button must be selected when you click the Subform/Subreport tool on the Design tab.

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

To display the property sheet for grouped controls, click the ____________________ button on the Design tab.

To specify a primary key consisting of more than one field, click the row selector for the first field, hold down the ____________________ key while clicking the row selector for the second field, and then click the Primary Key button.

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

The Business Analyst Master List shown in the accompanying figure displays in Design view. To view the report in Print Preview, click the ____________________ button arrow and then click Print Preview on the menu.

When you create a report in Design view, the initial report that displays in the Design window contains all the fields in the underlying table or query.

To assign a conditional value, use the _____ function.

The Business Analyst Master List Report shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed after the records in a particular group.

To add a title to a report, click the _____ button on the Design tab.

To delete a control from a report, click the control and then press the _____ key(s).

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

If the primary key of the Course Offerings table contains the primary key for both the Client table and Course table, there is a _____ relationship between clients and seminars.

Describe three ways that you can create a calculated field in a query.

To spread data over two lines, change the value of the _____ property.

Critical Thinking Questions Case 6-2 An employee at Camashaly Design has created an additional report that needs some minor adjustments. The report includes a date but she would like to change the blue color assigned to the date. She also needs to adjust the margins. How can the employee change the color of the date?

To periodically view a report to gauge how it will look containing data, click _____ on the View menu.