Overview

In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 - Part 1 course.

Objectives

In this course, you will learn to create and manage a fundamental Access 2016 database. You will:
  • Customize a form layout to improve usability and efficiency of data entry
  • Share data across applications
  • Use macros to improve user interface design
  • Use VBA to enhance tasks
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the startup options.

Audience

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.

Syllabus

Implementing Advanced Form Design

  • Topic A: Add Controls to Forms
  • Topic B: Enhance Navigation and Organization of Forms
  • Topic C: Apply Conditional Formatting

Sharing Data Across Applications

  • Topic A: Import Data into Access
  • Topic B: Export Access Data
  • Topic C: Link Tables to External Data Sources
  • Topic D: Create a Mail Merge

Using Macros to Improve User Interface Design

  • Topic A: Create a Macro
  • Topic B: Restrict Records Using a Condition
  • Topic C: Validate Data Using a Macro
  • Topic D: Automate Data Entry Using a Macro

Using VBA

  • Topic A: Getting Started with VBA
  • Topic B: Enhance Access Using VBA

Using Advanced Database Management

  • Topic A: Manage a Database
  • Topic B: Determine Object Dependency
  • Topic C: Document a Database

Distributing and Securing a Database

  • Topic A: Splitting a Database for Multiple User Access
  • Topic B: Implement Security
  • Topic C: Convert an Access Database to an ACCDE File
  • Topic D: Package a Database with a Digital Signature

Managing Switchboards

  • Topic A: Create a Database Switchboard
  • Topic B: Modify a Database Switchboard
  • Topic C: Set Startup Options

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Outlook on the web
Worldwide
This skill has an average salary of
US$0
and is mentioned in
0.00%
of job ads.
Usability
Worldwide
This skill has an average salary of
US$85,837
and is mentioned in
0.77%
of job ads.
Visual Basic for Applications
Worldwide
This skill has an average salary of
US$76,831
and is mentioned in
0.42%
of job ads.
Database
Worldwide
This skill has an average salary of
US$80,943
and is mentioned in
11.84%
of job ads.