Databases are ideal tools for tracking large volumes of data, and Microsoft Access is a popular and powerful tool used to design and develop Windows-based databases. This series, which is intended for new Access users, introduces the most important features in Access which end-users need to know to work with Access databases.

Earn the certificate

1. Sign up for the certificate (below) to indicate that you are interested in earning this certificate.
2. Register for and attend each workshop in the series within one year. Receive a 10% discount if you register for all the workshops at one time. Workshops and schedules are listed below. Or, read about workshop charges and policies.
3. You can keep track of your progress in your customer profile.
4. The IT Training & Education office will contact you when you have completed the certificate.

Workshops in this series

Access: The Basics

Access is Microsoft’s premier desktop database application, and as such it is ideal for tracking small to medium sized data sets. In this workshop, you will learn basic database terminology, create tables and queries, enter and edit data, and import data from an Excel spreadsheet. Forms and reports will also be introduced.

Access: Database Relationships

The ability to create relationships between different data sets is critical to designing and working with sophisticated databases. In this workshop, you will explore and define relationships in Access and build relational queries and forms with lookup fields.

Access: Queries

Queries enable you to analyze and manipulate data. In this workshop, you will build many different types of queries and explore advanced query functions such as aggregate totals and calculated expressions.

Access: Forms

<p>Forms are most commonly used to ease data entry and editing tasks. In this workshop, you will create and edit relational forms and subforms, add drop-down lists and command buttons, create calculated fields, and create a switchboard.</p>

Access: Reports

<p>This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will select sorting and grouping options, create mailing labels, and create a mail-merge report.</p>

Access Project Lab

This practice lab will give you the opportunity to use Access to solve challenging problems in a supportive environment by allowing you to explore and reinforce skills that you learned in previous Access workshops.

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

Register for workshops in this series

• Schedules for individual workshops are listed below.
• Receive a 10% discount when you register for all the workshops in this series (requires login) at one time. Or, read about workshop charges and policies.
• If you have already attended one or more of these workshops, your attendance will automatically be applied toward your certificate.
• To earn the Certificate, you must attend all workshops in a series within one year period.

Campus: IUB | IUPUI | All

Access Project Lab

Bloomington (IUB)

Fri 4/16/2010 • 1:30 AM - 5:00 AM IUB Library Information Commons (IC103) STEPS Classroom You can register for project labs by registering for all workshops in the series at one time or by contacting our office.

Indianapolis (IUPUI)

	Tue 12/1/2009 • 9:00 AM - 12:30 PM IUPUI ICTC IT127 You can register for project labs by registering for all workshops in the series at one time or by contacting our office.
	Thu 4/22/2010 • 1:30 PM - 5:00 PM IUPUI ICTC IT127 You can register for project labs by registering for all workshops in the series at one time or by contacting our office.