Call

Microsoft® Access® 2010: Level 3

< Back to Main Page

Duration:

1 Day (6.5 instructional hours)

Access 2010

Course Number: 091003


Course Objective:

You will learn advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more.

Target Student:

This course is intended for students who desire to gain advanced skills with Access 2010, and/or those who seek the Microsoft Office Specialist (MOS) certification.

Course Objective:

To ensure success, students will need to be familiar with using or have equivalent knowledge of Microsoft® Office Access® 2010: Level 1 & 2.


Course Outline

Lesson 1: Advanced Form DesignTopic A: Add Controls to Forms

Topic B: Create Subforms

Topic C: Organize Information with Tab Pages

Topic D: Display a Summary of Data in a Form

Topic E: Apply Conditional Formatting


Lesson 2: Data Validation

Topic A: Field and Record Validation

Topic B: Form Validation


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

Topic E: Convert a Macro to VBA


Lesson 4: Advanced Database Management

Topic A: Link Tables to External Data Sources

Topic B: Manage a Database

Topic C: Determine Object Dependency

Topic D: Document a Database

Topic E: Analyze the Performance of a Database


Lesson 5: Distributing and Securing a Database

Topic A: Prepare a Database for Multiple User Access

Topic B: Implement Security

Topic C: Set Passwords

Topic D: Convert an Access Database to an ACCDE File

Topic E: Package a Database with a Digital Signature


Lesson 6: Managing Switchboards

Topic A: Create a Database Switchboard

Topic B: Modify a Database Switchboard

Topic C: Set Startup Options


< Back to Main Page