IUPUI

This workshop lasts 3.5 hours, and is part of the certificate series Access 2010 End-User In this hands-on lab session, you will integrate and reinforce the skills you learned in Access 2010: The Basics, Access 2010: Database Relationships, Access 2010: Queries, Access 2010: Forms and Access 2010: 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. You can only register for this workshop as part of the Access 2010 End-User Certificate Series.   What You'll learn

• 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

What you need to know

• 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

If you don't have those skills, consider first taking the workshop:

• Access 2010: Database Relationships

• Access 2010: Forms

• Access 2010: Queries

• Access 2010: Reports

• Access 2010: The Basics