800.978.9790
 Loading... Please wait...


  • Image 1

Access 2007 Training Videos

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

Product Description

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!

DVD includes Access 2007 Levels 1, 2 & 3 training videos in both: Flash (.swf) and Windows Media Video (.wmv). Our Access 2007 Levels 1, 2 & 3 training videos include all the training you need to pass the Access 2007 (77-605) Exam and become certified!

Access 2007 Level 1 (4.5 hrs):

Basics

  1. About Access (11:32)
  2. Access Overview (10:29)
  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)

Access 2007 Level 2 (3.6 hrs):

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

Access 2007 Level 3 (4.3 hrs):

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)
  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)
  5. Table Attachment Fields (4:23)
  6. Convert To Previous Version (1:34)
  7. Switchboards (7:22)
  8. Modifying Switchboards (1:55)
  9. 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

 

Access 2007 Training Videos

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

Product Reviews

Write Review

Showing reviews 1-10 of 35 | Next

  1. 5 Star Review I will recommend your site to others.

    Posted by on 20th Oct 2015

    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.

  2. 5 Star Review They are the best video of this kind I've seen.

    Posted by on 20th Oct 2015

    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.

  3. 5 Star Review Loved it.

    Posted by on 20th Oct 2015

    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.

  4. 5 Star Review So pleased I just ordered the complete Office 2007 set.

    Posted by on 20th Oct 2015

    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.

  5. 5 Star Review Very clear, good speaker, good screen size, etc..

    Posted by on 20th Oct 2015

    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.

  6. 5 Star Review The best asset of this video is the clear voice of the trainer.

    Posted by on 20th Oct 2015

    I bought the training video a few months back and it has been put to a good use. Having a very minimal knowledge 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.

  7. 5 Star Review Incredibly easy to follow.

    Posted by on 20th Oct 2015

    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.

  8. 5 Star Review I simply wanted to send you a note saying … job well done.

    Posted by on 20th Oct 2015

    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.

  9. 5 Star Review LOVE the Access 2007 training videos.

    Posted by on 20th Oct 2015

    Recommending them to everyone.

  10. 5 Star Review You'll will find that it is great to watch and listen.

    Posted by on 20th Oct 2015

    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.

Showing reviews 1-10 of 35 | Next

Find Similar Products by Category