more about forms and report. lesson plan more about forms simple reports demonstration of project 1...

More about formsand Report

Lesson plan

• More about forms

• Simple reports

• Demonstration of project 1 (part 3)

More about forms

More about forms

Dim stDocName As String Dim stLinkCriteria As String

stDocName = "FormQuery1" DoCmd.OpenForm stDocName, , , stLinkCriteria

More about forms

More about forms

More about forms

Why do we need reports?

• Final product of most database applications is report

• Reports combine information from tables, queries, and forms

• Support paperless office

Forms and reports

• Differences:– Reports are intended for printing while

forms are intended for viewing/interacting with users

– Underlying data can’t be changed– No Datasheet view in report– Number of columns, width..etc are

controlled by Printer Setup

Reports in Access

• Group/totals report

• Tabular reports

• Others: Single-column report, Multi-column report, Mailing label, unbound report

Grouping report

Report -> New button -> Report Wizard

Grouping report

Grouping report

Grouping report

Grouping report

Grouping report

Grouping report

Grouping report

Using Grouping Option

Using Grouping Option

Using Grouping Option

Using Grouping Option

Practice

• Create a report contains:1. All students (ID, last name,

firstname) groupped by gender

2. All students (ID, last name, first name, major description) groupped by academic standing

Results (1)

Result (2)

Practice Exercise

5.123 Prince Hall C++456 West Hall C++789 Central Hall C++456 West Hall Browser456 West Hall Browser

Modifying a basic wizard report

• Deleting and Editing existing controls

Deleting and Editing existing controls

Deleting and Editing existing controls

Deleting and Editing existing controls

Adding controls

Adding calculated controls to a report

Adjusting Margins and Printing reports

Page Setup

Grouping data

• Grouping by numeric values

Grouping data

• Grouping by numeric values

Grouping data

• Grouping by alphabetic code characters

Grouping data

• Grouping by alphabetic code characters

Grouping data

• Grouping with subgroups

Grouping data

• Grouping with subgroups