Access 2013 / 2016 - Advanced Training

Overview

Rating:
Duration:
( - Eastern)
Cost:
$285.00
Access 2013 / 2016 - Advanced Logo

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.

Live Online Schedule

  • Jul 27
  • Aug 3
  • Sep 7
  • Oct 12
  • Nov 16
  • Dec 7

Prerequisites

Microsoft Access 2013 / 2016 - Intermediate or equivalent knowledge.

Requirements

You will need the following software/setup for this class:

  • Microsoft Office 2013 or higher

Topics

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