Microsoft Access Level 3

Overview: You’ve covered many of the basic functions of Microsoft® Office Access® 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. Today’s training, added to that which you’ve gained from the Microsoft® Office Access®: Part 1 and Microsoft® Office Access®: Part 2 courses, rounds out your Access education and provides you with marketable job skills.

Objectives: In this course, you will learn to create and manage a fundamental Access 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

Course Outline:

Lesson 1: Implementing Advanced Form Design
• Add Controls to Forms
• Enhance Navigation and Organization of Forms
• Apply Conditional Formatting

Lesson 2: Sharing Data Across Applications
• Import Data into Access
• Export Access Data
• Link Tables to External Data Sources
• Create a Mail Merge

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

Lesson 4: Using VBA
• Getting Started with VBA
• Enhance Access Using VBA

Lesson 5: Using Advanced Database Management
• Manage a Database
• Determine Object Dependency
• Document a Database

Lesson 6: Distributing and Securing a Database
• Splitting a Database for Multiple User Access
• Implement Security
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature

Lesson 7: Managing Switchboards
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options

Length of Class: 
One Day
Instructor-led or Online: 
Instructor-Led

View upcoming Class Schedule & Signup for a Class!