Completed
- Simon Sez IT Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Access Tutorial - Beginner to Advanced Training
Automatically move to the next video in the Classroom when playback concludes
- 1 - Simon Sez IT Intro
- 2 - Introduction to Access 2019
- 3 - Acquiring Access 2019
- 4 - Structure of the Course
- 5 - Using Database Template
- 6 - Creating, Saving, and Opening Databases
- 7 - Access Workspace and Backstage
- 8 - Online Help
- 9 - Working with the Ribbon
- 10 - Quick Access Toolbar
- 11 - Contextual Menus
- 12 - The Status Bar
- 13 - Keyboard Shortcuts
- 14 - Key Tips
- 15 - Access Options
- 16 - Creating a Table and Fields
- 17 - Indexing Fields
- 18 - Lookup Wizard
- 19 - Numeric Fields
- 20 - Exercise 01
- 21 - Importing Data from Excel
- 22 - Exercise 02
- 23 - Backing Up Your Database
- 24 - Compact and Repair
- 25 - Design in the Datasheet View
- 26 - Sorting and Filtering in Datasheet View
- 27 - Entering and Modifying Data in Datasheet View
- 28 - Creating a Link Table
- 29 - Setting Up Relationships
- 30 - Exercise 03
- 31 - Advanced Course Overview and Content
- 32 - Primary Keys and Indexing Rules and Guidelines
- 33 - More About Indexes
- 34 - Setting Up Northwind Database
- 35 - Working in Datasheet View
- 36 - Customizing Datasheet View, Sorting and Filtering Options
- 37 - Subdatasheets
- 38 - Exercise 01
- 39 - Linking to Tables in Other Databases
- 40 - Acquiring and Installing SQL Server Express
- 41 - Exercise 02
- 42 - Splitting Database into Front-end and Back-end
- 43 - Converting a Shared Table into a Local Table
- 44 - Exercise 03
- 45 - Addressing Multi-User Issues when Sharing Data
- 46 - Basics of Macros
- 47 - Macros on Events; AutoExec
- 48 - More about AutoExec
- 49 - Macro Security Settings
- 50 - Exercise 04
