CGS 2542

1
CGS 2542

• Tutorial 4
• Forms and Reports

2
Review Calculated Fields

• RaiseAmtSalarySalary .03

OR
RaiseAmtSalary1.03
3
Result
4
Forms

• Used to maintain, view and print records

5
Forms

• Source data from tables or queries
• Live data-alters underlying table data
• Delete records from table
• Saves automatically
• Print selected records

6
Form Wizard
7
Forms
8
Forms Design View
9
Forms
10
Subforms
Primary Table
Related Table
One-to-Many Relationship
11
Reports
Grouped by table
12
Report Design View
Photo or clip art
13
Reports
14
Review for Level 1 Test

• Create a Database
• Build Tables from Design View
• Establish Relationships
• Referential Integrity
• Cascading
• Build Queries with calculated fields
• Design Forms and Subforms
• Design Reports

15
Review for Level 1 Test

• Know how and when to save
• Know how to specify and change file names
• Database
• Tables
• Queries
• Forms and Reports
• Know how and what to print
• Be accurate

16
Homework

• Read the Appendix at the end of your book, pages
  AC A1-A27
• Take particular note of the Normalization
  discussion
• Open a Browser and type Ask.com in the address
  bar, hit enter. Type database normalization in
  the search window. Read as many articles and
  lessons as you can.
• Be prepared to discuss normalization the week
  after the test.

17
Lets do Project 5

• Digital Photos
• On Forms and Reports

18
Project 5 Teams
19
Form
20
Report