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