Access 2007 Training Videos

(35 reviews) Write a Review
SKU:
access2007
UPC:
837654648506
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout

Bulk discount rates

Below are the available bulk discount rates for each individual item when you purchase a certain amount

Buy 5 - 9 and get 35% off
Buy 10 or above and get 40% off
  • Access 2007 Training Videos
$49.95

Description

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!

DVD includes Access 2007 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv). 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!

 

Access 2007 Level 1 (4.5 hrs):

Basics

  1. About Access (11:32)
  2. Access Overview (10:29)
  3. Customize Access 2007 (9:27)
  4. Four Database Objects (10:26)
  5. Create Database (8:54)

Tables

  1. Create Tables (11:03)
  2. Enter Table Records (2:48)
  3. Save Table PDF or XPS (3:30)
  4. Primary & Composite Keys (8:14)
  5. Using Table Templates (1:55)
  6. Tables Structure Data (8:14)
  7. Managing Tables (4:20)
  8. Introduction Relationships (12:55)
  9. One-to-Many Relationships (12:52)
  10. One-to-One Relationships (1:59)
  11. Normalizing Tables (4:07)
  12. Managing Table Data (9:52)
  13. Sorting Records (3:44)
  14. Subdatasheets (11:59)

Queries

  1. Filtering Records (7:10)
  2. Create Query (4:39)
  3. Query Wizard (8:35)
  4. Query Criteria A (10:18)
  5. Query Criteria B (9:56)
  6. Adding Calculated Fields (5:07)
  7. Group Calculations (6:47)

Forms

  1. Form Basics (10:57)
  2. Instant Forms (9:58)
  3. Form Wizard (2:16)
  4. Modify Forms (10:55)

Reports

  1. Reports Introduction (11:20)
  2. Instant Reports (1:48)
  3. Report Wizard (7:35)
  4. Custom Calculated Fields (10:10)
  5. Formatting Controls (2:57)
  6. AutoFormat (1:59)
  7. Prepare For Print (3:07)

Access 2007 Level 2 (3.6 hrs):

Advanced Tables

  1. Table Field Properties (6:46)
  2. Tracking Changes (3:23)
  3. Input Masks (6:33)
  4. Lookup Fields (8:10)

Advanced Queries

  1. Inner Outer Data Joins (8:44)
  2. Self Joins (5:32)
  3. Top Values (4:27)
  4. Unique Values Records (4:06)
  5. Customize Query Design (1:06)
  6. Parameter Query (5:11)
  7. Update Query (6:28)
  8. Append Query (5:28)
  9. Delete Query (2:03)
  10. Make Table Query (1:53)

Advanced Forms

  1. Three Layout Types (6:59)
  2. Anchoring Controls (3:28)
  3. Sorting and Filtering (1:56)
  4. Enhancing Appearance (11:32)
  5. Combo Box (9:39)
  6. Option Controls (4:47)
  7. Command Button (2:13)
  8. Subform (13:30)

Advanced Reports

  1. Advanced Design (13:22)
  2. Sorting and Grouping (12:54)
  3. Formatting (4:33)
  4. Advanced Formatting (10:41)
  5. Keep Groups Together (5:47)
  6. Force New Page (2:53)
  7. Adding Sum Field (7:32)
  8. Add Subreport (3:22)
  9. Mailing Labels (4:07)
  10. Import Excel (5:08)
  11. Saved Imports (2:59)
  12. Import CSV File (7:20)
  13. Export To Word (1:48)
  14. Saved Export (2:07)
  15. Export To CSV File (2:20)
  16. Access To Excel Chart (1:21)
  17. Export Query To Text File (1:16)
  18. Export Query To CSV File (1:23)
  19. MailMerge (4:44)

Access 2007 Level 3 (4.3 hrs):

More Advanced Tables

  1. Normalization Standards (3:46)
  2. Table Analyzer (9:05)
  3. Many-To-Many Relationships (7:30)
  4. Restructuring Tables (7:49)
  5. Hide Table Columns (0:44)

More Advanced Queries

  1. Subqueries (4:59)
  2. Unmatched Query (3:45)
  3. Duplicate Query (1:17)
  4. Criteria Groups Query (5:43)
  5. Cross Tab Query Wizard (4:26)
  6. PivotTables (9:07)
  7. PivotChart (3:37)
  8. PivotChart Forms (5:15)
  9. Subform PivotChart (3:17)
  10. PivotTable Forms (3:57)
  11. Subform PivotTable (3:09)

Macros

  1. Create A Macro (4:32)
  2. Macro Button (3:27)
  3. Where Condition (5:46)
  4. Require Data Macros (7:16)
  5. Message Macros (4:00)
  6. Automated Macros (6:02)

