Microsoft Access Tutorial - Beginner to Advanced Training

In this Access 2019 Beginner to Advanced training course, we cover the basics of Microsoft Access and expand to more advanced skills. We'll go over database templates, creating and saving your very first database, using the lookup wizard, backing up your database, and creating linked tables.

We'll also explore the datasheet view, how to set up a Northwind Database, link to tables in other databases, install the SQL Server Express, the basics macros, and so much more!

We've even included downloadable instructor and exercise files from our paid-for courses so you can follow along and complete the exercise in this course. This will help you put what you are learning into practice and master MS Access 2019.

- Simon Sez IT Intro
- Introduction to Access 2019
- Acquiring Access 2019
- Structure of the Course
- Using Database Template
- Creating, Saving, and Opening Databases
- Access Workspace and Backstage
- Online Help
- Working with the Ribbon
- Quick Access Toolbar
- Contextual Menus
- The Status Bar
- Keyboard Shortcuts
- Key Tips
- Access Options
- Creating a Table and Fields
- Indexing Fields
- Lookup Wizard
- Numeric Fields
- Exercise 01
- Importing Data from Excel
- Exercise 02
- Backing Up Your Database
- Compact and Repair
- Design in the Datasheet View
- Sorting and Filtering in Datasheet View
- Entering and Modifying Data in Datasheet View
- Creating a Link Table
- Setting Up Relationships
- Exercise 03
- Advanced Course Overview and Content
- Primary Keys and Indexing Rules and Guidelines
- More About Indexes
- Setting Up Northwind Database
- Working in Datasheet View
- Customizing Datasheet View, Sorting and Filtering Options
- Subdatasheets
- Exercise 01
- Linking to Tables in Other Databases
- Acquiring and Installing SQL Server Express
- Exercise 02
- Splitting Database into Front-end and Back-end
- Converting a Shared Table into a Local Table
- Exercise 03
- Addressing Multi-User Issues when Sharing Data
- Basics of Macros
- Macros on Events; AutoExec
- More about AutoExec
- Macro Security Settings
- Exercise 04