800.978.9790
 Loading... Please wait...


  • Access 2016 Training Videos Level 1 - Download

Access 2016 Level 1 (Download)

$14.95 $9.95
(You save $5.00)
Quantity:

Product Description

Access 2016 Level 1 training videos download comes in MP4 file format, with follow along exercise files, instructor notes, quiz and answers! Our Access 2016 Level 1, with Levels 2 & 3 training videos include all the training you need to pass the Access 2016 (77-730) exam and become certified!

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

Access 2016 Level 1 (7.4 hrs):

Basics

  1. Access 2016 Introduction (13:20)
  2. Access 2016 Overview (13:34)
  3. Access 2016 Help (1:48)
  4. Color Scheme & Save Defaults (4:40)
  5. Customize Quick Access Toolbar (7:07)
  6. Customize Ribbon (9:01)
  7. Datasheet Appearance (1:46)
  8. Document Window Options (7:25)
  9. Four Access Objects (13:41)
  10. Create Database (6:41)

Tables

  1. Create Tables (23:18)
  2. Entering Records (4:35)
  3. Save Table to PDF or XPS (3:31)
  4. Table Structuring (9:32)
  5. Managing Tables (5:25)
  6. Primary, Composite & Foreign Keys (13:52)
  7. Introduction to Relationships (7:35)
  8. One-to-Many Relationships (17:48)
  9. One-to-One Relationships (13:29)
  10. Denormalization (13:32)
  11. Managing Table Data (15:03)
  12. Sorting Records (5:10)
  13. Filtering Records (10:03)
  14. Subdatasheets (11:43)

Queries

  1. Query Introduction & Wizard (19:22)
  2. Create Query in Design (12:15)
  3. Query Criteria (20:58)
  4. Adding Calculated Fields (7:33)
  5. Group Calculations (8:15)
  6. Formatting Datasheets (3:39)

Forms

  1. Form Basics (18:41)
  2. Instant Forms (12:06)
  3. Form Wizard (5:59)
  4. Modify Forms (14:49)

Reports

  1. Reports Introduction (8:11)
  2. Instant Reports (8:52)
  3. Report Wizard (10:37)
  4. Custom Calculating Field (22:19)
  5. Formatting Controls (6:16)
  6. Applying Themes (5:29)
  7. Inserting Images (7:41)
  8. Adding Background Image (9:27)
  9. Report Hyperlinks (4:07)
  10. Prepare for Print (6:31)

 

Access 2016 Level 1 Training Videos (Download)

Access 2016 Level 1 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Access 2016 Level 1 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