What Will You Learn?

Access 2013 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 2013!

Our Access 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Access 2013 (77-424) 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

  • 3

    Tables

    • 11. Create Table A
    • 12. Create Table B
    • 13. Create Table C
    • 14. Export Table XPS PDF
    • 15. Table Structuring
    • 16. Managing Tables
    • 17. Primary Composite Foreign
    • 18. Introduction Relationships
    • 19. One-To-Many A
    • 20. One-To-Many B
    • 21. One-To-One
    • 22. Denormalization A
    • 23. Denormalization B
    • 24. Managing Table Data A
    • 25. Managing Table Data B
    • 26. Sorting Records
    • 27. Filter Records
    • 28. Subdatasheets
    • Quiz!
  • 4

    Queries

    • 29. Query Intro and Wizard A
    • 30. Query Intro and Wizard B
    • 31. Query Intro and Wizard C
    • 32. Query by Design
    • 33. Query Criteria A
    • 34. Query Criteria B
    • 35. Query Criteria C
    • 36. Calculated Fields
    • 37. Group Calculations
    • 38. Formatting Datasheets
    • Quiz!
  • 5

    Forms

    • 39. Form Basics A
    • 40. Form Basics B
    • 41. Creating Forms
    • 42. Form Wizard
    • 43. Modify Forms A
    • 44. Modify Forms B
    • Quiz!
  • 6

    Reports

    • 45. Reports Introduction
    • 46. Instant Reports
    • 47. Report Wizard
    • 48. Calculated Field A
    • 49. Calculated Field B
    • 50. Formatting Controls
    • 51. Applying Theme
    • 52. Insert Image
    • 53. Background Image A
    • 54. Background Image B
    • 55. Prepare For Print
    • Quiz!
  • 7

    Advanced Tables

  • 8

    Advanced Queries

    • 61. Inner Outer Joins A
    • 62. Inner Outer Joins B
    • 63. Self Join
    • 64. Top Value Queries
    • 65. Unique Values Records
    • 66. Wildcard Queries
    • 67. Parameter Query
    • 68. Update Query
    • 69. Append Query
    • 70. Delete Query
    • 71. Make Table Query
    • Quiz!
  • 9

    Advanced Forms

    • 72. Layout View Table Format
    • 73. Anchoring
    • 74. Filter And Sort
    • 75. Enhancing Appearance A
    • 76. Enhancing Appearance B
    • 77. Combo Box
    • 78. Option Group
    • 79. Form Tab Pages
    • 80. Command Button
    • 81. Subform
    • Quiz!
  • 10

    Advanced Reports

    • 82. Organizing Records A
    • 83. Organizing Records B
    • 84. Group Sort Add
    • 85. Advanced Formatting A
    • 86. Advanced Formatting B
    • 87. Keep Groups Together
    • 88. Force New Page
    • 89. Sum Fields
    • 90. Add Subreports
    • 91. Create Mail Labels
    • Quiz!
  • 11

    Import & Export Data

    • 92. Import Excel
    • 93. Import Text CSV
    • 94. Export To Word
    • 95. Export Report To CSV
    • 96. Export Excel Charts And Pivots
    • 97. Export To Text File
    • 98. Merge With Word
    • Quiz!
  • 12

    More Advanced Tables

  • 13

    More Advanced Queries

    • 105. Subqueries
    • 106. Unmatched Query
    • 107. Duplicate Query
    • 108. Criteria Groups
    • 109. Crosstab Query
    • Quiz!
  • 14

    Macros

    • 110. Create Macro
    • 111. Macro Button
    • 112. Where Condition
    • 113. Require Data Entry Macro
    • 114. Message Macro
    • 115. Automate Macro
    • Quiz!
  • 15

    More Advanced Forms & Reports

    • 116. Conditional Formatting
    • 117. Report Chart
    • 118. Columns And Groups A
    • 119. Columns And Groups B
    • 120. Cancelling Print Job
    • 121. Export To PDF
    • Quiz!
  • 16

    Maintaining Database

    • 122. Link Table
    • 123. Database Properties
    • 124. Compact Repair
    • 125. Backup Database
    • 126. Password
    • 127. Object Dependency
    • 128. Database Documenter
    • 129. Analyze Performance
    • Quiz!
  • 17

    Database Integration

    • 130. Import XML Data
    • 131. Export XML Data
    • 132. Link To Outlook Contacts
    • 133. Table Attachment Field
    • 134. Save As Previous Version
    • 135. Navigation Forms
    • 136. Switchboard
    • 137. Modify Switchboard
    • 138. Switchboard Startup Options
    • Quiz!
  • 18

    Distribute Database & Security

    • 139. Split Database
    • 140. Distribute Database
    • 141. Trusted Location
    • 142. Database Access Modes
    • 143. Protect VBA Code
    • 144. File Protection ACCDE
    • Quiz!
  • 19

    Bonus!

    • 145. Export to SharePoint
    • 146. Import Link To SharePoint
    • 147. Database To SharePoint
    • 148. Hide Empty Records Labels
    • 149. Table of Contents A
    • 150. Table of Contents B
    • Quiz!
  • 20

    Next steps

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