Overview
Syllabus
- Simon Sez IT Intro
- Acquiring Access 2021
- What's New in Access 2021
- Exercise 01
- Use Database Templates
- Create, Save and Open Databases
- Expose the Access Interface and Backstage
- Customize the Quick Access Toolbar
- Access Menus
- Keyboard Shortcuts & Key Tips
- Online Help
- Access Options
- Exercise 02
- Create a Table and Fields
- Index Fields, Primary Keys and Add Records
- Use the Lookup Wizard to Create a Drop-down List
- NUmeric and Data validation Rules
- Add More Table Fields
- Exercise 03
- Importing Data from Excel
- Import Data from a Text File
- Exercise 04
- Design in the Datasheet View
- Sort and Filter in Datasheet View
- Enter and Modify Data in Datasheet View
- Exercise 05
- Relationships Explained
- Set Up Relationship
- Create a Link: Part 1
- Create a Link: Part 2
- Edit the Link Table
- Exercise 06
Taught by
Simon Sez IT