Instruction provided by:

251-343-2112
www.TheComputerTrainers.com

 

Microsoft Access 2003: Intermediate

 

Audience: This course is designed for any student seeking a greater knowledge of how to use Microsoft Office Access. This is the second of an optional three-class set.

 

Syllabus: This course will incorporate both real-life labs and instructor-led lectures and will include 8 hours of total class time. The following is an outline of the syllabus directly from the learning guide:

 

· Relational databases

· Database normalization

· Relating tables

· Implementing referential integrity

· Working with related tables

· Lookup fields

· Modifying Lookup fields

· Subdatasheets

· Complex queries

· Joining tables in queries

· Creating calculated fields

· Summarizing and grouping values

· Advanced form design

· Adding unbound controls

· Graphics

· Adding calculated values

· Adding combo boxes

· Advanced reports

· Creating customized headers and footers

· Adding calculated values

· Sub-reports

· Charts

· Charts in forms

· Charts in reports

· PivotTables and PivotCharts

· PivotTables

· Modifying PivotTables

· PivotCharts

· Internet integration

· Hyperlink fields

· Working with data access pages

 

Instructor: Valerie Dow
Contact: 343-2112, or e-mail val@thecomputertrainers.com