How to Use MS Access - Microsoft Access 2019 Full Tutorial
Offered By: Simon Sez IT via YouTube
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 AccessUniversidad 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