Getting Started To begin, participants will learn the basics of Access: how to open and close it, how to use the Getting Started Window, how to set Trust Center options, and how to get help.

The New Interface Next, participants will closely examine the new interface, including the Quick Access Toolbar and each of the default tabs.

Creating a Database First, we will discuss some things to consider when planning your database. Then, we will begin to create a database (using blank databases and templates) by adding tables and records.

Doing More with your Database Next, participants will look at the basics of forms, queries, and reports, including how to sort and filter data, ways to view data, and how to print database objects.

Advanced File Tasks Participants will learn various file management tasks in this section, including how to use My Computer within Access and various ways to save and export their database. Participants will also learn how to link files, compact and repair a database, and back up a database.

Working with Tables This section will focus on Access' tables, including how to customize and format them and how to control and manage data entry.

Working with Forms Next, we will examine forms, including adding all types of controls, formatting the form and its controls, and formatting records.

Working with Reports This section will discuss reports, including ways to organize report data, formatting tools, and common tasks (such as adding a logo and page numbers).

Working with Queries This section will focus on creating and managing queries. Types of queries covered include basic, multiple table, make table, summary, parameter, crosstab, append, delete, and update.

Advanced Data Management Participants will learn how to establish referential integrity, how to manage table relationships, how to create and use switchboards, and how to create modal dialog boxes.

Advanced Form Tasks This section will examine subforms, limiting user access, customizing error messages, creating event procedures, and exporting the form. Participants will also learn how to create an RSS feed for Outlook, how to import Outlook contacts, and how to use SharePoint Server and other servers with Access.

Pivoting Data Participants will learn all about PivotTables and PivotCharts in this section.

Access and Windows Participants will learn how to use Office diagnostics and the Access Viewer. Participants will also receive an introduction to SQL.

Add-ons to Access This section will examine COM Add-Ins, Digital Signatures, Smart Tags, and Access options. Participants will also learn how to analyze performance, view object dependencies, replicate a database, and split a database.

Using Scripts in Access Participants will learn how to create and use macros and macro groups in this section.

Using Access to Collaborate This section will cover using SharePoint Server and Access.

SQL and Microsoft Access To complete the course, participants will learn about SQL, including basic SQL conventions and how to use the SELECT statement, subqueries, and SQL joins.