This beginner course on Microsoft Access 2021 aims to enhance data management capabilities by teaching how to create small to large databases. The course covers mastering terminology, interface, commands, templates, and creating relationships between tables. Students will learn keyboard shortcuts, key tips, and practical exercises using downloadable course files. The course is suitable for individuals looking to improve their database management skills using Microsoft Access 2021.
Overview
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
Related Courses
-
Microsoft Access Tutorial - Beginner to Advanced Training
5.0 -
Microsoft Excel - Ms Excel from Beginner to Advanced Course
-
Master Microsoft Access - Access from Beginner to Advanced
-
Microsoft Access Complete Beginner to Advanced
-
Introduction to Microsoft Access Tables
-
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
