Learn how to use Microsoft Access 2019 with this tutorial aimed at beginners. By the end of the course, you will be able to create tables, manage basic databases, and import data from Excel. The teaching method includes step-by-step instructions and demonstrations. This course is intended for individuals who are new to Microsoft Access and want to understand how databases work.
Overview
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
Taught by
Simon Sez IT
