more about forms and report. lesson plan more about forms simple reports demonstration of project 1...
TRANSCRIPT
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