Access 2002 Advanced

Course Description
Course Outline

Course Overview

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.

Prerequisites

Access 2002 Introduction and Access 2002 Intermediate, or equivalent knowledge.

Benefits

Students will learn advanced Access 2002 skills, including how to structure existing data, summarize data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.

Target student

Anyone who uses Access 2002 as a tool for getting their work done. Job responsibilities might include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced capabilities, and using Access tools, as well as supporting less-advanced Access users.

What's next

Access 2002 VBA Programming, the next course in this series, teaches students how to develop custom applications using Access.

We offer a range of Access training courses

Structuring Existing Data
Use the Table Analyzer Wizard for Help Decide on Your Own Design Create a Junction Table Modify the Original Tables and Completing the Design Compact and Repair a Database
Summarizing Data
Group and Summarize Records in Different Ways Summarize with a Crosstab Query Pivot Query Results Display a Graphical Summary on a Form
Simplifying Tasks with Macros
Create a Macro Attach a Macro to a Command Button Restrict Records
Adding Interaction and Automation with Macros
Require Data Entry with a Macro Display a Message Box with a Macro Automate Data Entry
Making Forms More Usable
Change the Display of Data Under Certain Conditions Display a Calendar on a Form Organize Information with Tab Pages
Making Reports More Powerful
Cancel Printing of a Blank Report Include a Chart Arrange Data in Columns Distribute Reports as a Snapshot
Expanding the Reach of Your Data
Merge Access Data with a Word Document Publish Access Data as a Word Document Analyze Access Data in Excel
Accessing Object Names

Publisher:	Microsoft
Version:	2002 (XP)
Length:	1 day
Course-ID:	084402

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The course trainer was excellent. She spent time with individuals, explaining any problems experienced

- Siemens