×
Microsoft

Microsoft Access 2016 Advanced Training

Due to Covid-19 safety restrictions PhoenixTS will temporarily be unable to provide food to our students who attend class at our Training Center; however, our Break Areas are currently open where students will find a constant supply of Coffee, Tea and Water. Students may bring their own lunch and snacks to eat in our breakrooms or at their seat in the classroom or eat out at one of the many nearby restaurants.

Course Overview

This 1-day, instructor-led shows you how to bring all the different Access objects to use advanced functions. This course will teach you how to:

  • Query with SQL
  • Create parameter, crosstab, and action queries
  • Create macros; import, export, and link database objects
  • Work with XML documents
  • Work with Windows SharePoint Services
  • Optimize databases; password-protect and encrypt databases
  • Set Access properties and options
  • Create hyperlink fields
  • Use Outlook 2010 to update data.

Microsoft Access 2016 Introduction and Intermediate courses are recommended before taking this course

Schedule

Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 240-667-7757.

[image]

Not seeing a good fit?

Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.

Contact Us

Learn more about custom training

Course Outline

Module 1: Introduction

Module 2: Action Queries

Module 3: Importing and Exporting Data

Module 4: Advanced Macros

Module 5: Creating a Menu System

Module 6: Working with Forms and Reports

Module 7: Database Tools and Maintenence

Due to Covid-19 safety restrictions PhoenixTS will temporarily be unable to provide food to our students who attend class at our Training Center; however, our Break Areas are currently open where students will find a constant supply of Coffee, Tea and Water. Students may bring their own lunch and snacks to eat in our breakrooms or at their seat in the classroom or eat out at one of the many nearby restaurants.

Subscribe now

Get new class alerts, promotions, and blog posts