Call

Microsoft® Access® 2013: Level 3

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Access 2013
Course Number: 091006

Course Objective:

Upon successful completion of this course, you will 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 causal database users or occasional designers.

Target Student:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.

Course Objective:

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

Course Outline

Lesson 1: Implementing Advanced Form Design

Topic A: Add Controls to Forms
Topic B: Create Subforms
Topic C: Organize Information with Tab Pages
Topic D: Enhance Navigation of Forms
Topic E: Apply Conditional Formatting

Lesson 2: Using 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: Using 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: Splitting 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 Course Catalog