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, add new, delete, 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
Aa Label Tool
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
Data Label Box
Data Value Box
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
• Use Digital Photos

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
• Draw an Entity-Relationship Diagram
• Know how and what to print

16
Homework

• Tutorial 4 Review Assignment
• Open a Browser and type ask.com or google.com in
  the address bar. Type database normalization in
  the search window. Read as many articles and
  lessons as you can.
• Be prepared to discuss normalization next week.
• Practice for your test
• Complete all assignments and projects for Level I
  prior to class

17
Lets do Project 5

• Digital Photos