Access 2007 Training Videos
Home     |     About     |     Products     |     Testimonials     |     Contact     |      Newsletter
 
Access 2007 Training Videos
 

Access 2007 Training Videos

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!

 

Access 2007 DVD

With your DVD purchase you'll get Access 2007 Levels 1, 2 & 3 training videos. Also, your videos will be available in: Flash and Windows Media Video. All of our Microsoft Office training videos can help you pass the exams and become Certified!
$49.95 - DVD
Free Shipping in U.S.
*Free Shipping within the U.S.
# #
Access 2007 Level 1
Basics
  1. About Access (11:32) - VIEW DEMO!
  2. Access Overview (10:29) - VIEW DEMO!
  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)

Download Level 1 (687 MB)
4.5 hours of training

 
Additional Office 2007 training videos:
 
Office 2007 Training
Excel 2007 Training
Access 2007 Level 2
 

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) - VIEW DEMO!
  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)
  1. Adding Sum Field (7:32)
  2. Add Subreport (3:22)
  3. Mailing Labels (4:07)
  4. Import Excel (5:08)
  5. Saved Imports (2:59)
  6. Import CSV File (7:20)
  7. Export To Word (1:48)
  8. Saved Export (2:07)
  9. Export To CSV File (2:20)
  10. Access To Excel Chart (1:21)
  11. Export Query To Text File (1:16)
  12. Export Query To CSV File (1:23)
  13. MailMerge (4:44)

Download Level 2 (692 MB)
3.6 hours of training

 
Additional Office 2007 training videos:
 
Outlook 2007 Training
PowerPoint 2007 Training
Access 2007 Level 3
 

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) - VIEW DEMO!
  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)
  1. Table Attachment Fields (4:23)
  2. Convert To Previous Version (1:34)
  3. Switchboards (7:22)
  4. Modifying Switchboards (1:55)
  5. 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)

Download Level 3 (885 MB)
4.3 hours of training

 
Additional Office 2007 training videos:
 
Project 2007 Training
Word 2007 Training
Windows 7 Training

Top 7 Access 2007 Must See Videos!
If you're already familiar with the previous version of Access, and want to know what's new in Access 2007 you'll want to check out the following training videos:

  1. Access 2007 Overview (#2) - new interface including the Navigation Pane
  2. Customize Access 2007 (#3) - adding Object Tabs to close Object windows
  3. Create Database (#5) - new way of creating your databases including templates
  4. Create Tables (#6) - new and faster ways to create your Tables and their fields
  5. Table Templates (#10) - quick Tables with default fields to get you going fast
  6. Subdatasheets (#19) - learn where the subdatasheets are and how to modify
  7. Instant Forms (#28) - new are the Layout views in addition to the Design view

Access 2007 (77-605) Exam:
Our Access 2007 training videos include all the training you need to pass!

 
Access 2007 Training Videos DVD Details...
The Access 2007 training videos on DVD contain not only Flash files, but also Windows Media Video files. These files make it easier to find the right training video that is sharpest and clear to you on your monitor. Flash files for larger monitors with high resolution looks great, and for smaller monitors we recommend the Windows Media Video files.

Over 12 hours of training videos. Approximately, 2.3 GB of DVD space. Why so large? The videos were recorded at a higher screen resolution of 1024 x 768 to reveal more tools available on the new Access 2007 Ribbon, and accommodate today's average user's higher screen resolution, wide screen LCD monitors. We believe you should be able to see more of the options available in our training videos.

Access 2007 Levels 1, 2 & 3 training videos on DVD are only $39.95 for a limited time!

 
#

Access 2007 Reviews

"Great video training. I purchased the Access, Excel and Word and am looking forward to the Project 2007. I was looking for some advanced training on Microsoft Office and really enjoy your teaching style. Your training programs are the best out there, I highly recommend them. Keep up the great work. Thanks again, I will recommend your site to others."

Stephen D. - New York

"They are the best video of this kind I've seen and I've seen a lot: clear, concise and useful - rare combination. Thank you for your great product."

Bogdan R. - Romania

"I got your Access 2007 training and loved it, so I was hoping for the same quality of training on SharePoint Designer. I’m looking for advanced training, preferably dealing with workflows and data views."

Stephen G. - Louisiana

"I have used Access L-1, and you have created a nice piece of quality product with excellent presentation. Very pleased with videos. So pleased I just ordered the complete Office 2007 set with the two Vista Tutorials. Excellent work."

Jim U. - Florida

"I was wondering if you guys have video training for Dreamweaver 8? Or if you could point me in the direction to get it. I really want a good video training like the 'access training' I got from you. Very clear, good speaker, good screen size, etc.. I'm really hoping you guys do Dreamweaver videos."

Dawn W. - Delaware

"I bought the training video a few months back and it has been put to a good use. Having a very minimal knowlege on Access is not an issue when using this video training. Training video is broken down to small sections and one can go to one section to another at any time. Many examples are in the video with a very clear step by step instructions. The best asset of this video is the clear voice of the trainer that you won't feel tired of hearing like some other training video that I have tested. Finishing the video training will not make me an instance expert but it is a good start of getting a better user of Access and avoid many mistakes of creating poor database structure."

Tjiong T. - California

Access 2007 Training"I found the Access 2007 tutorials incredibly easy to follow. The speed instructor covered the material forces you to pay attention. When will 2010 Access tutorials be available? I am interested in learning the web application in the new version."

Bob F. - Minnesota

Access 2007 Training"I've been working on a new project where I've used a training video for another product and I just wanted you to know how much I appreciate your training videos. I thought you videos were good and professional but honestly that is simply what I expected. I did not realize how good they were until I started watching videos that fell short of your training. I simply wanted to send you a note saying … job well done."

Craig A. - Utah

Access 2007 Training"LOVE the Access 2007 training videos. Recommending them to everyone."

Kathy W. - Virginia

Access 2007 Training"Excellent DVD. The author speaks clearly. You'll will find that it is great to watch and listen. I own some ACCESS DVD from another author and is boring to watch and listen to. Great materials. Recommend to anyone."

Paul N. - California

Access 2007 Training"I am using the Access vidoes and LOVING IT!!!"

Ravi A. - Georgia

Send us your review!

Access 2007 Reviews

"I would like to comment that the video is very clear and easy to follow. "

Tjiong T. - California

"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."

Terri W. - Montana

"I like your style of teaching."

Marco S. - Florida

"You have a gift for making the seemingly complex easily understandable. Doing a great job. Keep up the good work."

bnewton81 - YouTube.com

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

John B. - Wisconsin

"After watching the video, I could start using Access. It really helped. I would give it an A grade."

Bansi P. - California

"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. "

Willi H. - New Mexico

Access 2007 Training"I'm happy because I like this program an the pronounciation - I also improve my English with that lessons...!"

Walter M. - Austria

Access 2007 Training"I love your videos, they really stand out compared to the competition."

Natasha E. - California

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

Natasha E. - California

Access 2007 Training"Great format, Great information. I had very limited skills with Access. I was amazed by the power of the program, and the format of the video allowed me to become familiar with the different capabilities of the program before moving on to the next section. It has allowed me to become proficient with Access (and amaze and impress my co-workers). This purchase was a great investment. I love the videos and I'm sure I'll love the Powerpoint and Excel videos!"

Jennie T. - New Mexico

Access 2007 Training Videos

Access 2007 training videos from Dream Force — training solutions.
Certified training on Access 2007 training videos.