Microsoft Access – Part 2
Duration: 2 days
Microsoft Access – Part 2 builds on the fundamentals to help you design more capable, maintainable databases. You’ll write advanced queries, automate tasks with macros, design polished forms and reports, and share data with other applications.
Learning Objectives
- Design action and parameter queries
- Improve table design and data integrity
- Build advanced forms and subforms
- Create grouped and summarized reports
- Automate routine tasks with macros
- Import, export, and link external data
Who Should Attend
- Access users ready to go beyond the basics
- Staff who build and maintain databases for their team
- Anyone who completed Access – Part 1 or has equivalent experience
Prerequisites
- Microsoft Access – Part 1 or equivalent experience
- Comfort creating tables, queries, and basic forms
What’s Included
- Authorized courseware and student materials
- Hands-on labs and real-world practice exercises
- Live instruction from an experienced, certified trainer
- Small class sizes for personalized attention
- Attend on campus in Miami or Fort Lauderdale, or live online
- Certificate of completion
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/9/2025 | ||||
| 12/29/2025 | 12/30/2025 | ||||
| 1/19/2026 | 1/20/2026 | ||||
| 2/9/2026 | 2/10/2026 | ||||
| 3/2/2026 | 3/3/2026 | ||||
| 3/23/2026 | 3/24/2026 | ||||
| 4/13/2026 | 4/14/2026 | ||||
| 5/4/2026 | 5/5/2026 | ||||
| 5/25/2026 | 5/26/2026 | ||||
| 6/15/2026 | 6/16/2026 | ||||
| 7/6/2026 | 7/7/2026 | ||||
| 7/27/2026 | 7/28/2026 | ||||
| 8/17/2026 | 8/18/2026 | ||||
| 9/7/2026 | 9/8/2026 | ||||
| 9/28/2026 | 9/29/2026 | ||||
| 10/19/2026 | 10/20/2026 | ||||
| 11/9/2026 | 11/10/2026 | ||||
| 11/30/2026 | 12/1/2026 | ||||
| 12/21/2026 | 12/22/2026 | ||||
| 1/11/2027 | 1/12/2027 |
Course Outline
Module 1: Advanced Queries
Create action queries, parameter queries, and crosstab queries, and work with calculated and aggregate values.
Module 2: Advanced Form Design
Build forms with subforms, add controls, and improve usability and validation.
Module 3: Advanced Reports
Group and sort report data, add calculations, and format reports for distribution.
Module 4: Automating with Macros
Create macros to automate repetitive tasks and respond to events.
Module 5: Sharing Data
Import, export, and link data with Excel and other sources, and manage your database.
