Microsoft Access Level III
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 separates database professionals from the casual database users or occasional designers.
This class is taught in Microsoft Office 2013. The UWM School of Continuing Education computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.
Who Should Attend
This course is designed for people wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports or integrating Access with other programs.
Lesson 1: Implementing Advanced Form Design
Add Controls to Forms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting
Lesson 2: Using Data Validation
Form and Record Validation
Lesson 3: Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Entry Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA
Lesson 4: Using Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Lesson 5: Distributing and Securing a Database
Split a Database for Multiple User Access
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Lesson 6: Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options
Access 2010/2013 – Level II (or equivalent experience)
Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010, the functions and features you learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at firstname.lastname@example.org or 414-227-3208.
"Great course. Lots of good information and I love that we are able to follow up with information on the web and through other social media." — Program and Policy Analyst, 2017
"Great instructor and knows the material very well." — Physician Compensation Analyst, 2018
All sessions are Face-to-Face unless otherwise noted.