Back to All Events

Microsoft Access: Part 2

Microsoft Access: Level 2

March 21 - 22, 2018 (two day course)
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center, Room 1005

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at, at least one week before the class date.

Course Outline:

1.   Advanced Queries
Create Unmatched & Duplicate Queries
Crosstab Queries
Create Subqueries

2.   Implementing Advanced Form Design
Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

3.  Using Data Validation
Field and Record Validation
Form Validation

4.  Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA

5.  Sharing Data Across Applications
Export Access Data to Excel
Export Access Data Create a PivotTable
Export Access Data Create a Mail Merge

6.  Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

7. Distributing and Securing a Database
Splitting Database for Multiple Users
Implement Security
Set Passwords
Convert Access Database to ACCDE File
Database with Digital Signature

8.   Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options


Earlier Event: March 20
Advanced QGIS
Later Event: March 28
Excel 2013 Advanced