Microsoft Office Access 2016 Advanced
3.7 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
32 students enrolled

Microsoft Office Access 2016 Advanced

Access 2016 Advanced
3.7 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
32 students enrolled
Last updated 11/2018
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Add controls to forms
  • Apply conditional formatting
  • Import and export data into and from Access
  • Create a mail merge
  • Create a macro
  • Use VBA
  • Use advanced database management tools
  • Split a database for multiple user access
  • Package a database with digital signatures
  • Create and manage a database switchboard
  • Set start-up options
Requirements
  • The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or Microsoft Office 2010 especially Microsoft Office Access 2016.
  • In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
  • The course is part of the three course series on Microsoft Office Access 2016.
  • It is recommended that the students complete the previous levels before opting for this course.
Description

The Microsoft Office Access 2016: Advanced course builds upon basic Microsoft Access skills acquired in Access Basic and Intermediate 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.

Who this course is for:
  • Individuals looking to update their skill-set to Microsoft Office Access 2016
  • Data entry operators
  • Writers and publishers
  • Candidates seeking to move to the latest version of Microsoft Office Access
Course content
Expand all 96 lectures 02:15:31
+ Chapter 01 - Implementing Advanced Form Design
13 lectures 29:05
The frmInventory Target Layout
00:18
Topic B: Enhance Navigation and Organization of Forms
00:10
Demo - Creating a Subform
03:44
Demo - Creating Tab Pages
05:12
Demo - Creating a Navigation Form
05:14
Topic C: Apply Conditional Formatting
00:07
Demo - Changing the Display of Data Conditionally
02:56
Chapter 01 Review
00:36
Review - Question
5 questions
+ Chapter 02 - Sharing Data Across Applications
17 lectures 21:33
Sharing Data Across Applications
00:31
Topic A: Import Data into Access
00:06
External Data Tab—Import & Link Group
00:53
Get External Data Wizard
01:17
Demo - Importing Data from a Text File
02:43
Demo - Importing Data from an Excel File
02:55
Topic B: Export Access Data
00:05
Demo - Exporting Data
04:45
Topic C: Link Tables to External Data Sources
00:09
Linked Table Manager
01:35
Demo - Using an External Data Source
02:58
Topic D: Create a Mail Merge
00:10
Microsoft Word Mail Merge Wizard
00:53
Merge Fields
00:27
Chapter 02 Review
00:19
Review - Question
5 questions
+ Chapter 03 - Using Macros to Improve User Interface Design
14 lectures 20:45
Using Macros to Improve User Interface Design
00:48
Topic A: Create a Macro
00:10
The Macro Builder Window and Action Catalog
02:11
Macro Actions and Positioning Arrows
01:23
Demo - Creating a Macro to Open a New Record on a Form
02:36
Topic B: Restrict Records by Using a Condition
00:05
The OpenForm Macro Action with Where Condition
01:04
Demo - Using the Where Condition to Restrict Data
02:23
Topic C: Validate Data by Using a Macro
00:07
Topic D: Automate Data Entry by Using a Macro
00:10
Demo - Automating Data Entry with a Macro
03:34
Chapter 03 Review
00:34
+ Chapter 04 - Using VBA
8 lectures 14:41
Using VBA
00:31
Topic A: Getting Started with VBA
00:12
Demo - Creating a Standard Module
03:17
Demo - Converting a Macro to VBA
01:36
Topic B: Enhance Access by Using VBA
00:06
Demo - Enhancing Forms with VBA
05:50
Chapter 04 Review
00:30
+ Chapter 05 - Using Advanced Database Management
12 lectures 15:02
Using Advanced Database Management
00:52
Topic A: Manage a Database
00:09
Demo - Compacting and Repairing a Database
02:36
Analysis Results
01:30
Demo - Using the Performance Analyzer
01:48
Topic B: Determine Object Dependency
00:11
The Object Dependencies Pane
01:06
Demo - Viewing Object Dependency
02:43
Topic C: Document a Database
00:07
Using the Database Documenter
01:09
Demo - Using the Database Documenter
02:15
Chapter 05 Review
00:36
+ Chapter 06 - Distributing and Securing a Database
17 lectures 17:55
Distributing and Securing a Database
01:01
Topic A: Splitting a Database for Multiple -User Access
00:08
Viewing Tables in a Split Database
02:04
Demo - Splitting a Database
01:54
Topic B: Implement Security
00:09
The Message Bar
01:08
The Trust Center Dialog Box
00:22
Demo - Adding a Trusted Location
01:33
Demo - Setting a Database Password
01:56
Topic C: Convert an Access Database to an ACCDE File
00:09
Creating an ACCDE File
00:48
Quick Start Database Templates Menu
00:35
Template Customization
00:50
Demo - Converting a Database to ACCDE Format
01:29
Topic D: Package a Database with a Digital Signature
00:10
Demo: Package a Database with a Digital Signature
03:00
Chapter 06 Review
00:39
+ Chapter 07 - Managing Switchboards
12 lectures 12:54
Managing Switchboards
00:25
Topic A: Create a Database Switchboard
00:07
The Switchboard Manager’s Main Screen
01:00
Demo - Creating a Simple Switchboard
03:37
Topic B:Modify a Database Switchboard
00:06
Demo - Modifying a Switchboard
01:48
Topic C: Set Start-up Options
00:04
Start-up Options for the Current Database
00:40
Error Checking Options
00:21
Demo - Setting Start-up Options
02:34
Chapter 07 Review
00:31
Course Closure
01:41