Course length: 1-day
This is the second part of a two-level course, and is intended to build on foundational knowledge. We will cover how to complete advanced form design tasks, add data validation, explore macros, better manage databases, secure databases, and much more.
By the end of this course, users should be comfortable managing existing databases and completing light database development and management work. Users should also know how to find information about databases and use the validation techniques covered to ensure the integrity of the data that is collected.
Prerequisites
Access Level 1 or equivalent knowledge
Course Outline
Lesson 1: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Set Form Controls
Topic C: Create Subforms
Topic D: Organize Information with Tab Pages
Topic E: Enhance Navigation with Forms
Topic F: Format a Form
Topic G: Apply Conditional Formatting
Lesson 2: Using Data Validation
Topic A: Form and Field Validation
Topic B: Data Validation Using Controls
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: Split a Database for Multiple User Access
Topic B: Implement Security
Topic C: 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
Certification
Before testing you will need:
- Access Level 1 Foundation
- Access Level 2 Intermediate
Is Level 2 right for you?
Try our self-assessment