Mod 3 & 4

What happens when you apply a theme to a form?

The formatting changes in all forms and reports

To filter for comparative data, use the _____ feature.

Filter By Form

The easiest way to filter the records for an exact match is to use the _____ feature.

Filter By Selection

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Find and Replace

In Form Design view, you can make design changes while displaying the data.

False

In Report Layout view, you use the Format Painter to change the theme of a report.

False

In a datasheet, you can find data, but not replace it.

False

Sorting a table datasheet temporarily displays only those records that match given criteria.

False

Use Query Design view to display the results of a query.

False

As you create a report, when might you want to work in Report Layout view?

Not: When you want to view the report without any formatting

What are you doing when you enter data into a subdatasheet?

Not: You are enforcing referential integrity.

The two types of control layouts Access provides for forms are stacked and _____.

Not: subform

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

True

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

True

To create a report in Report Layout view, click the Blank Report button on the Create tab.

True

How can you display the title of a report in green?

Change the font color of the label in the Report Header.

What should you do before applying a new filter to a datasheet?

Clear all previous filters.

How do you display the records in a subdatasheet?

You click the expand button in the datasheet.

Using the Report Wizard, you can select the _____ for the report.

layout

Before you close a query datasheet, you must save your changes to the data.

False

Hiding a column in Table Datasheet view is that same as freezing the column.

False

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

#5/7/2021#

In Form view, how can you navigate to the previous record in the form?

Click the Previous record button on the navigation bar.

How do you display the results of a query listed in the Navigation Pane?

Double-click the query

A report is an easy-to-use data entry and navigation screen.

False

Alternate colors are a set of coordinated colors to apply to reports and other database objects.

False

Before closing a form in Form view, you must save changes you made to the data.

False

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

Report Layout view

Which Access tool guides you through the steps of creating a report?

Report Wizard

To apply the last filter you selected to a datasheet, you click the _____ button.

Toggle Filter

When using the Form Wizard, you can select fields from tables and _____ in the database.

queries

A _____ is a saved object within the database, whereas a _____ is temporary.

query; filter

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

subdatasheet

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

the positions offered by each employer