logo
MICROSOFT IT ACADEMY AT WSU

Access 2010 - Interactive Guides

Make the switch to Access 2010

If you're an experienced Access user, this course is for you. This course explains how to switch to Access 2010 from a previous version. You'll learn how to perform familiar tasks in Access 2010, such as using existing databases, creating new databases, building tables, and creating or editing forms and reports.

Level: Intermediate
Length: 35-40 minutes

Design the tables for a new database

Learn how to use Access 2010 by designing and creating a database. You'll start by learning how to design the tables and relationships for a new database. A good design ensures your database captures all your data accurately. This is the first course in a series that teaches beginners how to use Access 2010.

Level: Beginner
Length: 30-40 minutes

Create tables for a new database

Learn how to build the tables for a new database. Tables are the essential component of any database. Without them, you don’t have a database. If you're feeling intimidated, relax. We assume you're a beginner, and we’ll show you how to create tables step by step. Just make sure you've taken the first course in this series, or that you're familiar with basic database concepts such as fields and primary keys.

Level: Beginner
Length: 35-40 minutes

Create relationships for a new database

Learn how to create table relationships for a new Access 2010 database. Relationships are essential because they bring the data in your tables together so you can extract meaningful information. This course explains the different types of relationships and shows you how to create them. This is the third course in a series that teaches beginners how to use Access 2010.

Level: Beginner
Length: 35-45 minutes

Create queries for a new database

Learn how to create queries for an Access database. Queries are an essential part of any database. They’re how you answer extract meaningful information from your database and answer key business questions. This is the fourth course in a series that teaches beginners how to use Access 2010.

Level: Intermediate
Length: 30-40 minutes

Create forms for a new database

Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately. This is the fifth course in a series that teaches beginners how to use Access 2010.

Level: Intermediate
Length: 35-45 minutes

Create reports for a new database

Learn how to create reports. Reports present information visually, help others understand your data, and answer critical business questions. This is the sixth and final course in a series that teaches beginners how to use Access 2010.

Level: Intermediate
Length: 40-50 minutes

Build and publish web databases

This course explains how to create and publish an Access 2010 web database that runs on SharePoint 2010. You’ll also learn how to save a changed web database to SharePoint, and how to create a web database from scratch using a blank template.

Level: Intermediate
Length: 40-50 minutes

Add the web to your databases

Learn how to use the Web Browser control to display web pages in an Access 2010 database. This course explains how to use addresses in a database to display online maps and driving directions in an Access 2010 form.

Level: Intermediate
Length: 30-40 minutes