Office Apps II Test 5: Quizzes

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

CompTIA Security+ 501 Topic 2, Volume B

View Set

Fundamentals of nutrition Chapter two

View Set

SOCY 101 Chapter 1 reading quiz questions

View Set

Law of Contacts - Check Knowledge

View Set

Psicología del trabajo y de las organizaciones

View Set

IS 52 Final- Questions about concepts/key terms

View Set