Integrity Training – Microsoft Office Access 2016 Advanced

Integrity Training – Microsoft Office Access 2016 Advanced

The Microsoft Office Access 2016: L3 course builds upon basic Microsoft Access skills acquired in Access Level 1 and Level 2 courses to help students become the masters of Microsoft Office Access 2016. In this Microsoft Access course, students will delve deeper into the program by studying more complex topics such as implementing advanced form designs, sharing data across applications, using macros to improve user interface, using VBA, using advanced database management, distributing and securing a database and managing switchboards.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.
Course Curriculum

Introduction

Start

Course Introduction (2:19)

Start

Courseware (0:15)

Start

Instructor Introduction (1:02)

Chapter 01 – Implementing Advanced Form Design

Start

Implementing Advanced Form Design (0:45)

Start

Topic A: Add Controls to Forms (0:06)

Start

The Original frmInventory View (2:31)

Start

The frmInventory Target Layout (0:18)

Start

Quick Styles (0:28)

Start

Demo – Changing the Tab Order on a Form (6:58)

Start

Topic B: Enhance Navigation and Organization of Forms (0:10)

Start

Demo – Creating a Subform (3:44)

Start

Demo – Creating Tab Pages (5:12)

Start

Demo – Creating a Navigation Form (5:14)

Start

Topic C: Apply Conditional Formatting (0:07)

Start

Demo – Changing the Display of Data Conditionally (2:56)

Start

Chapter 01 Review (0:36)

Start

Chapter 01 Quiz

Chapter 02 – Sharing Data Across Applications

Start

Sharing Data Across Applications (0:31)

Start

Topic A: Import Data into Access (0:06)

Start

External Data Tab—Import & Link Group (0:53)

Start

Get External Data Wizard (1:17)

Start

Demo – Importing Data from a Text File (2:43)

Start

Demo – Importing Data from an Excel File (2:55)

Start

Topic B: Export Access Data (0:05)

Start

External Data Tab—Export Group (1:19)

Start

Demo – Exporting Data (4:45)

Start

Topic C: Link Tables to External Data Sources (0:09)

Start

Linked Table Manager (1:35)

Start

Demo – Using an External Data Source (2:58)

Start

Topic D: Create a Mail Merge (0:10)

Start

Microsoft Word Mail Merge Wizard (0:53)

Start

Merge Fields (0:27)

Start

The Mail Merge Task Pane (0:28)

Start

Chapter 02 Review (0:19)

Start

Chapter 02 Quiz

Chapter 03 – Using Macros to Improve User Interface Design

Start

Using Macros to Improve User Interface Design (0:48)

Start

Topic A: Create a Macro (0:10)

Start

The Macro Builder Window and Action Catalog (2:11)

Start

Macro Actions and Positioning Arrows (1:23)

Start

Form Field Events (1:14)

Start

Demo – Creating a Macro to Open a New Record on a Form (2:36)

Start

Topic B: Restrict Records by Using a Condition (0:05)

Start

The OpenForm Macro Action with Where Condition (1:04)

Start

Demo – Using the Where Condition to Restrict Data (2:23)

Start

Topic C: Validate Data by Using a Macro (0:07)

Start

Demo – Using a Macro to Validate Data (4:26)

Start

Topic D: Automate Data Entry by Using a Macro (0:10)

Start

Demo – Automating Data Entry with a Macro (3:34)

Start

Chapter 03 Review (0:34)

Start

Chapter 03 Quiz

Chapter 04 – Using VBA

Start

Using VBA (0:31)

Start

Topic A: Getting Started with VBA (0:12)

Start

The VBA Editor (2:39)

Start

Demo – Creating a Standard Module (3:17)

Start

Demo – Converting a Macro to VBA (1:36)

Start

Topic B: Enhance Access by Using VBA (0:06)

Start

Demo – Enhancing Forms with VBA (5:50)

Start

Chapter 04 Review (0:30)

Start

Chapter 04 Quiz

Chapter 05 – Using Advanced Database Management

Start

Using Advanced Database Management (0:52)

Start

Topic A: Manage a Database (0:09)

Start

Demo – Compacting and Repairing a Database (2:36)

Start

Analysis Results (1:30)

Start

Demo – Using the Performance Analyzer (1:48)

Start

Topic B: Determine Object Dependency (0:11)

Start

The Object Dependencies Pane (1:06)

Start

Demo – Viewing Object Dependency (2:43)

Start

Topic C: Document a Database (0:07)

Start

Using the Database Documenter (1:09)

Start

Demo – Using the Database Documenter (2:15)

Start

Chapter 05 Review (0:36)

Start

Chapter 05 Quiz

Chapter 06 – Distributing and Securing a Database

Start

Distributing and Securing a Database (1:01)

Start

Topic A: Splitting a Database for Multiple -User Access (0:08)

Start

Viewing Tables in a Split Database (2:04)

Start

Demo – Splitting a Database (1:54)

Start

Topic B: Implement Security (0:09)

Start

The Message Bar (1:08)

Start

The Trust Center Dialog Box (0:22)

Start

Demo – Adding a Trusted Location (1:33)

Start

Demo – Setting a Database Password (1:56)

Start

Topic C: Convert an Access Database to an ACCDE File (0:09)

Start

Creating an ACCDE File (0:48)

Start

Quick Start Database Templates Menu (0:35)

Start

Template Customization (0:50)

Start

Demo – Converting a Database to ACCDE Format (1:29)

Start

Topic D: Package a Database with a Digital Signature (0:10)

Start

Demo: Package a Database with a Digital Signature (3:00)

Start

Chapter 06 Review (0:39)

Start

Chapter 06 Quiz

Chapter 07 – Managing Switchboards

Start

Managing Switchboards (0:25)

Start

Topic A: Create a Database Switchboard (0:07)

Start

The Switchboard Manager’s Main Screen (1:00)

Start

Demo – Creating a Simple Switchboard (3:37)

Start

Topic B:Modify a Database Switchboard (0:06)

Start

Demo – Modifying a Switchboard (1:48)

Start

Topic C: Set Start-up Options (0:04)

Start

Start-up Options for the Current Database (0:40)

Start

Error Checking Options (0:21)

Start

Demo – Setting Start-up Options (2:34)

Start

Chapter 07 Review (0:31)

Start

Chapter 07 Quiz

Start

Course Closure (1:41)

Get Integrity Training – Microsoft Office Access 2016 Advanced at tenco.pro