Font size:

This course builds on the skills and concepts taught in the Introduction course. Students will learn relational database concepts and techniques, advanced queries, advanced form and report building, and how to create charts. This course will help students prepare for the Microsoft Office Specialist exam for Access 2016. For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Access.

Access 2013 / 2016 - Intermediate

  • Relational databases
    • Database normalization
    • Table relationships
    • Referential integrity
  • Related tables
    • Creating lookup fields
    • Modifying lookup fields
    • Subdatasheets
  • Complex queries
    • Joining tables in queries
    • Using calculated fields
    • Summarizing and grouping values
  • Advanced form design
    • Adding unbound controls
    • Graphics
    • Adding calculated values
    • Adding combo boxes
    • Advanced form types
  • Reports and printing
    • Report formatting
    • Calculated values and subreports
    • Printing
    • Label printing
  • Charts
    • Charts in forms
    • Charts in reports
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live3/15/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632618
Virtual Live4/10/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632622
Virtual Live5/10/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632624
Virtual Live6/12/2018 10:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day475.002632626
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items