1. Introduction to the Beginner's Course FREE CHAPTER

• Introduction to Access 2021
• Acquiring Access 2021
• What's New in Access 2021?
• Exercise 01

2. Get Started with Access 2021

• Use Database Templates
• Create, Save, and Open Databases
• Explore the Access Interface and Backstage
• Customize the Quick Access Toolbar
• Access Menus
• Keyboard Shortcuts and Key Tips
• Online Help
• Access Options
• Exercise 02

3. Work with Tables

• Create a Table and Fields
• Index Fields, Primary Keys, and Add Records
• Use the Lookup Wizard to Create a Drop-Down List
• Numeric Fields and Data Validation Rules
• Add More Table Fields
• Exercise 03

4. Import Data

• Importing Data from Excel
• Importing Data from a Text File
• Exercise 04

5. Datasheet View

• Design in the Datasheet View
• Sort and Filter in Datasheet View
• Enter and Modify Data in Datasheet View
• Exercise 05

6. Create Relationships

• Relationships Explained
• Set Up Relationships
• Create a Link Table: Part 1
• Create a Link Table: Part 2
• Edit the Link Table
• Exercise 06

7. Forms

• Create a Form: Form Wizard
• Form Properties
• Modify a Form: Single Form Versus Continuous View
• Forms in Layout View
• Forms in Design View
• Exercise 07

8. Subforms

• Setting Up Subforms: Part 1
• Setting Up Subforms: Part 2
• Exercise 08

9. Queries

• Create a Query
• INNER, RIGHT, and LEFT Joins
• Run Queries and Aggregate Numeric Data Using Query Wizard
• Exercise 09

10. Validations and Expressions

• Set Up More Validations and Expressions
• Basic Calculations Using Expressions
• Exercise 10

11. Reports

• Run a Basic Report
• Custom Report Design
• Complex Reports
• Exercise 11

12. More Data Types

• Other Data Types: Yes/No
• Other Data Types: Attachments
• Exercise 12

13. More About Forms

• Form Controls: Option Buttons
• Form Themes and Design
• Navigation Forms
• Exercise 13

14. Share an Access Database

• Export Parts of an Access Database
• Database Properties and Encryption
• Exercise 14

15. Additional Access Features

• Compact and Repair
• Printing and Database Documenter
• Exercise 15

16. Beginner Course

• Course

17. Introduction to the Advanced Course

• Course Introduction
• Set Up for Success in Access 2021

18. Primary Keys and Indexes

• Primary Keys and Indexing Rules and Guidelines
• More About Indexes

19. Using Datasheet View

• Set Up the Northwind Database
• Work in a Datasheet View
• Customize Datasheet View
• Advanced Sorting and Filtering in Datasheet View
• Subdatasheets
• Exercise 01

20. Linking to Other Access Databases

• Linking Two Tables to Other Access Databases

21. Using ODBC and SQL Servers

• Install SQL Server Express
• Set Up SQL Server Express
• Exercise 02

22. Splitting an Access Database

• Splitting an Access Database into Frontend and Backend
• Convert to Local Table
• Addressing Multi-User Issues When Sharing Data
• Exercise 03

23. Macros

• Basics of Macros
• Macro on Events; AutoExec
• More About AutoExec
• Macro Security Settings
• Exercise 04

24. The Ribbon

• Customize the Quick Access Toolbar and Tabs

25. Visual Basic for Applications

• Convert Macros to VBA
• Run VBA Code and Error Handling
• Create Modules: Subs, Functions, Intellisense, and Variables
• Scope, Variable Naming, and Strings
• Standard Functions: Logical, Case, and Loops

26. Access Events Model

• Adding Events to Assets Database
• Exercise 05
• Common Events: Form and Report Events
• Switchboard, Navigation Forms, and Error Handling
• Exercise 06

27. Forms

• Formatting Bound and Control Forms
• Split Forms and Macro Error Handling
• Creating Form with Tab
• Go to Combo Box and Its Properties
• Exercise 07

28. Advanced Use of Queries

• Basics of Queries
• Syntax of SQL Statements
• Use of Multiple Where Criteria and Select Statements Function
• Joins and Join Types
• Exercise 08
• Action Queries - Part 1
• Action Queries - Part 2
• Subqueries

29. Protecting the Database and Code

• Protect the Database and VBA Code
• Exercise 09

30. Conclusion

• Course