Microsoft Access – Part 1
Duration: 2 days
Microsoft Access – Part 1 introduces relational databases and how to put them to work. Over two hands-on days you’ll learn to design tables, link them with relationships, build queries to answer questions, and create simple forms and reports so your data is easy to enter and easy to read.
Learning Objectives
- Understand relational database concepts
- Create and modify tables and set field properties
- Build relationships between tables
- Write select queries to retrieve data
- Create basic forms and reports
Who Should Attend
- Professionals who manage lists or data that have outgrown spreadsheets
- Office staff who need to build or maintain a database
- Anyone new to Microsoft Access
Prerequisites
- Basic Windows skills
- Comfort working with files and folders
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: Getting Started with Access
Tour the Access interface, understand database objects, and open and navigate a database.
Module 2: Designing Tables
Create tables, choose field data types, set primary keys, and apply field properties and validation.
Module 3: Relationships
Understand one-to-many relationships, enforce referential integrity, and join related tables.
Module 4: Querying Data
Build select queries, add criteria, sort and filter results, and use calculated fields.
Module 5: Forms and Reports
Create forms for data entry and reports for printing and sharing information.
