1) Nicely presented informational reports used to make
decisions
2) Reports are often based on queries
3) When you create a report you are converting raw data
into information
4) Types of Reports:
(1)
All the fields
for a given record are in a single column
(2)
Each Page has
one record
(3)
Fields are
displayed in the same order as the underlying table
(1)
Selected fields
are displayed in a row instead of a column
(1)
Create reports
with similar field group
5) Sections to a report:
i)
Report Header
(1)
Located at the
beginning of the document above the page header
(2)
Appears only
once in the report
(3)
Contains a
descriptive title and a date
ii)
Report Footer
(1)
Located at the
end of the document above the page footer
(2)
Appears only
once in the report
(3)
Contains summary
information
iii) Page Header
(1)
Located at the
top of every page
(a)
Displays:
(i) Column headings
(ii) Page numbers
(iii) Other information
iv) Page Footer
(1)
Located at the
bottom of every page
(2)
Displays:
(i) Page numbers & other information
v)
Group Header
(1)
Located at the
beginning of a group of records
(2)
Title for group
vi) Group Footer
(1)
Located at the
end of a group of records
(2)
Summary
information about group
vii) Details Section
(1)
Displays one or
more fields from the underlying table
6) Design View for Reports:
i)
Controls
(1)
Bound
(a)
Connected to a
field in the underlying table
(2)
Unbound
(a)
Not connected to
a field in the underlying table
(3)
Calculated
ii)
Properties
(1)
Characteristics
or attributes of the objects in the report
1) With
the database window open, point to the object list on the left and click on “Reports”
i)
Double click on “Create report by using wizard”
ii)
Select your table or query
iii) Follow
self-explanatory steps in the wizard