Exam 8: Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Data sources created and saved in Word as part of the Mail Merge process use the _____ extension.​

A hyperlinked custom show is a separate (secondary) presentation that is linked to a primary custom show or presentation.

You use Microsoft's free Office Presentation Service to deliver a presentation over the ____________________.

How are lines used in a typical Access report?

It is necessary for every report to have Report Header and Report Footer sections.

The _____ function extracts a single record from a table that matches criteria.​

Categories, such as last name and street address, are data fields.

The Format ____________________ is a tool used to copy formatting properties from one control to another.

You cannot merge directly to an e-mail message.​

To create or change the return address for an envelope mail merge, use the ____ dialog box.

The ____ feature provides information on whether a presentation can be fully functional in earlier versions of PowerPoint.

Peter has a table with customer data organized with the customer names in column A, phone numbers in column B, their city in column C, and their annual revenue in column D. To assist the marketing department in an upcoming direct mail campaign, he is asked to provide customer information from the table data. If the marketing department asks for a list of customers who live in either Boston or New York, which logical condition should Peter use in a custom filter?

Which section prints at the top of the first page of the report?

When setting up a slide show, you can also add a(n) synchronized voice that narrates the presentation, and set either manual or automatic slide timings. _________________________

The expression =Sum([Price]) is contained in a text box in both the Category Footer as well as Report Footer sections.  Explain the difference between these two controls.

The report's ____ property determines what table or query provides the fields and records for a report.

Click the ____ option button in the Mail Merge task pane to use an Outlook contact list as a data source for a merge.

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

Which Excel feature allows you to specify what data users can enter in a range of cells?