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

Access 2010 Training Videos

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!

 

Access 2010 DVD

DVD includes Access 2010 Levels 1, 2 & 3 training videos in both: Flash and Windows Media Video. Bonus Extras: Exercises, Questions, Answers & Notes. All of our Microsoft Office training videos can help you pass the exams and become certified!
$39.95 - DVD

Access 2010 Downloads

1) After purchase you'll receive an email with viewer and access key.
2) It's easy and simple to download and watch your Access 2010 training videos
click here to learn how.
$9.95 Downloads (see below)
# #
Access 2010 Level 1
Basics
  1. About Access 2010 (9:30) - VIEW DEMO!
  2. Flash (.swf)
    Windows Media Video (.wmv)
  3. Access 2010 Overview (8:38) -
    VIEW DEMO!

    Flash (.swf)
    Windows Media Video (.wmv)
  4. Access 2010 Help (3:13)
  5. Color Scheme & Save Defaults (2:27)
  6. Customize Quick Access Toolbar (6:11)
  7. Customize Ribbon (5:55)
  8. Datasheet Appearance (2:06)
  9. Document Window Options (5:03)
  10. Four Access Objects (6:33)
  11. Create Database (4:25)

Tables

  1. Create Tables A (7:44)
  2. Create Tables B (8:02)
  3. Entering Table Records (6:53)
  4. Save Table To PDF or XPS (2:35)
  5. Table Structuring (7:20)
  6. Managing Tables (2:23)
  7. Primary, Composite &
    Foreign Keys (9:13)
  1. Introduction To Relationships (7:27)
  2. One-to-Many Relationships (11:09)
  3. One-to-One Relationships (7:34)
  4. Normalizing Standard (5:52)
  5. Managing Table Data (10:35)
  6. Sorting Records (3:06)
  7. Filtering Records (6:30)
  8. Subdatasheets (8:39)

Queries

  1. Query Wizard (9:00)
  2. Create Query In Design (6:53)
  3. Query Criteria A (8:07)
  4. Query Criteria B (8:41)
  5. Adding Calculated Fields (4:34)
  6. Group Calculations (6:40)
  7. Formatting Datasheets (1:47)

Forms

  1. Form Basics (10:49)
  2. Creating Forms (7:21)
  3. Form Wizard (2:43)
  4. Modify Forms (11:27)

Reports

  1. Reports Introduction (5:39)
  2. Instant Reports (3:29)
  3. Report Wizard (5:14)
  4. Add Calculating Field (8:59)
  5. Formatting Controls (3:50)
  6. Applying Themes (2:47)
  7. Inserting Images (4:01)
  8. Adding Background Image (8:55)
  9. Prepare For Print (2:43)

Download Level 1 (763 MB)
4.7 hours of training

 
Unlimited viewing of Access 2010 Level 1 training videos for one computer.
 
$9.95 Download
 
Access 2010 Level 2
 

Advanced Tables

  1. Table Field Properties (9:09)
  2. Tracking Changes (4:30)
  3. Input Masks (8:02)
  4. Lookup Fields (9:00)

Advanced Queries

  1. Inner & Outer Data Joins (7:40)
  2. Self Join (5:55)
  3. Top Values (4:34)
  4. Unique Values Or Records (4:39)
  5. Wildcard Query (3:15)
  6. Parameter Query (7:02)
  7. Update Query (8:35)
  8. Append Query (5:38)
  9. Delete Query (3:58)
  10. Make Table Query (2:48)

Advanced Forms

  1. Layout View & Table Formats (7:48)
  2. Anchoring Controls (3:57) -
    VIEW DEMO!
  3. Flash (.swf)
    Windows Media Video (.wmv)
  1. Sorting & Filtering (2:37)
  2. Enhancing Appearance (10:54)
  3. Combo Box (7:35)
  4. Option Controls Group (4:16)
  5. Form Tab Pages (7:09)
  6. Command Button (1:52)
  7. Subform (8:48)

Advanced Reports

  1. PivotTable (9:59)
  2. Form PivotTable (4:19)
  3. Subform PivotTable (4:33)
  4. PivotChart (7:17)
  5. Form PivotChart (5:35)
  6. Subform PivotChart (5:20)
  7. Organizing Records (7:31)
  8. Add, Sort & Filter Groups (7:07)
  1. Advanced Formatting (12:33)
  2. Keep Groups Together (5:43)
  3. Force New Page (3:16)
  4. Adding Summary Field (9:24)
  5. Add Subreport (3:20)
  6. Create Mailing Labels (4:48)
  7. Import Excel (8:05)
  8. Import CSV File (6:11)
  9. Export To Word (2:49)
  10. Export To CSV File (5:59)
  11. Access To Excel Chart (3:28)
  12. Export To Text File (3:49)
  13. Merge With Word (3:54)

