Taking too long? Close loading screen.

Microsoft Access 2016 Level 3

Overview

​In Microsoft Access 2016 Level 3 students will learn advanced features of Access. Topics covered include querying with SQL, writing advanced queries, working with macros, importing, exporting and linking objects, and performing database maintenance.

Who Should Attend

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. This course will also assist students preparing for the Microsoft Office Specialist exam for Microsoft Access 2016. ​To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is required. Students should attend Microsoft Access 2016 Level 1 and Microsoft Access 2016 Level 2, or possess equivalent knowledge prior to attending this class.

Course Outlines

Lesson 1: Querying with SQL

  • SQL and Access
  • Writing SQL Statements
  • Attaching SQL Queries to Controls

Lesson 2: Advanced Queries

  • Creating Crosstab Queries
  • Creating Parameter Queries
  • Using Action Queries

Lesson 3: Macros

  • Creating, Running, and Modifying Macros
  • Attaching Macros to the Events of Database Objects

Lesson 4: Advanced Macros

  • Creating Macros to Provide User Interaction
  • Creating Macros that Require User Input
  • Creating AutoKeys and AutoExec Macros
  • Creating Macros for Data Transfer

Lesson 5: Importing, Exporting, and Linking Objects

  • Importing Objects
  • Exporting Objects
  • Working with XML documents
  • Linking Access Objects
  • Using Hyperlink Fields

Lesson 6: Database Management

  • Optimizing Resources
  • Protecting Databases
  • Setting Options and Properties