Question 1

The report section before a group of records is called the Group ____________________ section.

Accepted Answer

Header

Question 2

Koch labels are the most common manufacturer of labels, and therefore the default choice.

Accepted Answer

A) True 
 B)False  False

Question 3

Which report view's primary purpose is to quickly review the first page of the report?

Accepted Answer

A)   Print Preview
B)   Layout View
C)   Design View
D)   Report View D

Question 4

The Report Header section prints ____.

Accepted Answer

A)   At the top of every page
B)   At the top of the first page
C)   Before every group of records
D)   Once for every record

Question 5

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

Accepted Answer

The answer of Tables, queries, forms, and reports can all...

Question 6

In the expression =Sum([Price]), the ____________________ function is used.

Accepted Answer

The answer of In the expression =Sum([Price]), the ____________________ function...

Question 7

In the figure above, item 3 points to the ____ section.

Accepted Answer

A)   Page Footer
B)   Group Footer
C)   Report Footer
D)   Detail

Question 8

In the figure above, item 1 points to the ____ section.

Accepted Answer

A)   Group Header
B)   Page Header
C)   Detail
D)   Page Footer

Question 9

In the figure above, item 2 points to a Group Footer section.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: Center
Underline
Align Text Left
Alternate Row color
Font Color
Align Text Right
Bold
Italic

Accepted Answer

The Answer of Item 7 and Item 8 and Item is...

Question 11

In the figure above, item 5 points to the ____.

Accepted Answer

A)   Page number
B)   Next Page button
C)   Previous Page button
D)   Last Page button

Question 12

Which two sections can be added to a report if you group records?

Accepted Answer

A)   Group Header and Group Footer
B)   Group Header and Detail
C)   Group Footer and Detail
D)   Group Summary and Detail

Question 13

Marshall plans to generate reports from an Access table using the Report Wizard.The table contains information about the equipment he uses in his lawn and landscape business, with the following field names:  EquipmentID, EquipmentType (mower, blower, trimmer, so forth), EquipmentDescription, BrandName, SerialNo, DateofPurchase, PurchasePrice.How could Marshall design a report to quickly organize his equipment by most expensive to least expensive?

Accepted Answer

The answer of Marshall plans to generate reports from an...

Question 14

Which report creation tool is similar to the Form Wizard?

Accepted Answer

A)   Report Design View
B)   Report Layout View
C)   Object Wizard
D)   Report Wizard

Question 15

Access reports can be based on either a table or query object.

Accepted Answer

A) True 
 B)False

Question 16

The Report Footer section prints ____.

Accepted Answer

A)   At the end of the entire report
B)   At the bottom of every page
C)   At the top of the entire report
D)   At the top of every page

Question 17

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

Accepted Answer

A) True 
 B)False

Question 18

You can both group and sort records on the same report.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the correct expression to count the number of records using a field named City?

Accepted Answer

A)   =Count([City]) 
B)   =Count[City]
C)   =Count(City) 
D)   =Count{City}

Question 20

Calculated expressions within text boxes start with an equal sign.

Accepted Answer

A) True 
 B)False

Exam 4: Using Reports Question

The report section before a group of records is called the Group ____________________ section.

Koch labels are the most common manufacturer of labels, and therefore the default choice.

Which report view's primary purpose is to quickly review the first page of the report?

The Report Header section prints ____.

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities.What central feature of tables, queries, and forms is not shared by reports?

In the expression =Sum([Price]), the ____________________ function is used.

In the figure above, item 3 points to the ____ section.

In the figure above, item 1 points to the ____ section.

In the figure above, item 2 points to a Group Footer section.

Match each numbered item in the figure above with its button name.

In the figure above, item 5 points to the ____.

Which two sections can be added to a report if you group records?

Which report creation tool is similar to the Form Wizard?

Access reports can be based on either a table or query object.

The Report Footer section prints ____.

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

You can both group and sort records on the same report.

Which of the following is the correct expression to count the number of records using a field named City?

Calculated expressions within text boxes start with an equal sign.