Over

500+

Placements

Sunday CLOSED

Mon to Sat (8.30am - 17.30pm)

Call us +91 9986494980

 

MS Access 2013 Video Training

Sale!

MS Access 2013 Video Training

3,000 1,000

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.

  • 15 hours of detailed, high quality Flash and Windows Media Video Access 2013 Training Videos.
  • DVD bonus: Exercise Files, Instructor Notes, Quiz and Answers.
  • All training completed by Microsoft Certified Trainer, Kirt Kershaw.
  • Long time user of Microsoft, Kershaw offers more insights and points of view than other trainings.
  • Access 2013 (77-424) Exam: Our Access 2013 training videos include all the training you need to pass!
Category:

Description

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