Days: 1
Prerequisites: Access 2000/XP/2003: Introduction or equivalent experience
Unit 1 : Creating relational databases
· Database normalization
· Relating tables
· Implementing referential integrity
Unit 2 : Working with related tables
· Using the Lookup Wizard
· Modifying Lookup fields
· Adding data to related tables
Unit 3 : Defining data entry rules
· Working with input masks
· Setting properties
· Setting validation rules
Unit 4 : Using advanced query features
· Joining tables in queries
· Creating calculated fields
· Using action queries
Unit 5 : Creating advanced queries
· Summarizing and grouping values
· Creating crosstab queries
· Using parameter queries
· Using indexes
Unit 6 : Enhancing forms
· Adding graphics
· Adding calculations
· Adding combo boxes
· Adding unbound controls
Unit 7 : Using advanced report features
· Creating customized headers and footers
· Adding calculated values
· Working with subreports
Unit 8 : Creating charts
· Creating charts in forms
· Creating charts in reports
· Appendix A : Database administration
· Compacting and repairing databases
· Backing up and restoring databases