Completed
- Create, Save and Open Databases
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Access 2021 - Beginner to Advanced Tutorial Course
Automatically move to the next video in the Classroom when playback concludes
- 1 - Acquiring Access 2021
- 2 - What's New in Access 2021
- 3 - Exercise 01
- 4 - Use Database Templates
- 5 - Create, Save and Open Databases
- 6 - Expose the Access Interface and Backstage
- 7 - Customize the Quick Access Toolbar
- 8 - Access Menus
- 9 - Keyboard Shortcuts & Key Tips
- 10 - Online Help
- 11 - Access Options
- 12 - Exercise 02
- 13 - Create a Table and Fields
- 14 - Index Fields, Primary Keys and Add Records
- 15 - Use the Lookup Wizard to Create a Drop-down List
- 16 - Numeric and Data Validation Rules
- 17 - Add More Table Fields
- 18 - Exercise 03
- 19 - Importing Data from Excel
- 20 - Import Data from a Text File
- 21 - Exercise 04
- 22 - Design in the Datasheet View
- 23 - Sort and Filter in Datasheet View
- 24 - Enter and Modify Data in Datasheet View
- 25 - Exercise 05
- 26 - Relationships Explained
- 27 - Set Up Relationship
- 28 - Create a Link: Part 1
- 29 - Create a Link: Part 2
- 30 - Edit the Link Table
- 31 - Exercise 06
- 32 - Advanced Course Intro
- 33 - Setup for Success
- 34 - Primary Keys and Indexing
- 35 - More About Indexes
- 36 - Setup Northwind Database
- 37 - Work in Datasheet View
- 38 - Customize Datasheet View
- 39 - Advanced Sort and Filter
- 40 - Subdatasheets
- 41 - Exercise 01
- 42 - Link Tables to Other Access Database
- 43 - Install SQL Server Express
- 44 - Setup SQL Server Express
- 45 - Exercise 02
- 46 - Split an Access Database into Frontend and Backend
- 47 - Convert to Local Table
- 48 - Addressing Multi-user Issues When Sharing
- 49 - Exercise 03
- 50 - Basics of Macros
- 51 - Macros On-Events; AutoExec
- 52 - More About AutoExec
- 53 - Macro Security Settings
- 54 - Exercise 04
- 55 - Conclusion
