Access Level 2

Course length:  1-day

Course Overview

This is the second part of a two-level course, and is intended to build on foundational knowledge. We will cover how to complete advanced form design tasks, add data validation, explore macros, better manage databases, secure databases, and much more.

By the end of this course, users should be comfortable managing existing databases and completing light database development and management work. Users should also know how to find information about databases and use the validation techniques covered to ensure the integrity of the data that is collected.

Prerequisites

Access Level 1 or equivalent knowledge

Outline

Implementing Advanced Form Design

• Add Controls to Forms
• Set Form Controls
• Create Sub forms
• Organize Information with Tab Pages
• Enhance Navigation with Forms
• Format a Form
• Apply Conditional Formatting
• Using Data Validation
• Form and Field Validation
• Data Validation Using Controls

Using Macros to Improve User Interface Design

• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Convert a Macro to VBA

Using Advanced Database Management

• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

Distributing and Securing a Database

• Split a Database for Multiple User Access
• Implement Security
• Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature

Managing Switchboards

• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options