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]](https://stage.phoenixts.com/wp-content/themes/phoenixts-com/assets/images/temp/image-9@2x.jpg)
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.
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.