Access 2016 Training Videos

(10 reviews) Write a Review
SKU:
access2016
UPC:
091037704597
Condition:
New
Availability:
Usually ships in 1 business day.
Shipping:
Calculated at Checkout
  • Access 2016 Training Videos
$49.95

Description

Microsoft Access 2016 Training Videos - Master Microsoft Access from Beginner to Advanced

  • Build a solid understanding on the Basics of Microsoft Access:
    • Create an Access database from scratch including the four basic objects: Tables, Queries, Forms and Reports
    • Table -
      • Learn how to create a table to store and organize all your raw data into
      • Enter, edit, update, search, sort and filter your table's records
      • Relate one table to another by creating relationships
    • Query -
      • Create a query to help in your search and retrieve data from a table fast
      • Learn how to add criteria to a query to narrow your search for more accurate results
    • Form -
      • Enter and view your records from a table, or query in a more organized layout by creating a form
      • Learn how to quickly edit, filter and search your records in a form
    • Report -
      • Learn how to print, or email your records from a table, query or form by creating a report
      • Add a custom field to perform a calculation to add, count, average and more
  • Expand your knowledge with Advanced Access features:
    • Tables - learn how to set defaults and validate data with a rule for more accurate data
    • Queries - view unique records and use actions queries to update, add and delete records fast
    • Forms - add option controls, command buttons and drop down lists for faster data entry and accuracy
    • Reports - learn how to add, sort and filter groups as well as keeping them from splitting across pages
    • Macros - automate your data entry and accuracy dramatically by creating macros.

Unique tips, tricks, shortcuts and other Access time saving features you won't find taught in ANY other course, by the ONLY multi-certified Microsoft Office trainer since Microsoft Office 2000; including all the training you need to help pass the Access 2016 (77-730) Exam and become certified, guaranteed.

DVD includes: Access 2016 Levels 1, 2 & 3 training videos in both MP4 (.mp4) and Windows Media Video (.wmv), Exercise Files, Quiz, Answers and Instructor's Notes.

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 2 (5.1 hrs):

Advanced Tables

  1. Data Defaults & Validation Rule (14:38)
  2. Show Column History (4:45)
  3. Input Masks (9:06)
  4. Lookup Fields (11:58)

Advanced Queries

  1. Inner & Outer Data Joins (11:16)
  2. Join Unrelated Tables (2:15)
  3. Self Join (6:03)
  4. Top Values Query (4:40)
  5. Unique Values or Records (5:38)
  6. Wildcard Query (3:45)
  7. Parameter Query (8:06)
  8. Update Query (9:09)
  9. Append Query (6:57)
  10. Delete Query (7:13)
  11. Make Table Query (5:22)

Advanced Forms

  1. Layout View & Table Formats (12:37)
  2. Anchoring Controls (3:52)
  3. Filter & Sort Records (3:28)
  4. Enhancing Appearance (16:44)
  5. Combo Box (11:46)
  6. Option Controls Group (5:31)
  7. Form Tab Pages (12:02)
  8. Command Button (3:22)
  9. Subform (12:18)

Advanced Reports

  1. Organizing Records (11:04)
  2. Adding, Sorting & Filtering Groups (8:17)
  3. Advanced Formatting (22:13)
  4. Keep Groups Together (4:15)
  5. Force New Page (3:11)
  6. Adding Summary Field (13:34)
  7. Add Subreports (5:54)
  8. Create Mailing Labels (5:13)

Import and Export Data

  1. Import Excel (9:19)
  2. Import Text & CSV Files (8:32)
  3. Export to Word (2:48)
  4. Export to CSV File (5:43)
  5. Export to Excel for Charts & PivotTables (2:39)
  6. Export to Text File (3:39)
  7. Merge with Word (8:22)

Access 2016 Level 3 (4.1 hrs):

More Advanced Tables

  1. Normalization Standard (3:33)
  2. Table Analyzer (11:51)
  3. Many to Many Relationships (7:20)
  4. Restructuring Tables (8:31)
  5. Hide Table Columns (1:17)

More Advanced Queries

  1. Subqueries (5:40)
  2. Unmatched Query (4:44)
  3. Duplicate Query (2:27)
  4. Criteria Groups Query (7:57)
  5. Cross Tab Query Wizard (5:57)

Macros

  1. Create A Macro (9:48)
  2. Macro Button (4:07)
  3. Where Condition (3:34)
  4. Require Data Entry Macro (5:07)
  5. Display Message Macro (2:28)
  6. Automated Macro (5:16)

More Advanced Forms & Reports

  1. Conditional Formatting (4:37)
  2. Report Chart (4:47)
  3. Multiple Columns & Groups (15:04)
  4. Cancelling Print Job (3:52)
  5. Export To PDF (1:33)

