Microsoft Access 2021 - Beginner to Advanced Tutorial Course

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Embark on a comprehensive 5+ hour tutorial course covering Microsoft Access 2021 from beginner to advanced levels. Learn to acquire and navigate Access 2021, utilize database templates, create and customize tables, implement data validation rules, and import data from various sources. Master datasheet view operations, understand database relationships, and set up links between tables. Explore advanced features like indexing, working with the Northwind Database, and addressing multi-user issues when sharing databases. Dive into macro basics, including AutoExec and security settings. Follow along with provided demo files and use timestamps to navigate specific topics, ensuring a thorough understanding of Microsoft Access 2021's capabilities for efficient database management and design.

Syllabus

- Acquiring Access 2021
- What's New in Access 2021
- Exercise 01
- Use Database Templates
- Create, Save and Open Databases
- Expose the Access Interface and Backstage
- Customize the Quick Access Toolbar
- Access Menus
- Keyboard Shortcuts & Key Tips
- Online Help
- Access Options
- Exercise 02
- Create a Table and Fields
- Index Fields, Primary Keys and Add Records
- Use the Lookup Wizard to Create a Drop-down List
- Numeric and Data Validation Rules
- Add More Table Fields
- Exercise 03
- Importing Data from Excel
- Import Data from a Text File
- Exercise 04
- Design in the Datasheet View
- Sort and Filter in Datasheet View
- Enter and Modify Data in Datasheet View
- Exercise 05
- Relationships Explained
- Set Up Relationship
- Create a Link: Part 1
- Create a Link: Part 2
- Edit the Link Table
- Exercise 06
- Advanced Course Intro
- Setup for Success
- Primary Keys and Indexing
- More About Indexes
- Setup Northwind Database
- Work in Datasheet View
- Customize Datasheet View
- Advanced Sort and Filter
- Subdatasheets
- Exercise 01
- Link Tables to Other Access Database
- Install SQL Server Express
- Setup SQL Server Express
- Exercise 02
- Split an Access Database into Frontend and Backend
- Convert to Local Table
- Addressing Multi-user Issues When Sharing
- Exercise 03
- Basics of Macros
- Macros On-Events; AutoExec
- More About AutoExec
- Macro Security Settings
- Exercise 04
- Conclusion