Duration 1 Day
Who should attend?
This course is valuable for anyone who plans to prototype, build and integrate relational databases using Access to an advanced level.
Learning Outcomes
- Create Cross Tab Queries
- Create Make Table Queries
- Modify Start-up options
- Create Macros on Forms
- Create Macros on Reports
- Create Database Macros
- Compact and Repair Databases
- Database Password Protection
- Split a Database
Course Content
- Cross Tab Queries
- Make Table Queries
- Change Start-up Form
- Database Switchboards
- Create Macros
- Understand Form Events
- Understand Report Events
- Create Autoexec & Autokeys Macros
- Compacting Access Databases
- Adding Password Protection To Databases
- Creating Frontend / Backend Databases