×

Microsoft Access Level III

This course is for those who are ready to 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.

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

Course Content Microsoft Access Level III

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 will 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.

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

Thu., Nov. 19

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8423

Registration Deadline: Wed., Nov. 18

Register Now

Wed., May 11, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8422

Registration Deadline: Tue., May 10, 2016

Register Now

FacebookTwitterGoogle+Share