Access Intermediate

Course Length: 1 day

Objective:Learn how to enhance databases
Prerequisites:Familiarity with Access Basics

Principles of Table DesignCustomizing Form Designs
Normalizing dataCustomizing the form design
Principles of Table RelationshipsPerforming calculating on a form
Analyzing table relationshipsAdding combo boxes to a form
Establishing and testing referential integrityAdding unbound controls
Table Design TechniquesWorking with Data Access Pages
Data validation techniquesCreating data access pages
Indexing techniquesIntegrating with other applications
Designing Select QueriesCustomizing Reports
Using calculated fields in queriesCustomizing a report created by the Report Wizard
Creating multiple-table queries 
  Working with subreports
   Creating a report in design view

 Course Registration

Course RateClasses Available

Webinar Schedule    Classes Available    CLE Classes    Floor Support    Help Desk