Professional Development

Professional Development Events

Back to the Professional Development home

Using Microsoft Access with Your Datatel Data (Counseling)

Event date: 5/2/2018 9:00 AM - 12:00 PM Export event

Published on 3/21/2018.

Using MS Access with Your Datatel Data

9:00am-12:00pm, Wednesday, May 2, 2018

FM 112

The purpose of this mini-course is to help Counseling users learn how to use MS Access to view and report their Datatel data. We will build lots and lots of queries! And maybe learn a little database theory along the way.

The three-hour session will include:

  1. Tables, Records, and Fields (oh my)
  2. Simple queries using a single table
  3. Adding a prompt to your query (what is really happening under the hood when we do this)
  4. Joining multiple tables to form a query
  5. Using saved queries as data for new queries
  6. Queries that make new tables (discuss local tables vs linked or global tables)
  7. Discussion – When to use saved queries vs when to create and use new tables
  8. Queries that append records to existing tables
  9. Queries to update data in existing tables –  What’s the point of record pointers (keys)?
  10. Putting formulas in your queries
  11. Adding linked or global tables to your database (Where is the data I need?!)
  12. Creating macros to run a group of queries in succession
  13. Any extra time, I will help you create your own queries.

Theme picker

  2019 College of the Redwoods