Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

The Report Header section prints ____. a. Once for every record b. At the top of

ID: 3667021 • Letter: T

Question

The Report Header section prints ____.

a.

Once for every record

b.

At the top of the first page

c.

At the top of every page

d.

Before every group of records

The Page Footer section prints ____.

a.

At the bottom of every page

b.

At the end of the first and last pages in the report

c.

Once for every group of records

d.

At the end of the entire report

This section prints once for every record.

a.

Report Header

b.

Detail

c.

Group Footer

d.

Group Header

The Report Footer section prints ____.

a.

At the top of every page

b.

At the bottom of every page

c.

At the end of the entire report

d.

At the top of the entire report

The Group Header section prints ____.

a.

Before every group of records

b.

At the top of the first page of the report

c.

At the top of every page

d.

Once for every record

Which section prints below the Report Header on page one?

a.

Page Footer

b.

Report Footer

c.

Page Header

d.

Report Header

This section generally constitutes the largest physical space on the report.

a.

Group Header

b.

Detail

c.

Group Footer

d.

Report Header

Which control is most commonly placed in the Report Header section?

a.

Label

b.

Subtotal

c.

Text box

d.

Check box

Which section would most likely contain page number and date expressions?

a.

Group Header

b.

Detail

c.

Page Footer

d.

Report Header

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

a.

Group Footer and Detail

b.

Group Header and Group Footer

c.

Group Summary and Detail

d.

Group Header and Detail

The Group Header and Group Footer section can be turned on or off in which pane?

a.

Field List

b.

Toolbox

c.

Properties

d.

Group, Sort, and Total

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

a.

=Count([City])

b.

=Count(City)

c.

=Count{City}

d.

=Count[City]

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

a.

=Sum[Quantity]

b.

=Sum([Quantity])

c.

=Sum{Quantity}

d.

=Sum(Quantity)

Filters are used to select a subset of records in a datasheet.

  True

  False

A query is commonly used as the source of data for a form or report.

  True

  False

Enter OR criteria on different Criteria rows in the query design grid.

  True

  False

Access is a relational database management system.

  True

  False

Bound controls exist only to clarify or enhance the appearance of the form.

  True

  False

You can add fields to a form in either Layout View or Design View.

  True

  False

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

  True

  False

The purpose of a report is to provide an easy-to-use data entry interface.

  True

  False

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

  True

  False

When using a wizard, you can click the Back button to review previous dialog boxes.

  True

  False

Portrait orientation is 8.5" wide by 13" tall.

  True

  False

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

  True

  False

a.

Once for every record

b.

At the top of the first page

c.

At the top of every page

d.

Before every group of records

Explanation / Answer

1.The report header section prints d) before every group of records.

2.The page footer section prints a) at the bottom of every page.

3.This section prints once for every record->b)Detail

4.The report footer section prints c)at the end of the entire report.

5.The group header section prints a) before every group of records.

6.Which section prints below the Report Header on page one?->c)page header

7.This section generally constitutes the largest physical space on the report.->b)Detail

8.Which control is most commonly placed in the Report Header section?->a)label

9.Which section would most likely contain page number and date expressions?->c)page footer

10.Which two sections can be added to a report if you group records?b) group header and group footer

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote