Microsoft® Access® 2010: Level 3

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 Design

Topic 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