Database Reference
In-Depth Information
In this exercise, you'll manually create a shell report that contains a Report Header section, a
Page Footer section, and a section in which you will add grouped data in a later exercise.
SET UP
You need the GardenCompany09 database located in the Chapter09 practice
file folder to complete this exercise. Be sure to use the practice database for this chapter
rather than continuing on with the database from an earlier chapter. Open the database,
and if you want, save your own version to avoid overwriting the original. Then follow the
steps.
1
Without selecting a table or query in the
Navigation
pane, on the
Create
tab, in the
Reports
group, click the
Report Design
button to display a blank report design grid
that has the default sections for a new report:
Page Header
,
Detail
, and
Page Footer
.
2
Right-click anywhere in the design grid, and then click
Report Header/Footer
to
enclose the default sections with
Report Header
and
Report Footer
sections.
Now let's add the category name from the Categories table to this form.
3
On the
Design
tool tab, in the
Tools
group, click the
Add Existing Fields
button to
open the
Field List
pane, which is currently empty because no source table or query
is selected in the
Navigation
pane.
KEYBOARD SHORTCUT
Press Alt+F8 to open and close the Field List pane. For a list
of keyboard shortcuts, see “Keyboard shortcuts” at the end of this topic.
4
In the
Field List
pane, click
Show all tables
9
The Field List pane displays a list of all the tables whose fields
you can add to the report.