Loading... Please wait...

Access 2013 Training Videos

Access 2013 Training Videos

$49.95
SKU
access2013
Condition
New
Rating
Availability
Usually ships in 1 to 2 business days.
Shipping
Calculated at checkout

Product Description

  • After purchase you will be directed to download the training video file.
  • Unlimited viewing of the training video(s) for one computer.
  • After purchase your training video DVD(s) will be shipped to you.
  • Unlimited viewing of the training video(s) for one computer.

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

DVD includes Access 2013 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 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Access 2013 (77-424) Exam and become certified!

Access 2013 Level 1 (6.4 hrs):

Basics

  1. Access 2013 Introduction (12:15)
  2. Access 2013 Overview (8:16)
  3. Access 2013 Help (2:05)
  4. Color Scheme & Save Defaults (3:09)
  5. Customize Quick Access Toolbar (5:57)
  6. Customize Ribbon (8:41)
  7. Datasheet Appearance (1:04)
  8. Document Window Options (6:17)
  9. Four Access Objects (7:56)
  10. Create Database (3:12)

Tables

  1. Create Tables & Entering Records A (10:52)
  2. Create Tables & Entering Records B (8:43)
  3. Create Tables & Entering Records C (5:24)
  4. Save Table To PDF or XPS (3:57)
  5. Table Structuring (8:38)
  6. Managing Tables (4:16)
  7. Primary, Composite & Foreign Keys (8:50)
  8. Introduction To Relationships (5:13)
  9. One-to-Many Relationships A (8:47)
  10. One-to-Many Relationships B (5:04)
  11. One-to-One Relationships (12:19)
  12. Denormalization A (7:36)
  13. Denormalization B (3:21)
  14. Managing Table Data A (9:16)
  15. Managing Table Data B (5:36)
  16. Sorting Records (4:16)
  17. Filtering Records (11:16)
  18. Subdatasheets (12:22)

Queries

  1. Query Introduction & Wizard A (7:13)
  2. Query Introduction & Wizard B (6:33)
  3. Query Introduction & Wizard C (5:02)
  4. Create Query In Design (9:19)
  5. Query Criteria A (11:41)
  6. Query Criteria B (5:49)
  7. Query Criteria C (4:38)
  8. Adding Calculated Fields (7:38)
  9. Group Calculations (8:10)
  10. Formatting Datasheets (2:09)

Forms

  1. Form Basics A (7:12)
  2. Form Basics B (10:05)
  3. Creating Forms (10:57)
  4. Form Wizard (5:40)
  5. Modify Forms A (8:45)
  6. Modify Forms B (4:58)

Reports

  1. Reports Introduction (8:10)
  2. Instant Reports (5:32)
  3. Report Wizard (9:16)
  4. Add Calculating Field A (8:25)
  5. Add Calculating Field B (8:53)
  6. Formatting Controls (6:52)
  7. Applying Themes (2:55)
  8. Inserting Images (7:17)
  9. Adding Background Image A (8:25)
  10. Adding Background Image B (3:24)
  11. Prepare For Print (6:40)

Access 2013 Level 2 (4.9 hrs):

Advanced Tables

  1. Table Field Properties A (9:23)
  2. Table Field Properties B (3:49)
  3. Tracking Changes (8:35)
  4. Input Masks (10:30)
  5. Lookup Fields (10:27)

Advanced Queries

  1. Inner & Outer Data Joins A (8:06)
  2. Inner & Outer Data Joins B (5:04)
  3. Self Join (6:17)
  4. Top Values (4:36)
  5. Unique Values Or Records (4:59)
  6. Wildcard Query (4:55)
  7. Parameter Query (8:37)
  8. Update Query (9:35)
  9. Append Query (5:56)
  10. Delete Query (7:21)
  11. Make Table Query (5:05)

