Microsoft Office Instructor-led Training and Support
Home     Classes and Prices     Course Catalog     About Our Classes     Registration     Your Instructor     Locations     Sitemap  

Microsoft Access 2013/2016 Level II - Course Content

One day

This Instructor-led Training course provides students with additional skills and concepts needed to use Microsoft Access 2013/2016 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

Table of Contents:

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