Microsoft Access 365 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 365 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