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