Maintaining Access Database

  1. Linking to Other Database Tables (4:35)
  2. Database Properties (3:09)
  3. Compact & Repair Database (1:34)
  4. Backup Database (1:20)
  5. Password Protect (3:53)
  6. Object Dependency (2:19)
  7. Database Documenter (3:11)
  8. Performance Analyzer (2:23)

Database Integration

  1. Import XML Data (10:55)
  2. Export to XML (2:40)
  3. Link to Outlook Contacts (4:11)
  4. Table Attachment Field (5:00)
  5. Save As Previous Version (2:50)
  6. Navigation Forms (8:05)
  7. Switchboard (10:12)
  8. Modifying Switchboards (4:11)
  9. Form Startup & Options (8:54)

Distribute Database & Security

  1. Split Database (5:48)
  2. Distributing Split Database (2:29)
  3. Database Access Modes (2:43)
  4. Trusted Location (2:37)
  5. Protect VBA Code (1:56)
  6. File Protection ACCDE (2:38)

Bonus!

  1. Digitally Sign Database (5:54)
  2. Hide Empty Record Labels in Reports (7:04)
  3. Create Table of Contents (13:10)
  4. Custom Display Control for Text Box (4:49)
Access 2016 Training Videos

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

View AllClose

10 Reviews

  • 5
    Consiglio questo corso a chiunque voglia utilizzare Access:

    Posted by Massimiliano Presenti on 10th Aug 2018

    L'audio è chiaro e la pronuncia inglese è molto facile da capire; questo, unito ad un ritmo medio mi ha permesso di seguire le lezioni senza faticare, arrivando addirittura ad eliminare i sottotitoli.
    Il programma affrontato è piuttosto ampio.
    Nella parte base si rischia di annoiarsi un po' se si ha già una certa dimestichezza con l'ambiente, ma conviene comunque guardala perché ogni aspetto dell'interfaccia viene affrontato e quindi si possono scoprire cose nuove.
    Il livello intermedio ha un altro ritmo e tutti i vari aspetti vengono spiegati mentre si applicano e questo lo ritengo il miglior modo per capire (e ricordare).
    Il livello avanzato è focalizzato sugli aspetti più specifici di Access e quindi è la "rifinitura" di quanto appreso nelle parti precedenti.
    Consiglio questo corso a chiunque voglia utilizzare Access: permette di partire da subito con l'impostazione corretta, sapendo quali strumenti ha a disposizione.

  • 5
    This course is a great overview to get you started on Microsoft Access.

    Posted by Christian Grant on 10th Aug 2018

    Functionality was explained well, examples were good, and the pace was comfortable

  • 5
    Excelente curso de Access.

    Posted by Josué Monroy Hengst on 10th Aug 2018

    Contenido bien estructurado y explicaciones claras.

  • 5
    I would highly recommend this course for anyone who is serious about learning Access.

    Posted by Michael Diamond on 10th Aug 2018

    I found this course one of the best for really getting a good feel for Access that I've taken on Udemy. He did cover topics ranging from beginning to advanced and his lesson plan was easy to follow.
    I found Kirt quite knowledgeable regarding Access and though I've taken many Access courses I was able to deepen my knowledge about the program due to the little golden nuggets of information that he would through into his lessons.
    The items that Kirt cover in depth were SQL, VBA and he does offer some tutorials on using macros. I'm sure if his intent was to teach these in depth he would have included them in the course.
    But, these subjects are entire courses in themselves. He does reference these where necessarily but his goal wasn't to teach how to use them from scratch like I've taken in other Udemy courses. I wasn't overwhelmed by information overload.
    Other than that, he covered topics that some of the other instructors didn't cover.
    I would highly recommend this course for anyone who is serious about learning Access.
    I also found him quite witty which made the course entertaining as well as educational.
    I plan on taking his other courses as well.

  • 5
    I like what I'm seeing thus far.

    Posted by Michael Krailo on 10th Aug 2018

    I like what I'm seeing thus far. There are a lot of concepts to cover but I'm already starting to formulate the design of the database I have in mind which is what I was hoping to get out of this course. Thank you Kirt.

  • 5
    Great course

    Posted by Victor on 10th Aug 2018

    Great course

  • 5
    Videos were well done and easy to follow.

    Posted by Dan on 10th Aug 2018

    A thorough overview of Access 2016! Videos were well done and easy to follow. The speaker was excellent and kept the pace up so things didn't get boring. I appreciated the short training clips too. Makes it easier for me to find and review specific program features when I need a refresher and allowed me to fit watching the training into open slots in my daily schedule. I would definitely purchase other training videos from this author.

  • 4
    Good Info

    Posted by Alan on 10th Aug 2018

    The guy obviously knows his stuff. I wish we could have seen some database implementation strategies (i.e. a daisy database example) but it does cover how to use every feature in Access.

  • 5
    Great product at a very reasonable price

    Posted by Unknown on 17th Jan 2018

    Great product at a very reasonable price. I am very pleased with the purchase. The information is broken up into small segments so I can view each one in a short period of time and replay if I feel that I missed any information.

View AllClose