Microsoft Access 2016 Level 3

Enhance your data management skills with Microsoft Access 2016 Level 3, designed for professionals seeking advanced knowledge in SQL querying, macro automation, and comprehensive database maintenance.

Course Thumbnail

Essential Skills Gained

Checkmark

Write advanced SQL statements and queries

Checkmark

Create and modify Microsoft Access macros

Checkmark

Import, export, and link database objects

Checkmark

Maintain and optimize Microsoft Access databases

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Database Managers
  • Data Analysts
  • Report Developers
  • IT Professionals preparing for MOS Access 2016

Description

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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Querying with SQL

  1. SQL and Access

  2. Writing SQL Statements

  3. Attaching SQL Queries to Controls

Lesson 2: Advanced Queries

  1. Creating Crosstab Queries

  2. Creating Parameter Queries

  3. Using Action Queries

Lesson 3: Macros

  1. Creating, Running, and Modifying Macros

  2. Attaching Macros to the Events of Database Objects

Lesson 4: Advanced Macros

  1. Creating Macros to Provide User Interaction

  2. Creating Macros that Require User Input

  3. Creating AutoKeys and AutoExec Macros

  4. Creating Macros for Data Transfer

Lesson 5: Importing, Exporting, and Linking Objects

  1. Importing Objects

  2. Exporting Objects

  3. Working with XML documents

  4. Linking Access Objects

  5. Using Hyperlink Fields

Lesson 6: Database Management

  1. Optimizing Resources

  2. Protecting Databases

  3. Setting Options and Properties

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.