What Will You Learn?

Microsoft Access All-In-One Training   

This Microsoft Access course includes all three Levels from Beginner to Advanced    

  • Microsoft Access Level 1 – Beginner   

  • Microsoft Access Level 2 – Intermediate   

  • Microsoft Access Level 3 – Advanced   

Material recorded with Access 2016 but works in 2010, 2013, 2016, 2019 and 365.

As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access.     

At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me.  Below are just a few of the topics that you will master:   

  • Create powerful, effective Access Databases   

  • Enter, edit, update, search, sort and filter Table records    

  • Set defaults and validate data for more accurate data entry   

  • How to quickly edit, filter and search records in a Form    

  • Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms   

  • Add custom fields to perform calculations: Sum, Count, Average and more    

  • Add, sort and filter groups as well as keeping them from splitting across pages in your Reports   

  • Use criteria in a Query to dramatically refine your search   

  • View unique records and use Actions Queries to Update, Add and Delete records fast    

  • Automate data entry and accuracy dramatically by creating Macros and much more…   


What's Included In The Course?

  • 16 Hours of Access 2016 Training Videos
  • Quizzes
  • Exercise files
  • Instructor's Notes
  • Certificate of Completion

Course Curriculum

  • 1

    Welcome to the course!

    • Before we begin...
    • How to use this course
    • Instructor Notes and Exercise Files!
  • 3

    Tables

    • 11. Create Table
    • 12. Entering Records in Tables
    • 13. Export Table to XPS or PDF
    • 14. Table Structuring
    • 15. Managing Tables
    • 16. Basics on Primary, Composite & Foreign Keys
    • 17. Basic Introduction Setting Up Tables for Relationships
    • 18. Create One-to-Many Relationships
    • 19. Create One-to-One Relationships
    • 20. Denormalization or Denormalize
    • 21. Managing Table Data
    • 22. Sorting Records
    • 23. Filter Records
    • 24. Subdatasheets
  • 4

    Queries

    • 25. Query Wizard
    • 26. Basics on Creating a Query in Design View
    • 27. Setting Query Criteria
    • 28. Add a Calculating Field
    • 29. Grouping Records & Totals
    • 30. Customize Table or Query Datasheet
    • Quiz!
  • 5

    Forms

    • 31. Basic Introduction to Forms
    • 32. Create Forms Instantly
    • 33. Form Wizard
    • 34. How to Modify & Edit Forms
  • 6

    Reports

    • 35. Report Views
    • 36.How to Create Instant Reports
    • 37. Step by Step Report Wizard
    • 38. Ceate Custom Calculating Fields
    • 39. Formatting Controls
    • 40. Applying Themes
    • 41. Inserting Images
    • 42. Insert Background Images & Watermarks
    • 43. Inserting Hyperlinks
    • 44. Prepare for Print
    • Quiz!
  • 7

    Advanced Tables

  • 8

    Advanced Queries

    • 49. Inner & Outer Data Joins
    • 50. Join Unrelated Tables
    • 51. Self Join
    • 52. Top Value Query
    • 53. Unique Values & Records
    • 54. Wildcard Query
    • 55. Parameter Query
    • 56. Update Query
    • 57. Append Query
    • 58. Delete Query
    • 59. Make Table Query
    • Quiz!
  • 9

    Advanced Forms

    • 60. Layout View & Table Formats
    • 61. Anchor Controls
    • 62. Filter & Sort Records
    • 63. Enhance Appearance
    • 64. Combo Box
    • 65. Option Controls Group
    • 66. Form Tab Pages
    • 67. Command Button
    • 68. Subform
    • Quiz!
  • 10

    Advanced Reports

    • 69. Organizing Records
    • 70. Adding, Sorting & Filtering Groups
    • 71. Advanced Formatting
    • 72. Keep Groups Together
    • 73. Force New Page
    • 74. Adding Summary Field
    • 75. Add Subreports
    • 76. Create Mailing Labels
    • Quiz!
  • 11

    Import & Export Data

    • 77. Import Excel
    • 78. Import Text & CSV Files
    • 79. Export to Word
    • 80. Export to CSV File
    • 81. Export to Excel for Charts & PivotTables
    • 82. Export to Text File
    • 83. Mail Merge with Microsoft Word
    • Quiz!
  • 12

    More Advanced Tables

  • 13

    More Advanced Queries

    • 89. Subqueries
    • 90. Unmatched Query
    • 91. Duplicate Query
    • 92. Criteria Groups Query
    • 93. Crosstab Query Wizard
    • Quiz!
  • 14

    Macros

    • 94. Create Macros
    • 95. Macro Button
    • 96. Where Condition
    • 97. Require Data Entry Macro
    • 98. Display Message Macro
    • 99. Automated Macro
    • Quiz!
  • 15

    More Advanced Forms & Reports

    • 100. Conditional Formatting
    • 101. Report Charts
    • 102. Multiple Columns & Groups
    • 103. Canceling Print Job
    • 104. Export to PDF or XPS
    • Quiz!
  • 16

    Maintaining Database

    • 105. Linking to Other Database Tables
    • 106. Database Properties
    • 107. Compact & Repair Database
    • 108. Backup Database
    • 109. Password Protect
    • 110. Object Dependency
    • 111. Database Documenter
    • 112. Performace Analyzer
    • Quiz!
  • 17

    Database Integration

    • 113. Import XML Data
    • 114. Export to XML
    • 115. Link to Outlook Contacts
    • 116. Table Attachment Field
    • 117. Save As Previous Version
    • 118. Navigation Forms
    • 119. Switchboard
    • 120. Modifying Switchboards
    • 121. Startup Options
    • Quiz!
  • 18

    Distribute Database & Security

    • 122. Splitting Database
    • 123. Distributing Split Database
    • 124. Database Access Modes
    • 125. Trusted Location
    • 126. Protect VBA Code
    • 127. File Protection ACCDE
    • Quiz!
  • 19

    Bonus!

    • 128. Digitally Sign Database
    • 129. Hide Empty Record Labels in Reports
    • 130. Create Table of Contents
    • 131. Custom Display Control for Text Box
    • Quiz!
  • 20

    Next steps

    • Congrats! Here's what's next...
    • Before you go...