Taking too long? Close loading screen.

Microsoft Access 2016 Level 2


You 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.

Who Should Attend

​This course is designed for persons who are able to create and modify basic tables, forms, and reports in Microsoft Access 2016, but need to know how to create or modify documents using advanced tools and efficiency procedures. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Access 2016®. Students should be able to use Microsoft Access 2016 to create and manage tables and basic queries, define product options, compare/contrast types of table relationships, navigate the Access 2016 environment. Students can obtain this level of skill by taking the following Axzo Press course:

  • Microsoft Office Access 2016 : Basic.

Course Outlines

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




Click one of our representatives below to chat on WhatsApp or send us an email to tope.ask@gmail.com

× How can I help you?