Download Level 2 (755 MB)
4.4 hours of training

 
Unlimited viewing of Access 2010 Level 2 training videos for one computer.
 
$9.95 Download
 
Access 2010 Level 3
 

More Advanced Tables

  1. Normalization Standard (3:46)
  2. Table Analyzer (9:08)
  3. Many To Many Relationships (6:45)
  4. Restructuring Tables (10:14)
  5. Hide Table Columns (0:56)

More Advanced Queries

  1. Subqueries (3:14)
  2. Unmatched Query (2:44)
  3. Duplicate Query (2:25)
  4. Criteria Groups Query (7:54)
  5. Cross Tab Query Wizard (4:50)

Macros

  1. Create A Macro (9:42)
  2. Macro Button (3:28)
  3. Where Condition (4:32) -
    VIEW DEMO!
  4. Flash (.swf)
    Windows Media Video (.wmv)
  5. Require Data Entry Macro (4:47)
  6. Display Message Macro (3:47)
  7. Automated Macros (4:43)

More Advanced Forms

  1. Conditional Formatting (4:07)
  2. Calendar Control Date Picker (2:07)

More Advanced Reports

  1. Report Chart (4:23)
  2. Multiple Columns & Groups (11:45)
  3. Cancelling Print Job (3:27)
  4. Publish To .PDF (1:31)

Maintaining Access Database

  1. Linking To Outside Tables (3:22)
  2. Database Properties (2:19)
  3. Compact & Repair Database (1:20)
  4. Backup Database (0:53)
  5. Password Protect (1:53)
  6. Object Dependency (1:23)
  7. Database Documenter (2:02)
  8. Performance Analyzer (1:10)

Database Integration

  1. Import XML Data (8:20)
  2. Export To XML (1:31)
  3. Data To Outlook 2010 (4:49)
  4. Collect Email Form Data (10:05)
  5. Table Attachment Field (3:28)
  6. Convert To Previous Version (2:23)
  7. Navigation Forms (5:09)
  8. Switchboards (8:30)
  9. Modifying Switchboards (2:57)
  10. Switchboard Startup Options (4:12)

Distribute Database & Security

  1. Split Database (4:14)
  2. Distributing Split Database (1:54)
  3. Security (4:36)
  4. Database Access Modes (2:00)
  5. Protect VBA Code (1:27)
  6. ACCDE Protection (2:06)
  7. Package and Sign (3:51)

SharePoint

  1. Export Table To SharePoint (5:20)
  2. Import Table From SharePoint (2:29)
  3. Publish Database To SharePoint (6:22)

Bonus!

  1. Update Query Via Form (9:52)
  2. Hide Empty Record Labels (5:05)
  3. Table Of Contents Or Index (10:09)