More Advanced Forms

  1. Conditional Formatting (3:41)
  2. Pop Up Calendar (6:18)
  3. Command Button Wizard (5:06)
  4. Form Tabbed Pages (7:22)

More Advanced Reports

  1. Report Charts (3:40)
  2. Multiple Columns Groups (12:21)
  3. Canceling Print Jobs (3:50)
  4. Snapshot Reports (1:56)

Maintaining Access Database

  1. Linking Outside Tables (2:32)
  2. Compact Repair Database (1:59)
  3. Backup Database (1:34)
  4. Object Dependency (1:35)
  5. Database Documenter (1:34)
  6. Performance Analyzer (1:23)

Database Integration

  1. Import XML Data (9:36)
  2. Export XML XSD XSL Files (4:12)
  3. Data To Outlook 2007 (5:06)
  4. Collect Email Form Data (10:35)
  5. Table Attachment Fields (4:23)
  6. Convert To Previous Version (1:34)
  7. Switchboards (7:22)
  8. Modifying Switchboards (1:55)
  9. Switchboard Startup Options (3:09)

Distribute Database & Security

  1. Splitting Database (3:31)
  2. Distributing Split Database (2:55)
  3. Security Settings (4:19)
  4. Database Access Modes (2:32)
  5. Password Protect (2:29)
  6. Protect VBA Code (1:49)
  7. ACCDE Protection (3:41)
  8. Package and Sign (3:35)

SharePoint

  1. Export Table To SharePoint (6:08)
  2. Import Table From SharePoint (2:44)
  3. Publish Database To SharePoint (7:04)
  4. Move Database To SharePoint (4:39)
  5. Work Offline With SharePoint (4:35)

 

Access 2007 Training Videos

Access 2007 training videos from Dream Force — training videos solutions.
Affordable Access 2007 training videos
.

 

View AllClose

35 Reviews

  • 5
    I just pass my MS Access 2007 certification exam!

    Posted by Natasha E. - California on 20th Feb 2015

    Kirt, I wanted to share with you what a great experience it's been using your product. In addition, I just pass my MS Access 2007 certification exam! A little over four months ago I decided to change my career path, and to start learning about Access. At that point I did not know much more about it other than how to launch it, even though I've been fluent with computer languages, but never used any relational database software before. Thankfully to your straight to the point video training, with right timing and lots of patience, I was able to ace it and pass the exam from the first attempt. No one happier than me, and thank you for putting together such a high quality product!

  • 5
    They really stand out compared to the competition.

    Posted by Natasha E. - California on 20th Feb 2015

    I love your videos, they really stand out compared to the competition.

  • 5
    I'm happy.

    Posted by Walter M. - Austria on 20th Feb 2015

    I'm happy because I like this program and the pronunciation - I also improve my English with that lessons...!

  • 5
    Kirt's way of teaching is excellent, not too mention the fact that his voice is very easy to listen to.

    Posted by Willi H. - New Mexico on 20th Feb 2015

    I was an Access user when it first came out and had a hiatus from using it for about 8-9 years and was charged with learning Access 2007 for my current job. My first thought was, no problem I have used Access lots of times. I discovered that Access 2007 was not intuitive for me at all and I started looking around for training videos/CDs. I looked at several samples but settled on Kirt Kershaw's video trainer for Access 2007. What a difference it made for me! It is an excellent training guide, affordable and Kirt's way of teaching is excellent, not too mention the fact that his voice is very easy to listen to and you save hours trying to learn it by yourself. I would highly recommend it.

  • 5
    I would give it an A grade.

    Posted by Bansi P. - California on 20th Feb 2015

    After watching the video, I could start using Access. It really helped.

  • 5
    Great videos!

    Posted by John B. - Wisconsin on 20th Feb 2015

    I've downloaded the Access 2007 videos and gotten through the first 21. Very informative at just the right pace. Thanks, and keep up the good work.

  • 5
    You have a gift for making the seemingly complex easily understandable.

    Posted by bnewton81 - YouTube.com on 20th Feb 2015

    Doing a great job. Keep up the good work.

  • 5
    I like your style of teaching.

    Posted by Marco S. - Florida on 20th Feb 2015

    I like your style of teaching.

  • 5
    I have done many video trainings in the past and this one was far more valuable.

    Posted by Terri W. - Montana on 20th Feb 2015

    I truly enjoyed this training video. It had a lot of good information that was presented well. The trainer was clear and gave good examples. It was well worth the time and money. I have done many video trainings in the past and this one was far more valuable. It was not boring and held my interest. Also the layout was good and the lessons went in a logical order. I wish there had been such training before when I certified for Access 97. It would have made the passing the certification easier. Good Job. I will refer to this often for refresher training as I code new applications. Keep up the awesome work. It is appreciated.

View AllClose