For best performance, please enable Javascript in your browser settings.

Computer Education at the Science Museum of Minnesota: Class Series Details

Class Series Details

Below are the descriptions, prerequisites, schedule, and cost for the class(es) within this class series.

To register for a class, add it to your cart.


Access

Microsoft Access is a powerful relational database program used for storing, organizing, and manipulating information.

Note: Topics taught in these classes apply to versions 2010, 2013, 2016, and 365.


Introduction

Prerequisites: Experience using a computer.

Recommended: Database Design Basics Seminar or equivalent experience.

Class Topics:

  • Database concepts (tables, records, fields, relationships)
  • Designing and creating tables
  • Sorting and filtering data
  • Creating relationships
  • Introduction to queries, forms, and reports

Date Time Location Fee  
Tue, Jan 22, 2019 8:00am - 11:45am St. Paul $159.00
Mon, Feb 11, 2019 8:00am - 11:45am St. Paul $159.00
Tue, Mar 12, 2019 8:00am - 11:45am St. Paul $159.00
Thu, Apr 11, 2019 8:00am - 11:45am St. Paul $159.00


Queries

Prerequisites: Access Introduction or equivalent experience.

Class Topics:

  • Calculation and concatenation queries
  • Summary queries and parameter queries
  • Action queries
  • Importing data

Date Time Location Fee  
Tue, Jan 22, 2019 1:00pm - 4:45pm St. Paul $159.00
Mon, Feb 11, 2019 1:00pm - 4:45pm St. Paul $159.00
Tue, Mar 12, 2019 1:00pm - 4:45pm St. Paul $159.00
Thu, Apr 11, 2019 1:00pm - 4:45pm St. Paul $159.00


Forms and Reports - Part 1

Prerequisites: Access Introduction and Queries or equivalent experience.

Class Topics:

  • Moving, adding, and aligning controls
  • Setting and changing properties
  • Adding list boxes, combo boxes, and buttons
  • Section formatting

Date Time Location Fee  
Tue, Jan 29, 2019 8:00am - 11:45am St. Paul $159.00
Wed, Feb 20, 2019 8:00am - 11:45am St. Paul $159.00
Wed, Apr 17, 2019 8:00am - 11:45am St. Paul $159.00


Forms and Reports - Part 2

Prerequisites: Access Introduction, Queries, and Forms and Reports Part 1 or equivalent experience.

Class Topics:

  • Creating calculated fields
  • Building subforms
  • Working with groups and subtotals
  • Multicolumn reports

Date Time Location Fee  
Tue, Dec 18, 2018 1:00pm - 4:45pm St. Paul $159.00
Tue, Jan 29, 2019 1:00pm - 4:45pm St. Paul $159.00
Wed, Feb 20, 2019 1:00pm - 4:45pm St. Paul $159.00
Wed, Apr 17, 2019 1:00pm - 4:45pm St. Paul $159.00