Skip to Main Content

University of Illinois Springfield

Cover Photo

University Calendar

skip to events

calendar tabs

  •  All 
  • Grid
  • Month
  • Week
  • Day
  • (Selected tab) Detail

Event Detail Information

Event Detail Information

[ITS Workshop] Introduction to Microsoft Access

Speaker Kara McElwrath
Date Nov 28, 2012
Time 10:00 am - 12:00 pm  
Location BRK 141B and Online
Sponsor Information Technology Services
Contact Kara McElwrath
Event type Workshop
Views 1549
Originating Calendar ITS Workshops

Access is a powerful tool, as a properly designed database provides you with access to up-to-date, accurate information. In this session, we will discuss the uses and benefits of Access, as well as scenarios for when to use Access and when to use Excel. We will also discuss design techniques that allow for databases that meet your needs and that can easily accommodate change. You will learn how to:

  • decide what information is needed
  • how to divide that information into the appropriate tables
  • how those tables relate to each other

In addition we will:

  • create reference tables to aid in data entry (allowing for data to be entered from a dropdown list)
  • set field properties, like default values, captions, input masks, and validation rules
  • work with the sort, filter, and find/replace features.

GoToMeeting link:  https://www1.gotomeeting.com/join/352476136