How to Use MS Access - Microsoft Access 2019 Full Tutorial

Overview

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

Grab it

Learn Microsoft Access 2019 from the ground up in this comprehensive 2.5-hour tutorial. Discover how to create and manage databases, design tables, import data from Excel, and utilize essential features like indexing and lookup wizards. Master the Access interface, including the ribbon, quick access toolbar, and keyboard shortcuts. Explore database templates, create custom tables and fields, and understand important concepts such as numeric fields and data backup. Perfect for beginners, this tutorial covers everything from basic database creation to advanced features like compacting and repairing, providing a solid foundation for working with Access 2019.

Syllabus

- Introduction to Access 2019
- Acquiring Access 2019
- Structure of the Course
- Using Database Templates
- Creating, Saving, and Opening Databases
- The Access Workspace and Backstage
- Online Help and Tell Me What You Want To Do
- Working with the Ribbon
- The Quick Access Toolbar
- Contextual Menus
- The Status Bar
- Keyboard Shortcuts
- Key Tips
- Exploring Acces Options
- Creating a Table and Fields
- Indexed Field
- Lookup Wizard
- Numeric Fields
- Importing Data from Excel
- Backing up your Database
- Compact and Repair