800.978.9790
 Loading... Please wait...


  • Image 1

Access 2007 Level 2 (Download)

$14.95
Quantity:

Product Description

Access 2007 Level 2 training videos download comes in Windows Media Video (.wmv) file format. Our Access 2007 Level 2, with Levels 1 & 3 training videos include all the training you need to pass the Access 2007 (77-605) Exam and become certified!

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!

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 2 Training Videos (Download)

Access 2007 Level 2 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Access 2007 Level 2 Training Videos (Download)
.

Product Reviews

Write Review

This product hasn't received any reviews yet. Be the first to review this product!

Find Similar Products by Category