Font size:

This course builds on the skills and concepts taught in the Introduction and Intermediate courses. Students will learn advanced querying techniques, how to work with macros, how to import, export and link objects, and how to utilize advanced database management techniques. 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 - Advanced

  • Querying with SQL
    • SQL and Access
    • Writing SQL statements
    • Attaching SQL queries to controls
  • Advanced queries
    • Creating crosstab queries
    • Creating parameter queries
    • Using action queries
  • Macros
    • Creating, running, and modifying macros
    • Attaching macros to the events of database objects
  • Advanced macros
    • Creating macros to provide user interaction
    • Creating macros that require user input
    • Creating AutoKeys and AutoExec macros
    • Creating macros for data transfer
  • Importing, exporting, and linking objects
    • Importing objects
    • Exporting objects
    • Working with XML documents
    • Linking Access objects
    • Using hyperlink fields
  • Database management
    • Optimizing resources
    • Protecting databases
    • Setting options and properties
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 Live2/21/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.002631891
Virtual Live3/16/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.002631894
Virtual Live4/11/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.002631897
Virtual Live5/11/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.002631900
Virtual Live6/13/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.002631903
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 5 of 5 items