Access 2010 Training Videos

(44 reviews) Write a Review
SKU:
access2010
UPC:
013964082012
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at Checkout
  • Access 2010 Training Videos
$49.95

Description

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!

DVD includes Access 2010 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv), Exercise Files, Quiz, Answers and Instructor's Notes. Our Access 2010 Levels 1, 2 & 3 training videos include all the training you need to pass the Access 2010 (77-885) Exam and become certified!

Access 2010 Level 1 (4.7 hrs):

Basics

  1. About Access 2010 (9:30)
  2. Access 2010 Overview (8:38)
  3. Access 2010 Help (3:13)
  4. Color Scheme & Save Defaults (2:27)
  5. Customize Quick Access Toolbar (6:11)
  6. Customize Ribbon (5:55)
  7. Datasheet Appearance (2:06)
  8. Document Window Options (5:03)
  9. Four Access Objects (6:33)
  10. 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)
  8. Introduction To Relationships (7:27)
  9. One-to-Many Relationships (11:09)
  10. One-to-One Relationships (7:34)
  11. Normalizing Standard (5:52)
  12. Managing Table Data (10:35)
  13. Sorting Records (3:06)
  14. Filtering Records (6:30)
  15. 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)

Access 2010 Level 2 (4.4 hrs):

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)
  3. Sorting & Filtering (2:37)
  4. Enhancing Appearance (10:54)
  5. Combo Box (7:35)
  6. Option Controls Group (4:16)
  7. Form Tab Pages (7:09)
  8. Command Button (1:52)
  9. 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)
  9. Advanced Formatting (12:33)
  10. Keep Groups Together (5:43)
  11. Force New Page (3:16)
  12. Adding Summary Field (9:24)
  13. Add Subreport (3:20)
  14. Create Mailing Labels (4:48)
  15. Import Excel (8:05)
  16. Import CSV File (6:11)
  17. Export To Word (2:49)
  18. Export To CSV File (5:59)
  19. Access To Excel Chart (3:28)
  20. Export To Text File (3:49)
  21. Merge With Word (3:54)

Access 2010 Level 3 (3.9 hrs):

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)
  4. Require Data Entry Macro (4:47)
  5. Display Message Macro (3:47)
  6. 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)
Access 2010 Training Videos

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

View AllClose

44 Reviews

  • 5
    This video is so clear cut and logical.

    Posted by Suzanne P. - North Carolina on 8th Jan 2015

    Self Training in Access. This video is so clear cut and logical. It guides you through Access in small exact sequences. Each class pinpoints one topic so you are not confused by having too many topics at once. The narrator is very clear and the screen with the circle curser lets you follow the steps exactly. I would highly recommend this video.

  • 5
    Top Trainer.

    Posted by Susan P. - Oklahoma on 8th Jan 2015

    I had bought another Access Trainer DVD but didn't really learn much. Video Trainer Access 2010 was excellent! Kirt Kershaw was easy to follow and I learned a lot. I was able to prepare tables, queries, forms and reports for my local Hershey Track and Field Games.

  • 5
    Enabled me to put together a fairly sophisticated Dbase.

    Posted by Peter K. - Minnesota on 8th Jan 2015

    The lessons are great, but I needed to keep them available, because I have gone back to them several times when I was stuck writing the Dbase. (I'm doing this for a charity and Dbase is/was all new to me - your lessons have enabled me to put together a fairly sophisticated Dbase for them - and it was fun learning that way). I enjoy the computer challenge.

  • 5
    Hits the mark without extra and unnecessary "fluff"

    Posted by Art S. - Colorado on 8th Jan 2015

    I am 55 years old and have had tremendous and varied experiences with training and education of all kinds. Your Access 2010 (and I'm guessing the rest of your programs if done like this) is by far the best training I have ever invested in. It is well planned, hits the mark without extra and unnecessary "fluff," I started with the 1st Level, are 70% completed with this and just downloaded Level 2, and will follow with Level 3 when ready. Also a great value. Awesome job!! Keep up the great work! PS. my compliments to Kirt. THANKS.

  • 5
    Excellent Access Training.

    Posted by Edward G. - New York on 8th Jan 2015

    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. I've been recommending your training videos to all my friends, and those who are pursuing the certification path!

  • 5
    I breezed through it.

    Posted by Liv H. - Texas on 8th Jan 2015

    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 through 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!

  • 5
    Great Training.

    Posted by Denise B. - New Jersey on 8th Jan 2015

    Excellent product for a hands-on learning. Works great in Windows 7.

  • 5
    Well done!!

    Posted by Francene P. - California on 8th Jan 2015

    Working on Access 2010. Unfortunately, have 2013 installed at work, but I'll make it work. Great training video. Very impressed with your presentation style and appreciate the concise and humanistic quality of the instruction.

  • 5
    Would recommend.

    Posted by Melven M. - Virginia on 8th Jan 2015

    The lessons are straight forward and very easy to follow; Although I have some understanding of the product, these videos were very informative.

View AllClose