Microsoft Access 2021 Advanced - Expert Training

This course develops advanced Microsoft Access skills through exercises on indexing, datasheet views, linked tables, database splitting, and multi-user sharing. It also covers SQL Server Express setup and Access macros.

Syllabus

- Course Introduction
- Set Up for Success in Access 2021
- Primary Keys and Indexing Rules and Guidelines
- More About Indexes
- Setup Northwind Database
- Work in Datasheet View
- Customize Datasheet View
- Advanced Sorting and Filtering in Datasheet View
- Subdatasheets
- Exercise 01
- Linking Two Tables to Other Access Databases
- Install SQL Server Express
- Setup SQL Server Express
- Exercise 02
- Splitting an Access Database into Frontend and Backend
- Convert to Local Table
- Addressing Multi-user Issues when Sharing Data
- Exercise 03
- Basics of Macros
- Macros On-Events; AutoExec
- More About AutoExec
- Macro Security Settings
- Exercise 04