×
  • This field is for validation purposes and should be left unchanged.

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 separate database professionals from the casual database users or occasional designers.

This class is taught in Microsoft Office 2013. The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

Instructors

Hannah Goodman

Hannah Goodman

Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more

Scott Lovy

Scott Lovy

Scott Lovy has been a resident of the Milwaukee area his whole life. He received his B.S. in electrical engineering from UW-Platteville in 1988. He is currently employed at a benefit management solutions company, where he is able to utilize ... read more

Who Should Attend

This course is designed for students 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.

Course Outline/Topics

Lesson 1: Implementing Advanced Form Design

Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

Lesson 2: Using Data Validation

Field 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
Implement Security
Set Passwords
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

Prerequisites

Access 2010/2013 – Level II (or equivalent experience)

Notes

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 nellenp@uwm.edu or 414-227-3208.

Testimonials

"Hannah is an expert in her field! Lucky to have her teaching these Continuing Ed courses. Thank you!"  —  Student, 2014

"I liked that we started the class with examples of problems that people deal with every day. It was very useful to me that people encountered other problems I also had, and Hannah went through those first before going into the manual."  —  Student, 2014

All sessions are Face-to-Face unless otherwise noted.

Fri., Nov. 17

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Scott Lovy

Fee:

$249 if you register by Fri., Nov. 3.
$274 if you register after Fri., Nov. 3.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-10171

Registration Deadline: Fri., Nov. 17

Register Now