Coursera Plus Annual is 40% Off — Ends June 29.

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

YouTube

Microsoft Access 2021 Beginner Course - Database Management Training

Simon Sez IT via YouTube

Start learning Write review
Simplilearn Ad

Build GenAI Apps from Scratch — UCSB PaCE Certificate Program

Learn More → University of the People Ad

Earn Your Business Degree, Tuition-Free, 100% Online!

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Learn the fundamentals of Microsoft Access 2021 in this comprehensive 3-hour beginner course. Explore database management essentials, including creating and saving databases, customizing the interface, and mastering keyboard shortcuts. Dive into table creation, field indexing, and data validation. Practice importing data from Excel and text files, designing in Datasheet View, and setting up relationships between tables. Follow along with downloadable exercise files to reinforce your learning and gain hands-on experience with Access 2021's latest features for efficient small to large database management.

Syllabus

- Simon Sez IT Intro
- 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

Taught by

Simon Sez IT

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Microsoft Access 2021 Beginner Course - Database Management Training

  • NAMAGANDA LYNETTE
    Everything is well explained. It guides you right from the beginner level equipping you with all the necessary skills step by step. One can take a break when necessary. They really help you understand the whole concept and idea. However, there should be awarding of certificates to act as proof that one has gained the skill.
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.