Access Lesson 5
Home Up Access Lesson 1 Access Lesson 2 Access Lesson 3 Access Lesson 4 Access Lesson 5

 

Student Objectives: Create a report using a Report Wizard.; Modify a report.

What is a database report?
1) A database report allows you to organize, summarize, and print all or a portion.
2) Reports can be used to print form letters and mailing labels.

How are database reports created?
1) Click Reports on the Objects bar and click the New button
2) The New Report Dialog box appears and choose whether you want to use a Report Wizard OR design the report manually by using the Design View. (Note: Charts and Mailing Labels are also created from this window)
3) Next, choose either the table or query that report will be based on.

What is grouping?
1) Grouping a report allows you to break it into parts based on the contents of a field. (Ex. You could organize a customers report into parts that group the customers by city).
2) Grouping can best be chosen in the Report Wizard feature. The user can group by one field or more than one field.

What is the use for Summary Options within a database report?
1) Summaries in a report group records that can be followed by totals, averages, or other summary information.

How can layout, orientation, and style options be used while creating database reports?
1) The layout options let you choose how you want data arranged on the page.
2) The orientation option lets the user decide if they want the page to be portrait (8 1/2 X 11-longer than wide) OR landscape (11 X 8 1/2- wider than long).
3) The style options are designed to give you some control over the report's appearance.  These options format or dress up the report.

How are database reports modified or changed?
1) Whether a report is created manually or automatically by using the Report Wizard, they can be modified by switching to Design view.
2) How do I do it? Open the report in Design view, select the report in the Database window, then click the Design button.

How are database reports divided?
1) Like a form, the report is divided into sections, where each is identified by a band.  Each section controls a part of the report and can be modified.
2) Below summarizes the purpose of each of the sections in the report.
    
Report Header: Contents appear at the top of the 1st page of the report.
     Page Header:  Contents appear at the top of each page of the report.
     Category Header:  Contents appear at the top of each group.
     Detail:  Specifies the fields that will appear in the detail of the report.
    Category Footer: Contents appear at the end of each group.
     Page Footer:  Contents appear at the end of each page of the report.
    Report Footer:  Contents appear at the end of the report.