Office Apps II Test 5: Quizzes
navigation pane
Before creating a form, select the table for the form in the _____.
make a backup copy
Before creating and running an action query, what should you do with the database?
Report tool
Bob wants to quickly create a report from the query he has selected in the navigation pane. Which report tool should he use?
Design view
If a report has been created using the Report Wizard, it is easier to edit the design of the report in the _____.
only
If you choose Whole Field for the Match option in the Find dialog box in the Report view, the characters you type in the Find What box must be the _____ characters in the field value in order to be found.
sum
In a Totals Query, to summarize and add the total amount in the Orders field, choose the _____ option on the Totals row under the Orders field.
Relationships line
In a multi-table query, to open the Join Properties dialog box, double-click on the _____.
########
In a report, if the _____ symbols appear in the Print Preview screen for a field, this means you need to widen the field so the numbers can be seen.
expressions
In the Access® program, formulas are called _____.
text box control
In the Detail section of a form in the Design view, which control must have the exact field name in it?
Filter
In the Report view, the _____ tool works similarly to the filter arrows in the Datasheet view of a table.
true
TRUE/FALSE: An AutoNumber field can be changed using an Update query.
true
TRUE/FALSE: When creating Forms, the Forms Wizard give you more options than the Form tool.
true
TRUE/FALSE: When creating a report with the Report Wizard, you can pick and choose which fields to include in the report.
entire
The Background Image tool places an image in the background of the _____ report.
report header
The Title tool quickly adds a title label box to the _____ section of a report.
Join Properties
The _____ dialog box is used to change the join type in a multi-table query.
Form Wizard
The easiest method to create a multi-table form is to use the _____.
Form tool
The fastest method to create a form is to use the _____.
main form
The navigation buttons at the very bottom of a multi-table form in the lower left corner are used to navigate through the records of the _____.
Design view
To add a footer to a form, you must open the Form Footer section in the _____.
Excel
To change the column widths of the subform in a multi-table form, use the same method to size the columns in _____ worksheets.
black down arrow
To delete a field from the query grid, point to the top of the column until the mouse pointer changes to a _____, and click. Then press the Delete key on your keyboard.
Ctrl+End
To navigate to the last record in a form, use the _____ keyboard shortcut.
Totals
To open the Totals row in a query, click on the _____ tool.
Property Sheet
To restrict data entry in a form, you must change the settings in the _____ of the form.
right-click
To see a shortcut list for applying filters in the Report view, you can _____ on the data in a field.
Shift
To select multiple controls at the same time in the report Design view, press the _____ key on your keyboard while clicking on the controls.
Totals tool
Total calculations such as Sum and Avg can be added to a report using the _____ in the Layout view.
Property Sheet
When a calculated field is created, the numbers are displayed in the general format. To change the format of a calculated field, you must use the _____ in the Design view.
Stepped
When creating a multi-table report with the Report Wizard, the _____ layout is the most commonly used layout.
one
When creating a multi-table report with the Report Wizard, the wizard automatically groups the data by the table fields from the _____ side of the table relationship.
table
When entering records using a form, the records are stored in the _____.
Select
Which one of the following is NOT an example of an action query: Select, Make Table, Append, Update
multi-table
a form that includes fields from two or more related tables
Zoom box
can be used to give you a larger area to type in when entering a calculated field in a query
portrait
default page orientation setting for reports
Layout view
form design view that shows real data in the text box controls instead of the field names
Field List
lists all of the fields that are available in a table
report header section
report design section that prints at the top of the first page only
descending
sort option that sorts in order from Z-A
*
symbol used for the criteria in a query is a wildcard that can be any characters and any number of characters
Is Null
the criteria used in a query to find records with nothing in the field
Themes tool
used to apply a theme to a form
Tab Order tool
used to change the tab order of a form
join
used to limit the records displayed from each table in a multi-table query