Download Level 3 (804 MB)
3.9 hours of training

 
Unlimited viewing of Access 2010 Level 3 training videos for one computer.
$9.95 Download
 

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

  1. Access 2010 Overview (#2) - new interface including the Backstage View!
  2. Color Scheme & Save Defaults (#4) - customize default for saving database!
  3. Datasheet Appearance (#7) - customize datasheet's appearance!
  4. Inserting Images (#43) - inserting clearer images!
  5. Create A Macro (#100) - new way to work with macros in Access 2010!
  6. Calendar Control Date Picker (#107) - Date Picker replaces Calendar Control!
  7. Navigation Forms (#126) - inserting reports & forms into a navigation form!
  8. Update Query Via Form (#140) - using an update query integrated within a form!
  9. Hide Empty Record Labels (#141) - eliminate space from empty records!
  10. Table Of Contents Or Index (#142) - create Table of Contents or Index!

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

 

Access 2010 Training Videos DVD Bonus Extras!
The Access 2010 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.
If you prefer not to download the Access 2010 training videos above, we also have available the Access 2010 training videos on DVD. 13 hours of training videos, and includes:

  1. Exercise Files - work along side with the Certified Master Instructor!
  2. Instructor Notes - quick reference notes on the basics covered in detailed videos!
  3. Student Questions - a list of questions to quiz yourself on after watching the videos!
  4. Instructor Answers - and of course the answers to the student questions!

The videos were recorded at a higher screen resolution: 1024 x 768 to reveal more tools available on the Access 2010 Ribbon, and accommodate the average user's higher screen resolution.

Each Access 2010 Levels 1, 2, 3 (DVD) training video includes a single license.

 

 
#

Access 2010 Reviews

Access 2010 Training"Excellent training on database management and Microsoft Access 2010 at great values! As a contract management specialist, I have to maintain a current and up to the minute list of more than 1000 contract actions that pan over a life cycle of up to 5 years. For each contract action, there are 40+ attributes that I need to keep track. Moreover, working with several interrelated offices within the organization, I also have to generate different reports on these contract actions for my internal and external customers. It would continue to be a daunting task if I keep track of these contract actions on a workbook. Through my knowledge of Integrating Microsoft Office applications, I determined that Access 2010 would be the best application for me to keep track of data on these items. So over the past month, I have spent time developing a contract management database. To ensure that I spend the minimal amount of time designing and developing this database, I have decided a take a quick course to brush my skills on Microsoft Access 2010. As a satisfied learner of another IT Training course (Microsoft Excel 2010), I contacted Dream Force LLC and inquired about availability of training materials on Access 2010 and Database Management. I was pleased to find out that this IT Training provider offers Access 2010 course on DVD for only $39.99, the same price for Excel 2010 training that I obtained a little less than a year ago and more affordable than competing training products. And once again, Dream Force LLC has trained me to become an advanced user of Access 2010 in no time. With 140+ topics covering basic skills as 'creating tables', shining the 'dance floor', 'one-to-one relationship', 'one-to-many relationship', 'enforcing referential integrity', 'forms', 'queries', and 'reports' to challenging tasks such as 'creating macro' (running a set of tasks) and restructuring the database. From soup to nuts, I was able to move current data from an "old school" workbook to an advanced database I have just developed, showcasing a Front-End Switchboard Terminal, ready for users to enter data, retrieve information, print reports and update existing records. This training program comes complete with 3 levels (Basics, Intermediate and Advanced), complemented with Exercise Files, Instructor Notes, Review Questions and Answers. This way, you can be assured that you will get all the tools you need to learn and excel in every topic. What you need to know about database management and Access 2010, this course will take you there. The video lessons show the LIVE (production) Access environment. The instruction is very easy to follow along and the instructor will let you know what you may expect to see on your OWN COMPUTER screen so that you will never miss a thing! I love this course, and the DVD will be a good reference material whenever I need it. It will be my best companion as I prepare for my Microsoft Office Specialist Certification exam!"

Ricky L. - Virginia

Send us your review!

Access 2010 Reviews

Access 2010 Training"Hello. My BF found your site for me. I was so impressed I purchased the 2010 Access DVD. When I realized I would have to wait for it (I thought I did the download), I said 'forget that' and purchased level 1 on download. I breezed thru it. I already knew a lot of what was in this section, but still learned other things. Because I'm a little weak in formulas, I purchased the download of level 2 2010 Excel. Can't wait to start that. The narrator is a brilliant speaker. He isn't like other videos I have seen where they "UM" a lot or stumble thru their script. IMO, that takes away from the lesson. I also like that he gives shortcuts as I also prefer keeping my hands on the keyboard. Everything seems to flow. Thank you so much! "

Liv H. - Texas

Access 2010 Training"Excellent Access Training. This is a Hands-on-project learning method. You don't have to read countless pages to get to what you to actually need to learn Access 2010. Kirt Kershaw has the ability to get all the concepts across in a non-boring way, making the learning process easier. The fact that the training is divided into short, but to the point video sessions, makes it easy for me, as a busy professional, to follow and learn on my spare time. It's like there's always something new for me to learn every time I'm watching one of the videos. Everything you need to pass the Microsoft Access 2010 Certification is contained within this training. The fact that the exercises he uses on the video are included in the package is a huge plus. I have dual monitor system, and I can actually watch the expert Kirt Kershaw on one screen and then follow whatever he's doing on the other screen. And unlike any training you pay for out there, you can always have access to the training sessions by rewind it as many times as you one till you get it, isn't that amazing! I do want to thank Kirt Kershaw for having made this available at an affordable price. I can't wait for him to complete his word 2010 training. I'll be definitely buying."

Edward G. - New York

 

Access 2010 Training Videos

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