Illustrated

Access 2016 | Module 4: SAM Project 1b

Seminars Database

USING REPORTS

GETTING STARTED

?

Open the file

IL_AC16_4b_

FirstLastName

_1.accdb

, available for download

from the SAM website.

?

Save the file as

IL_AC16_4b_

FirstLastName

_2.accdb

by changing the “1” to

a “2”.

?

Hint

:

If you do not see the

.accdb

file extension

in the Save As file dialog box,

do not type it. Access will add the file extension for you automatically.

?

Open the

_GradingInfoTable

table a

nd ensure that your first and last name is

displayed as the first record in the table. If the table does not contain your

name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1

Use the Report Wizard to create a report based on the

Events

table with the

following options:

a.

Include these fields from the

Events

table in the report:

EventID

,

EventName

,

Location

,

EventDate

, and

AvailableSpaces

.

b.

Do not include any additional grouping levels in the report.

c.

Sort the records in the report in

ascending

order by the

EventID

field.

d.

Choose the

Tabular

layout and the

Portrait

orientation for the report.

e.

Set the title of the report to

Event Master List

, then preview the report.

1.

Switch to Layout View for the

Event Master List

report, then make the following

modifications. (

Hint

: If the Field List opens, close it.)

Change the page orientation to

Landscape

.

Resize the Available Spaces label and text box by dragging the right edge of the controls

to clearly display all information (about 0.5”), as shown in Figure 1 on the next page.

Change the Event Name label text to

Event

.

Your report should match Figure 1 on the next page. Save and close the

Event

Master List

report.

Figure 1: Event Master List Report

2.

Use the Label Wizard to create mailing labels for all of the records in the

Attendees

table using the following options:

Choose the

Avery

labels with the product number

5096

.

Change the font size to

12 pt.,

but keep the other default font and color options. (

Hint

:

The default options include Arial, Light (font weight), black, no italics, no underline.)

In the first line of the prototype label, insert the

AttendeeFirstName

field, a space, and

the

AttendeeLastName

field, then press

Enter

.

In the second line of the prototype label, insert the

Title

field, then press

Enter

.

In the third line of the prototype label, insert the

CompanyName

field. The prototype

label should now match Figure 2 on the next page.

Sort the labels using the

AttendeeLastName

field first, then the

AttendeeFirstName

field.

Name the report

NameTags

, then preview the labels. (

Hint

: If you receive the message

“Some data may not be displayed,” click OK.)

Save and close the

NameTags

report.

Figure 2: Prototype Label

3.

Open the

Event Registration

report in Design View, then narrow the report by

dragging the right edge of the report as far to the left as possible, to the 10"

mark on the horizontal ruler.

4.

With the

Event Registration

report still open in Design View, change the text in

the Event Registration label in the Report Header section to

Event Roster

, then

bold the text in the label.

5.

With the

Event Registration

report still open in Design View, select the

RegistrationFee text box (in the Detail section), then right-align the contents

within the text box.

6.

With the

Event Registration

report still open in Design View, select all of the

label controls in the Page Header section at the same time, then change the

font color to

Automatic

(black).

7.

Click the EventID Header section bar, then change the Alternate Row Color to

No Color

in the Property Sheet. (

Hint

: Use the Alternate Back Color property’s

list arrow.)

8.

With the

Event Registration

report still open in Design View, open the Group,

Sort, and Total pane, then open the EventID Footer section.

9.

Add a second sort order to the report to sort by the

AttendeeFirstName

field.

The report should now be grouped by

EventID

and sorted by the

AttendeeLastName

field, then by the

AttendeeFirstName

field.

10.

Add a text box control to the EventID Footer section containing the expression

=Sum([RegistrationFee])

to subtotal the RegistrationFee for each event.

11.

Apply the

Currency

format to the new =Sum([RegistrationFee]) calculation.

12.

With the

Event Registration

report still open in Design View, drag the bottom

edge of the Report Footer section down to about 0.5".

13.

Copy the new text box control that you just added to the EventID Footer section

and paste it in the Report Footer section. (

Hint

: Both the text box and its

accompanying label will be copied and pasted.)

14.

Modify the new label in the EventID Footer section to read

Fees per event:

.

(

Hint

: Include the colon.)

15.

Modify the new label in the Report Footer section to read

Total fees:

. (

Hint

:

Include the colon.)

16.

With the

Event Registration

report still open in Design View, align the right edge

of the

RegistrationFee

text box in the Detail section with the new

=Sum([RegistrationFee]) text boxes in both the EventID Footer and Report

Footer sections. (

Hint

: Make sure that the right edge of the report is still at the

10" mark on the horizontal ruler.)

17.

Align the right edge of the CompanyName text box in the Detail section with the

new “Fees per event:” label in the EventID Footer and with the “Total fees:”

label in the Report Footer section.

18.

Add a new text box to the Report Footer section at about the 2" mark on the

horizontal ruler with the following options:

Enter the expression

=Count([RegistrationFee])

in the text box. (

Hint

: This expression

will count the total number of records in this report.)

Modify the accompanying label to read

Total attendees:

. (

Hint

: Include the colon.)

Switch to Print Preview and preview the report. A portion of the last page of the report is

shown in Figure 3 below. Save and close the

Event Registration

report.

Figure 3: Final Event Registration Report

Save and close any open objects in your database. Compact and repair your database,

close it, then exit Access. Follow the directions on the SAM website to submit your

completed project.

pur-new-sol

Related Questions