# Microsoft Access Level III

Canonical URL: <https://training-nyc.com/courses/microsoft-access-level-3-2016>

## Overview

You've covered many of the basic functions of Microsoft Office Access 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

This training, added to that which you've gained from the [Microsoft Office Access 2016: Part 1](/courses/access-level-I) and [Microsoft Office Access 2016: Part 2](/courses/access-level-II) courses, rounds out your Access education and provides you with marketable job skills.

## What you'll learn

- 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

## Prerequisites

Students must have Access proficiency equivalent to our [Microsoft Access Level II](/courses/access-level-ii) course.

## Curriculum

#### Lesson 1: Implementing Advanced Form Design

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

#### Lesson 2: 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

#### Lesson 3: 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

#### Lesson 4: Using VBA

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

#### Lesson 5: Using Advanced Database Management

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

#### Lesson 6: 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

#### Lesson 7: Managing Switchboards

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

## Pricing

**Tuition:** $229