In this hands-on lab session, you will integrate and reinforce the skills you learned in Access: The Basics, Access: Database Relationships, Access: Queries, Access: Forms and Access: Reports to independently create relationships, queries, forms, and reports from an existing database. You will be given guidelines to accomplish specified tasks within the database.

Note: You can only register for this workshop as part of the Access 2007 End-User Certificate Series.

(Description continued below)

Campus: IUB | IUPUI | All

Upcoming schedule

Bloomington (IUB)

Fri 4/16/2010 • 1:30 AM - 5:00 AM IUB Library Information Commons (IC103) STEPS Classroom

Indianapolis (IUPUI)

	Tue 12/1/2009 • 9:00 AM - 12:30 PM IUPUI ICTC IT127
	Thu 4/22/2010 • 1:30 PM - 5:00 PM IUPUI ICTC IT127

View workshop charges and policies

Can’t make it to the workshop?

• Order STEPS materials to learn on your own
• Download the exercise files for this workshop

Participants will:

• define relationships between tables and create lookup fields
• reinforce concepts and skills learned in prerequisite workshops by using an explorative approach to create relational queries, forms, and reports
• incorporate data from an Excel source
• prepare mailing labels
• generate a mail-merge report in Access

The following workshops are suggested prerequisites to this workshop:

• Access: Database Relationships
• Access: Forms
• Access: Queries
• Access: Reports
• Access: The Basics

Participants should already be able to:

• create tables and define relationships between tables
• create lookup fields
• create relational queries, forms, and reports
• enter, edit, and delete data using tables, queries, and forms
• import data into Access tables from external sources