Microsoft Access, Level 2

Session Detail:    Classroom, Virtual 2013, 2016, Office 365 1 Day

Session Detail:

Access is Microsoft’s popular database program. This, the second part of a two-level course, explores advanced Access features. Whether you’re using Access for the first time, or have been using it for years, this course will help you make the most of all the tools and features Access has to offer. 

What You’ll Learn

  • Implementing Advanced Form Design
  • Using Data Validation
  • Using Macros to Improve User Interface Design
  • Using Advanced Database Management
  • Distributing and Securing a Database
  • Managing Switchboards

Session 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: Field Validation

Topic B: Form and Record 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: Split 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

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart
Mar 20, 20209:00AM-4:00PM ESTClassroom$265.00
Mar 20, 20209:00AM-4:00PM ESTVirtual$265.00
Apr 22, 20209:00AM-4:00PM ESTClassroom$265.00
Apr 22, 20209:00AM-4:00PM ESTVirtual$265.00
May 18, 20209:00AM-4:00PM ESTClassroom$265.00
May 18, 20209:00AM-4:00PM ESTVirtual$265.00
Jun 26, 20209:00AM-4:00PM ESTClassroom$265.00
Jun 26, 20209:00AM-4:00PM ESTVirtual$265.00
Jul 31, 20209:00AM-4:00PM ESTClassroom$265.00
Jul 31, 20209:00AM-4:00PM ESTVirtual$265.00

Microsoft Access, Level 2

1 Day
Classroom, Virtual



Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now