Enrollment Options:

1. Intermediate Microsoft Access 2019
   1. Reviewing Terms and Importing Data
   2. Key Fields and Action Queries
   3. Relationships of the Database Kind
   4. Creating and Modifying Forms
   5. Subforms and the Tab Control
   6. Queries
   7. Query Calculations
   8. Summary Queries
   9. Building Reports That Pinpoint Key Information
   10. Run Reports from a Custom Dialog Box
   11. Using Visual Basic to Automate the Reports Dialog Box
   12. Putting It All Together
2. Intermediate Microsoft Excel 2019
   1. Excel Charts and Graphs
   2. More Excel Charts
   3. AutoFilter and Sorting
   4. Goal Seeking
   5. Pivot Tables
   6. Advanced PivotTables
   7. Solver
   8. Sparklines
   9. Macros
   10. Introduction to Functions
   11. Math/Trig Functions
   12. VLOOKUP, INDEX, and MATCH Functions
3. Introduction to Microsoft Access 2019
   1. Getting to Know Access 2019
   2. Controlling Your Access Table Fields
   3. Creating Tables and Relationships
   4. Building Powerful Forms
   5. Adding Versatility to Forms
   6. Interviewing Your Database
   7. Taking Queries to the Next Level
   8. Multi-Table Query Control
   9. Reporting on Your Tables
   10. Creating Query-Based Reports
   11. Mastering Report Design
   12. Automating Your Database With Macros
4. Introduction to Microsoft Excel 2019
   1. Excel Basics
   2. Creating a Worksheet
   3. Time-Savers
   4. Relative, Absolute, Mixed, and Circular References
   5. Three-Dimensional Workbooks
   6. Sorting, Subtotaling, and Filtering
   7. Charting Basics
   8. Advanced Charting Techniques
   9. Intro to Excel's Statistical Functions
   10. Financial Functions
   11. Worksheet Automation
   12. Mastering Excel's IF Function