IUPUI

This workshop lasts 3 hours, and is part of the following certificates series: Office 2010 Productivity  Access 2010 End-User

Access databases are ideal tools for tracking large volumes of related information and is the most commonly used desktop database application in use today. Intended for people with little or no experience using Access, this workshop introduces database terminology and relationships concepts. Participants will create Access objects such as tables and queries as well as simple forms and reports.

What You'll learn

Available Downloads

• create a new database

• create, design, and modify tables to hold data

• enter, edit, and delete data

• import data from an Excel spreadsheet

• create select queries

• import a table from an external Access database

• define relationships between tables

• create a relational form and report

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• use a mouse

• save and organize files

• use command menus

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

• Windows: Basic Computing Skills