Skip to main content

Intermediate Microsoft Access 2016 (ES)

ID : 61957   
« back to classes page
Please note: Effective November, 2015, the registration process for this online class has changed. When enrolling, you will be directed to a new web page to complete your online registration.
New sessions of this class begin on the third Wednesday of each month, and each session covers six weeks of online training.  New lessons are released each Wednesday and Friday during those six weeks, and you will be able to complete the course work at your convenience – at any time of day or night.  To select a start date that works with your schedule, click the registration link at the end of the course description below.
Course description
Course requirements
Syllabus

Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.

You'll start by importing customer and order information from several Excel spreadsheets as tables in a new database. You'll learn how to add key fields to the tables, update these fields using action queries, and build relationships between the tables.

Once you've mastered proper table construction, you'll build on that knowledge by learning how to create forms to manage table data. You'll discover how to construct crosstab and summary queries, and crunch numbers using query calculations. You'll also learn about outer table joins that can make your queries more effective.

From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.

Class Details

12 Sessions
Online 24/7

Location
Course Details

Instructor
NA NA 

CEUs : 2.4

Tuition: 

$129.00


Registration Closes On
Friday, September 20, 2019 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
8/14/2019 - 9/20/2019 Online 24/7 12:00 AM - 12:00 AM N/A - Online NA NA 

Other Class Offerings

Intermediate Microsoft Access 2016 (ES)
ID: 61953

06/12/19 - 07/19/19
Online 24/7

Location
Course Details

Instructor
NA NA

Intermediate Microsoft Access 2016 (ES)
ID: 61955

07/17/19 - 08/23/19
Online 24/7

Location
Course Details

Instructor
NA NA

Intermediate Microsoft Access 2016 (EWS)
ID: 62009

04/17/19 - 05/24/19
Online 24/7

Location
Course Details

Instructor
NA NA

Intermediate Microsoft Access 2016 (EWS)
ID: 61951

05/15/19 - 06/21/19
Online 24/7

Location
Course Details

Instructor
NA NA

Contact Us!

ncal@normandale.edu - 952.358.8343
Normandale Community College - Continuing Education

9700 France Avenue South, Bloomington, MN 55431

A member of the Minnesota State Colleges & Universities System