What Will You Learn?

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

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


What's Included In The Course?

  • Certificate of Completion

Course Curriculum

  • 1

    Welcome to the course!

    • Before we begin...
    • How to use this course
  • 2

    Basics

    • 1. About Access 2007
    • 2. Access 2007 Overview
    • 3. Customize Access 2007
    • 4. Four Database Objects
    • 5. Create Database
  • 3

    Tables

    • 6. Create Tables
    • 7. Enter Table Records
    • 8. Save Table PDF XPS
    • 9. Primary Composite Keys
    • 10. Table Templates
    • 11. Tables Structure Data
    • 12. Managing Tables
    • 13. Introduction Relationships
    • 14. One-to-Many Relationships
    • 15. One-to-One Relationships
    • 16. Normalizing Tables
    • 17. Managing Table Data
    • 18. Sorting Records
    • 19. Subdatasheets
  • 4

    Queries

    • 20. Filtering Records
    • 21. Create Query
    • 22. Query Wizard
    • 23. Query Criteria A
    • 24. Query Criteria B
    • 25. Adding Calculating Fields
    • 26. Group Calculations
  • 5

    Forms

    • 27. Form Basics
    • 28. Instant Forms
    • 29. Form Wizard
    • 30. Modify Forms
  • 6

    Reports

    • 31. Reports Introduction
    • 32. Instant Report
    • 33. Report Wizard
    • 34. Custom Calculated Fields
    • 35. Formatting Controls
    • 36. AutoFormat
    • 37. Prepare For Print
  • 7

    Advanced Tables

    • 38. Table Field Properties
    • 39. Track Changes
    • 40. Input Masks
    • 41. Lookup Fields
  • 8

    Advanced Queries

    • 42. Inner Outer Data Joins
    • 43. Self Joins
    • 44. Top Values
    • 45. Unique Values Records
    • 46. Customize Query Design
    • 47. Parameter Query
    • 48. Update Query
    • 49. Append Query
    • 50. Delete Query
    • 51. Make Table Query
  • 9

    Advanced Forms

    • 52. Three Types Of Layouts
    • 53. Anchoring Controls
    • 54. Sorting Filtering
    • 55. Enhancing Appearance
    • 56. Combo Box
    • 57. Option Controls
    • 58. Command Button
    • 59. Subform
  • 10

    Advanced Reports

    • 60. Advanced Design
    • 61. Sorting Grouping
    • 62. Formatting
    • 63. Advanced Formatting
    • 64. Keep Groups Together
    • 65. Force New Page
    • 66. Adding Sum Field
    • 67. Add Subreport
    • 68. Mailing Labels
    • 69. Import Excel
    • 70. Saved Imports
    • 71. Import CSV File
    • 72. Export To Word
    • 73. Saved Export
    • 74. Export To CSV File
    • 75. Access To Excel Chart
    • 76. Export Query To Text File
    • 77. Export Query To CSV File
    • 78. MailMerge
  • 11

    More Advanced Tables

    • 79. Normalization Standard
    • 80. Table Analyzer
    • 81. Many To Many
    • 82. Restructuring Tables
    • 83. Hide Table Columns
  • 12

    More Advanced Queries

    • 84. Subqueries
    • 85. Unmatched Query
    • 86. Duplicate Query
    • 87. Criteria Groups
    • 88. Crosstab Query Wizard
    • 89. PivotTables
    • 90. PivotChart
    • 91. PivotChart Forms
    • 92. Subform PivotChart
    • 93. PivotTable Forms
    • 94. Subform PivotTable
  • 13

    Macros

    • 95. Create A Macro
    • 96. Macro Button
    • 97. Where Condition
    • 98. Require Data Macros
    • 99. Message Macro
    • 100. Automated Macro
  • 14

    More Advanced Forms

    • 101. Conditional Formatting
    • 102. Pop Up Calendar
    • 103. Command Button Wizard
    • 104. Form Tab Pages
  • 15

    More Advanced Reports

    • 105. Report Charts
    • 106. Multiple Columns
    • 107. Canceling Print Job
    • 108. Snapshot Report
  • 16

    Maintaining Access Database

    • 109. Linking Tables
    • 110. Compact Repair
    • 111. Backup Database
    • 112. Object Dependency
    • 113. Database Documenter
    • 114. Performance Analyzer
  • 17

    Database Integration

    • 115. Import XML Data
    • 116. Export XML Files
    • 117. Data To Outlook
    • 118. Collect Email Data
    • 119. Table Attachment Fields
    • 120. Convert Previous Version
    • 121. Switchboard
    • 122. Modifying Switchboard
    • 123. Switchboard Startup
  • 18

    Distribute Database & Security

    • 124. Splitting Database
    • 125. Distributing Split Databases
    • 126. Security Settings
    • 127. Database Access Modes
    • 128. Password Protect
    • 129. Protect VBA Code
    • 130. ACCDE Protection
    • 131. Package and Sign
  • 19

    SharePoint

    • 135. Move Database To SharePoint
    • 136. Work Offline SharePoint_backup
    • 132. Export Table SharePoint
    • 133. Import From SharePoint
    • 134. Publish DB To SharePoint
  • 20

    Next steps

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