Advanced Forms

  1. Layout View & Table Formats (9:30)
  2. Anchoring Controls (3:53)
  3. Sorting & Filtering (3:36)
  4. Enhancing Appearance A (9:17)
  5. Enhancing Appearance B (7:35)
  6. Combo Box (11:48)
  7. Option Controls Group (6:19)
  8. Form Tab Pages (7:40)
  9. Command Button (2:16)
  10. Subform (11:35)

Advanced Reports

  1. Organizing Records A (7:40)
  2. Organizing Records B (4:15)
  3. Adding, Sorting & Filtering Groups (8:38)
  4. Advanced Formatting A (10:27)
  5. Advanced Formatting B (9:35)
  6. Keep Groups Together (4:14)
  7. Force New Page (2:50)
  8. Adding Summary Field (11:21)
  9. Add Subreports (4:23)
  10. Create Mailing Labels (4:05)
  11. Import Excel (8:53)
  12. Import Text & CSV File (7:55)
  13. Export To Word (3:38)
  14. Export To CSV File (6:50)
  15. Export To Excel for Charts & PivotTables (2:30)
  16. Export To Text File (4:57)
  17. Merge With Word (8:03)

Access 2013 Level 3 (4 hrs):

More Advanced Tables

  1. Normalization Standard (3:33)
  2. Table Analyzer A (8:26)
  3. Table Analyzer B (5:04)
  4. Many To Many Relationships (8:55)
  5. Restructuring Tables (10:36)
  6. Hide Table Columns (1:45)

More Advanced Queries

  1. Subqueries (5:14)
  2. Unmatched Query (4:07)
  3. Duplicate Query (2:33)
  4. Criteria Groups Query (8:35)
  5. Cross Tab Query Wizard (7:08)

Macros

  1. Create A Macro (10:26)
  2. Macro Button (4:45)
  3. Where Condition (3:25)
  4. Require Data Entry Macro (5:27)
  5. Display Message Macro (3:36)
  6. Automated Macro (6:23)

More Advanced Forms & Reports

  1. Conditional Formatting (4:38)
  2. Report Chart (4:43)
  3. Multiple Columns & Groups A (7:59)
  4. Multiple Columns & Groups B (5:09)
  5. Cancelling Print Job (5:08)
  6. Export To PDF (1:14)

Maintaining Access Database

  1. Linking To Outside Tables (4:02)
  2. Database Properties (2:27)
  3. Compact & Repair Database (1:28)
  4. Backup Database (0:51)
  5. Password Protect (2:36)
  6. Object Dependency (2:15)
  7. Database Documenter (1:57)
  8. Performance Analyzer (1:10)

Database Integration

  1. Import XML Data (9:08)
  2. Export To XML (1:46)
  3. Link To Outlook Contacts (2:47)
  4. Table Attachment Field (4:12)
  5. Save As Previous Version (2:24)
  6. Navigation Forms (6:50)
  7. Switchboard (9:12)
  8. Modifying Switchboards (5:00)
  9. Switchboard Startup Options (8:49)

Distribute Database & Security

  1. Split Database (5:30)
  2. Distributing Split Database (2:00)
  3. Trusted Location (2:07)
  4. Database Access Modes (2:25)
  5. Protect VBA Code (1:26)
  6. File Protection ACCDE (2:13)

SharePoint

  1. Export Table To SharePoint (6:16)
  2. Import & Link To SharePoint (2:17)
  3. Publish Database To SharePoint (2:58)

Bonus!

  1. Hide Empty Record Labels (6:06)
  2. Create Table Of Contents A (7:08)
  3. Create Table Of Contents B (4:15)
Access 2013 Training Videos

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

Find Similar Products by Category

Product Reviews

