Skip to main content
UIS Cover Photo
Back to Listing

[ITS Workshop] Introduction to Microsoft Access

Event Type
Information Technology Services
BRK 141B and Online
Nov 28, 2012   10:00 am - 12:00 pm  
Kara McElwrath
Kara McElwrath
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:

link for robots only