Microsoft Access 2021 Advanced - Expert Training

Dive into an advanced 2.5-hour tutorial on Microsoft Access 2021, covering expert-level database management techniques. Master primary keys, indexing, and datasheet customization. Explore advanced sorting, filtering, and sub datasheets for enhanced data analysis. Learn to link tables across databases and integrate with SQL Server Express. Discover how to split databases into frontend and backend, address multi-user issues, and automate processes with macros. Download free exercise files to practice and reinforce your learning throughout the course. Elevate your Microsoft Access skills with comprehensive instruction on topics ranging from environment setup to macro security settings.

- 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