YoVDO

How to Use MS Access - Microsoft Access 2019 Full Tutorial

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Access Courses Database Management Courses

Course Description

Overview

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


Taught by

Simon Sez IT

Related Courses

Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX
Competencias digitales de ofimática: Microsoft Access
Universitat Autònoma de Barcelona (Autonomous University of Barcelona) via Coursera
Diseño de software para la toma de decisiones organizacionales
Universidad del Rosario via edX
Excel to Access: Intro to Microsoft Access for Excel Users
Udemy
Access 2007: Shortcuts
LinkedIn Learning