PRE-ASSESSMENT
+ SECTION 1 | FOUNDATION - 7 MODULES
Unit 1 | Introduction
1. Introduction to Access 2019
2. Acquiring Access 2019
3. Structure of the Course
Unit 2 | Getting Started With Access 2019
1. Using Database Templates
2. Creating, Saving, and Opening Databases
3. The Access Workspace and Backstage
4. Online Help and Tell Me What You Want to Do
+ SECTION 2 | THE USER INTERFACE - 7 MODULES
Unit 3 | The Ribbon and Toolbars
1. Working With the Ribbon
2. The Quick Access Toolbar
3. Contextual Menus
4. The Status Bar
Unit 4 | Keyboard Shortcuts and Key Tips
1. Keyboard Shortcuts
2. Key Tips
Unit 5 | Access Options
1. Exploring Access Options
+ SECTION 3 | TABLES, FORMS, AND DATA - 25 MODULES
Unit 6 | Tables
1. Creating a Table and Fields
2. Indexed Field
3. Lookup Wizard
4. Numeric Fields
5. Practice Exercise 01
Unit 7 | Importing Data
1. Importing Data From Excel
2. Practice Exercise 02
Unit 8 | Backup, Restore, and Repair
1. Backing Up Your Database
2. Compact and Repair
Unit 9 | Datasheet View
1. Design in the Datasheet View
2. Sorting and Filtering in Datasheet View
3. Entering and Modifying Data in Datasheet View
Unit 10 | Relationships
1. Creating a Link Table
2. Setting Up Relationships
Unit 11 | Forms
1. Creating a Form
2. Modifying a Form
3. Practice Exercise 04
4. Forms in Layout View
5. Forms in Design View
6. Practice Exercise 05
7. Form Design
Unit 12 | Subforms
1. Setting Up Subforms - Part 1
2. Setting Up Subforms - Part 2
3. Setting Up Subforms - Part 3
4. Practice Exercise 06
+ SECTION 4 | QUERIES, EXPRESSIONS, AND REPORTS - 11 MODULES
Unit 13 | Queries
1. Creating a Query
2. Joins
3. Query Wizard
4. Practice Exercise 07
Unit 14 | Expressions
1. Setting Up Validations
2. Calculation Using Expressions
Unit 15 | Reports
1. Basic Reports
2. Report Design
3. Complex Reports
4. Practice Exercise 08
Unit 16 | Printing
1. Printing and Print Properties
+ SECTION 5 | DATA TYPES AND FORM CONTROLS - 4 MODULES
Unit 17 | More Data Types
1. Yes / No, OLE Objects, and Hyperlink Data Types
Unit 18 | More About Forms
1. Form Controls
2. Form Themes
3. Navigation Forms
+ SECTION 6 | STREAMLINING WORKFLOW - 4 MODULES
Unit 19 | Exporting
1. Exporting an Access Database
Unit 20 | Application Parts
1. Adding Application Parts to a Database
Unit 21 | More Access Options
1. Additional Access 2019 Options
Unit 22 | Info Tab
1. Edit Database Properties and Encrypt With Password
+ SECTION 7 | CLOSURE - 1 MODULE
Unit 23 | Course Close
1. Course Close
FINAL ASSESSMENT