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 builds on the knowledge of Microsoft Access 2016 in the workplace. This course will teach you:
- Relational Database Concepts
- To perform calculations
- To work with advanced form functions and report functions
- Design and create tables
- Microsoft Access 2016 Introduction training is recommended
Schedule
Microsoft Access 2016 Intermediate Training
1/04/23 - 1/04/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
1/11/23 - 1/11/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
1/11/23 - 1/11/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
2/08/23 - 2/08/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
2/15/23 - 2/15/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
2/15/23 - 2/15/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
3/08/23 - 3/08/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
3/15/23 - 3/15/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
3/15/23 - 3/15/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
4/05/23 - 4/05/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
4/12/23 - 4/12/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
4/12/23 - 4/12/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
5/10/23 - 5/10/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
5/17/23 - 5/17/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
5/17/23 - 5/17/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
6/07/23 - 6/07/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
6/14/23 - 6/14/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
6/14/23 - 6/14/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
7/12/23 - 7/12/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
7/19/23 - 7/19/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
7/19/23 - 7/19/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
8/09/23 - 8/09/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
8/16/23 - 8/16/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
8/16/23 - 8/16/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
9/13/23 - 9/13/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
9/20/23 - 9/20/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
9/20/23 - 9/20/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
10/11/23 - 10/11/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
10/18/23 - 10/18/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
10/18/23 - 10/18/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
11/08/23 - 11/08/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
11/15/23 - 11/15/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
11/15/23 - 11/15/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
12/06/23 - 12/06/23 (1 days)
8:30AM - 4:30PM
Tysons Corner, VA
Open
$299
12/13/23 - 12/13/23 (1 days)
8:30AM - 4:30PM
Columbia, MD
Open
$299
12/13/23 - 12/13/23 (1 days)
8:30AM - 4:30PM
Online
Open
$299
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.
Course Outline
Advanced Queries
- Grouping and summarizing
- Updating, deleting, and relationships
- Indexing for performance
Advanced Forms
- Subforms
- Advanced control types
- Specialized form types
Advanced Reports
- Subreports
- Advanced grouping
- Advanced formatting
Macros
- Creating basic macros
- Using variables
- Troubleshooting macros
Database Management
- Compact & Repair
- Restoring a database
- Other maintenance tasks
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.