Write your own product review

  1. This is perfect, great instructor and step by step instructions for...

    I bought this as a refresher course for my new job. This is perfect, great instructor and step by step instructions for beginners to advance. Money well spent. I am going to see what other Training Video DVDs Kershaw has - after I am done with the Access 2013 Video Trainer.

    Marnie F. - Minnesota (Submitted on 17th Oct 2016)


  2. Excellent product. Thank you!

    Excellent product. Thank you!

    Cristian P. - Ohio (Submitted on 30th Oct 2015)


  3. Training videos from Dream Force are excellent!

    Training videos from Dream Force are excellent!

    Judith B. - Illinois (Submitted on 30th Oct 2015)


  4. Numero Uno Access 2013.

    I was skeptical about the effectiveness of this training video, but after one week of intensive training I'm now a 'Numero Uno Master' of Access 2013.

    Hamadou G. - Montana (Submitted on 16th Jul 2015)


  5. I found the video training to be very helpful.

    I found the video training to be very helpful.

    Charles G. - Kentucky (Submitted on 6th Apr 2015)


  6. Money well spent!!

    I really enjoy the video training, can review and learn at my own pace. Thank you Kirt.
    I plan on purchasing other training videos

    Jerry Weder, Edmonton AB, Canada (Submitted on 15th Mar 2015)


  7. As the other products I ordered from Dream Force like Word 2010

    This has been as helpful as the other products I ordered from Dream Force like Word 2010, Excel 2113, and project. I would say this is a better than average product if you want to learn. Much better than trying to learn from a book.

    Ken R. - Illinois (Submitted on 5th Feb 2015)


  8. FYI, this DVD landed me a Database Jr. Analyst gig! Making $50k starting!!

    As an Information Systems undergraduate, it is imperative to have a full grip of Database. Initially bought Teach Yourself Visually Access 2013, but then decided to give this DVD a try after a colleague recommended it. Gotta hand it to the instructor, Mr. Kirt! He manages to cover various aspects of this subject, which believe me, can be a lot to digest, but helps tremendously when sharing countless useful scenarios and imparting great insight!

    Amin M. - Virginia (Submitted on 6th Jan 2015)


  9. Top Notch Access 2013 Training Course.

    This Access 2013 video training course is the real deal, affordable, delivered with professionalism, straight to the point, with sample databases, quizzes, and the expert explanation of whom I consider to be a great teacher, Kirt Kershaw. Many can assimilate knowledge, but not so many can actually teach it. By breaking down intimidating concepts into less complicated easy to follow hands on project steps, building up to a great understanding of the application at hand, Kirt Kershaw delivers an outstanding and comprehensive Access 2013 course that would help anyone learn how to use the application confidently. I’ve been using Kirt Kershaw's video training courses for three years now. These video courses have been instrumental in achieving all my Microsoft Office Certifications.

    Edward G. - New York (Submitted on 6th Jan 2015)




Sign up to receive information about new videos:

Contact Info

Professional & Certified Training
on Microsoft's Office: Access, Excel, Outlook, PowerPoint, Project and Windows.

Dream Force, LLC
10348 S. 2420 E.
Sandy, UT 84092

800-978-9790
801-278-0892

Kirt Kershaw
Microsoft Certified Trainer

Kirt has over a decade of training experience with Microsoft's Office and Windows. He holds Microsoft Certifications from the year 2000 to the present, and can help you certify too!


Access 2016 Training Videos | Excel 2016 Training Videos | Word 2016 Training Videos | Office 2013 Training Videos | Access 2013 Training Videos | Excel 2013 Training Videos | Outlook 2013 Training Videos | PowerPoint 2013 Training Videos | Project 2013 Training Videos | Word 2013 Training Videos | Office 2010 Training Videos | Access 2010 Training Videos | Excel 2010 Training Videos | Outlook 2010 Training Videos | PowerPoint 2010 Training Videos | Project 2010 Training Video | Word 2010 Training Videos | Office 2007 Training Videos | Access 2007 Training Videos | Excel 2007 Training Videos | Outlook 2007 Training Videos | PowerPoint 2007 Training Videos | Project 2007 Training Videos | Word 2007 Training Videos | Windows 7 Training Videos | Windows Vista Training Videos

Microsoft Office Training Videos Home | DVD | Download | Reviews | About | Contact

Click the button below to add the Access 2013 Training Videos to your wish list.