What Will You Learn?

Access 2010 Training Videos will explain first what a database is, and then the foundation of the database which are tables. After you'll want to learn how to quickly extract and enter your data in an organized format by using forms. Also, you'll be shown how fun and easy it is to create reports, a way to extract your data from your tables and into a printable format. 

Learn to create relationships between tables including the most popularly misunderstood one-to-one relationship, and more by our Microsoft Certified Trainer training Access 2010!

Our Access 2010 Levels 1, 2 & 3 training videos include all the training you need to pass the Access 2010 (77-885) Exam and become certified!


What's Included In The Course?

  • 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!
  • 2

    Basics

    • 1. About Access 2010
    • 2. Access 2010 Overview
    • 3. Access 2010 Help
    • 4. Color Scheme Save Default
    • 5. Customize Quick Access Toolbar
    • 6. Customize Ribbon
    • 7. Datasheet Appearance
    • 8. Document Windows Options
    • 9. Four Access Objects
    • 10. Create Database
    • Quiz!
  • 3

    Tables

    • 11. Create Tables A
    • 12. Create Tables B
    • 13. Entering Table Records
    • 14. Save Table PDF XPS
    • 15. Table Structuring
    • 16. Managing Tables
    • 17. Primary Composite Foreign Keys
    • 18. Introduction to Relationships
    • 19. One-to-Many Relationship
    • 20. One-to-One Relationship
    • 21. Normalization Standard
    • 22. Managing Table Data
    • 23. Sorting Records
    • 24. Filtering Records
    • 25. Subdatasheets
    • Quiz!
  • 4

    Queries

    • 26. Query Wizard
    • 27. Create Query In Design
    • 28. Query Criteria A
    • 29. Query Criteria B
    • 30. Adding Calculating Fields
    • 31. Grouping and Calculating
    • 32. Formatting Datasheets
    • Quiz!
  • 5

    Forms

    • 35. Form Wizard
    • 36. Modifying Forms
    • 33. Form Basics
    • 34. Creating Forms
    • Quiz!
  • 6

    Reports

    • 37. Report Basics
    • 38. Instant Reports
    • 39. Report Wizard
    • 40. Add Calculating Field
    • 41. Formatting Controls
    • 42. Applying Themes
    • 43. Inserting Image
    • 44. Adding Background Image
    • 45. Prepare for Print
    • Quiz!
  • 7

    Advanced Tables

    • 46. Table Field Properties
    • 47. Tracking Changes
    • 48. Input Mask
    • 49. Lookup Field
    • Quiz!
  • 8

    Advanced Queries

    • 50. Inner Outer Joins
    • 51. Self Join
    • 52. Top Values 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. Anchoring
    • 62. Sorting Filtering
    • 63. Enhancing Appearance
    • 64. Combo Box
    • 65. Option Group
    • 66. Form Tab Pages
    • 67. Command Button
    • 68. Subform
    • Quiz!
  • 10

    Advanced Reports

    • 69. PivotTable
    • 70. Form PivotTable
    • 71. Subform PivotTable
    • 72. PivotChart
    • 73. Form PivotChart
    • 74. Subform PivotChart
    • 75. Organizing Records
    • 76. Add Sort Filter Groups
    • 77. Advanced Formatting
    • 78. Keep Groups Together
    • 79. Force New Page
    • 80. Sum Fields
    • 81. Add Subreports
    • 82. Create Mailing Labels
    • 83. Import Excel
    • 84. Import CSV
    • 85. Export To Word
    • 86. Export To CSV File
    • 87. Access to Excel Chart
    • 88. Export to Text File
    • 89. Merge With Word
    • Quiz!
  • 11

    More Advanced Tables

    • 90. Normalization Standard
    • 91. Table Analyzer
    • 92. Many To Many
    • 93. Restructuring Tables
    • 94. Hide Table Columns
    • Quiz!
  • 12

    More Advanced Queries

    • 95. Subqueries
    • 96. Unmatched Query
    • 97. Duplicate Query
    • 98. Criteria Groups Query
    • 99. Crosstab Query
    • Quiz!
  • 13

    Macros

    • 100. Create Macro
    • 101. Macro Button
    • 102. Where Condition
    • 103. Require Data Entry Macro
    • 104. Display Message Macro
    • 105. Automate Macro
    • Quiz!
  • 14

    More Advanced Forms

    • 107. Calendar Control Date Picker
    • 106. Conditional Formatting
    • Quiz!
  • 15

    More Advanced Reports

    • 108. Report Chart
    • 109. Columns and Groups
    • 110. Canceling Print Job
    • 111. Publish to PDF
    • Quiz!
  • 16

    Maintaining Access Database

    • 112. Link To Table
    • 113. Database Properties
    • 114. Compact And Repair
    • 115. Backup Database
    • 116. Password Protect
    • 117. Object Dependency
    • 118. Database Documenter
    • 119. Analyze Database Performance
    • Quiz!
  • 17

    Database Integration

    • 120. Import XML
    • 121. Export To XML
    • 122. Data To Outlook 2010
    • 123. Collect Email Data Form
    • 124. Table Attachment Field
    • 125. Save As Previous Version
    • 126. Navigation Forms
    • 127. Switchboard
    • 128. Modifying Switchboard
    • 129. Switchboard Startup
    • Quiz!
  • 18

    Distribute Database & Security

    • 130. Split Database
    • 131. Distribute Database
    • 132. Security
    • 133. Database Access Modes
    • 134. Protect VBA Code
    • 135. Protection ACCDE File
    • 136. Package and Sign
    • Quiz!
  • 19

    SharePoint

    • 137. Export Table SharePoint
    • 138. Import From SharePoint
    • 139. Database To SharePoint
  • 20

    Bonus!

    • 141. Hide Empty Record Labels
    • 142. Create Table of Contents Index
    • 140. Update Query Via Form
    • Quiz!
  • 21

    Next steps

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