BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Access 2021 Advanced - Expert Training

Simon Sez IT via YouTube

Start learning Write review

Overview

This course aims to enhance database management skills by covering topics such as setting up the Access environment, mastering primary keys and indexing, working in datasheet view, utilizing advanced sorting and filtering, linking tables, splitting databases, and understanding macros. The course teaches skills like SQL Server Express integration, frontend-backend database splitting, and macro automation. The teaching method includes hands-on exercises using downloadable course files. This course is intended for individuals looking to become experts in Microsoft Access 2021 and improve their data analysis capabilities.

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

Taught by

Simon Sez IT

Reviews

Start your review of Microsoft Access 2021 Advanced - Expert Training

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.