Access Tables and Relationships 2007

Day	Date	Time	Location	Instructor		For U-M	Others
Tue	9/22/09	9:00AM–12:00PM	Arbor Lakes Bldg 1, Rm 1900	Newman		$105	$135	Closed
Thu	11/19/09	9:00AM–12:00PM	Rm 2074 CSSB	Newman		$105	$135	Closed
Thu	1/14/10	9:00AM–12:00PM	Arbor Lakes Bldg 1, Rm 1900	Newman		$105	$135	Register
Mon	3/8/10	9:00AM–12:00PM	Rm 2074 CSSB	Newman		$105	$135	Register
Thu	4/15/10	9:00AM–12:00PM	Rm 2074 CSSB	Newman		$105	$135	Register

Category

Database Management

Workshop Description

This hands-on workshop walks you through importing data from Excel and text files. It also discusses many of the field properties within tables, including how to make data entry required, have a default value that is auto-entered into new records, make pop-up fields for consistent and efficient data entry, validation rules and text, input masks and other methods for guiding data entry and increasing the likelihood of good reports. We talk about joins and relationships between tables.

Prerequisite(s)

Access Introduction 2007 or equivalent knowledge.