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

Duration:
One day


Description:
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