800.978.9790
 Loading... Please wait...


  • Image 1

Access 2010 Training Videos

$49.95
Availability:
Usually ships in 1 to 2 business days.
Shipping:
Calculated at checkout
Quantity:

Product 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), Excercise 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
.

Product Reviews

Write Review

Showing reviews 1-10 of 44 | Next

  1. 5 Star Review It will be my best companion as I prepare for my Microsoft Office Specialist Certification exam!

    Posted by on 20th Oct 2015

    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.

  2. 5 Star Review Loving the videos.

    Posted by on 20th Oct 2015

    Loving the videos.

  3. 5 Star Review Kirt Kershaw knocks them dead.

    Posted by on 20th Oct 2015

    Video Trainer Access 2010, simply stated, is the best vehicle I have seen to help users learn the ins and outs of this Microsoft application. Mr. Kershaw is the working definition of a teacher: 1/3 knowledge, 1/3 skill, 1/3 entertainment: he knows his material, is skilled at presenting it, and holds the students interest while doing so. From K-12 on up, education is a series of building blocks. What you learn at one level is often the foundation for the next. And across the board, this is the greatest flaw in education today - if a student fails to comprehend a building block in a foundation class, grasping related concepts in more advanced presentations are that much harder. This is not an issue with Video trainer Access 2010. The course is divided into three levels of training - Basic, Intermediate and Master. Within each level are mini-video presentations, each concentrating on one aspect of Access 2010. The student viewing Advanced Tables in in Level 2, or Level 3, can easily return to an earlier video in Level 1 or 2 to reinforce an earlier building block if need be. This technique allows the student to view each video until they are comfortable with the topic covered. And, because his voice is so easy on the ears, repeated viewings of a topic are not problematic. Finally, there is a PDF with Instructors notes for each level (which I recommend be printed and kept close at hand to add your own notes as the sections are viewed). There is a Student Question PDF and an accompanying Instructor Answer PDF for each level. Finally, where appropriate, there are exercises for the lesson which can be done in concert with the video presentation. Look no further for a top notch vehicle with which to learn Microsoft Access 2010. (There is an equally excellent training video available for Excel 2010 and the balance of Office 2010 applications - Word, PowerPoint and Outlook - will be available later in the year).

  4. 5 Star Review Kirt: I just wanted to say "THANKS"

    Posted by on 20th Oct 2015

    - because of your Access 2010 Video Training, I was able to pass my Access 2010 certification exam ON THE FIRST TRY. Now on to Word Expert! Thanks, again!

  5. 5 Star Review Thanks.

    Posted by on 20th Oct 2015

    Did all 3 levels over the weekend.. I must say.. great stuff.

  6. 5 Star Review A good investment - what I needed.

    Posted by on 20th Oct 2015

    *I bought the Access 2010 Training Videos by Kirt Kershaw about 2 months ago. Although I have not been through every session in the extensive set, I'm pleased so far. * Kirt doesn't waste time - I really appreciate that he has taken the time to organize the presentation so well. That means I know the time I spend with the videos will be a good investment. * I've actually been working with relational databases for 20 years, but I didn't know the in's and out's of Access. I bought the videos with a specific mission: a pilot project for my job. Everything I needed for the project was in the videos, organized so I could search and find what I needed for a particular component: forms, reports, queries, etc. * Overall, this product is what I needed, and it's pretty enjoyable too. I've plowed through a lot of those 1,000-page books about software products, and the video format, if done right, works better for me. I definitely recommend these videos.

  7. 5 Star Review Helpful video.

    Posted by on 20th Oct 2015

    Contains details required that the Microsoft tutorial was missing.

  8. 5 Star Review Very Nice.

    Posted by on 20th Oct 2015

    Haven't gotten all the way through it yet, but I can tell that there is a lot to be learned from this. I watch about 5 lessons a night. The lessons are short enough and stick to a specific topic. All lessons are built off previous ones. I will try out some of the exercises soon. Will repost when finished with the entire disk.

  9. 5 Star Review I will be buying more training videos from you and telling all that wants to listen!

    Posted by on 20th Oct 2015

    Excellent Customer service and training videos explained very nicely.

  10. 5 Star Review Watch the videos and you WILL learn Access!

    Posted by on 20th Oct 2015

    Excellent. Great training tool and much better than any live training class out there. Narrator is very knowledgeable and teaches at a nice pace. Videos teach basics through advanced lessons. Videos are brief and titles are well detailed and defined. Very easy to pick a specific topic if you just need a crash course or a refresher.

Showing reviews 1-10 of 44 | Next

Find Similar Products by Category