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