Microsoft Office Suite
Microsoft Access
Design relational databases that replace sprawling spreadsheets. Learn tables, queries, forms, reports, and VBA automation to build custom business applications.
Live virtual sessions or on-site training
3 Levels
Need a custom curriculum for your team? Contact us
What You Will Learn
Database Design
Queries & Filters
Forms & Reports
Data Import/Export
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modules01
Day 1: Database Foundations
- Understanding relational databases vs. spreadsheets
- Creating tables with appropriate field types and properties
- Setting primary keys, indexes, and field validation rules
- Establishing table relationships: one-to-many and many-to-many
- Referential integrity and cascade options
- Importing data from Excel, CSV, and text files
02
Day 2: Queries, Forms, and Reports
- Select queries with criteria, sorting, and calculated fields
- Action queries: update, append, delete, and make-table
- Building user-friendly data entry forms
- Form controls: combo boxes, list boxes, and buttons
- Designing grouped and summarized reports
- Printing, exporting to PDF, and sharing database files
After This Level
- Design normalized database tables with proper relationships
- Write select and action queries to manage data
- Build data entry forms and formatted reports
- Import external data and export results for sharing
Who Is This For
- Data managers
- Small business owners
- Teams replacing spreadsheet-based workflows
Prerequisites
Basic computer literacy. Familiarity with Excel is helpful.
Ready to master Microsoft Access?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.