16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

Access 2016: Level 2

Available Dates: June 16, July 17, Aug 8, Sept 13, Oct 12, Nov 10, Dec 11
Class Length: 1 day
Cost: $199

Class Outline:


This course builds on the skills and concepts taught in Access: Level 1. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; as well as create and modify charts.

Course Outline:
Unit 1: Relational databases
Topic A: Database normalization
Topic B: Table relationships
Topic C: Referential integrity

Unit 2: Related tables
Topic A: Creating lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets

Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values

Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types

Unit 5: Reports and printing
Topic A: Report formatting
Topic B: Calculated values and subreports
Topic C: Printing
Topic D: Label printing

Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports