Microsoft Access 2002 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2002 Level 1 or equivalent experience |
| Course Materials: | Course manual (074401S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will learn intermediate Access 2002 skills, including creating more complex queries, customizing your forms and reports, and broadening the availability of your data. |
Managing a Database and Data
Import Data
Maintain Record Integrity
Exporting Data
Documenting Table Relationships
Controlling Data Entry
Make Data Entry More Accurate
Make Data Entry More Efficient
Facilitate Data Entry
Finding and Joining Data
Find Data with Filters
Get the Correct Data with Query Joins
Building Bridges Between the Data
Relating Data within a Table
Creating Flexible Queries
Summarizing Data with Queries
Enter Criteria on the Fly
Maintain Data with Queries
Improving Your Forms
Enhance the Appearance of a Form
Enhance the Usability of a Form
Make Your Forms More Professional
Display Form Data from Multiple Tables
Customizing Your Reports
Organize Report Information
Enhancing Data Layout
Working with Report Pagination
Summarizing Information
Add a Subreport to an Existing Report
Creating Mailing Labels
Making Your Data Available on the Web
Create a Data Access Page
Improving the Look of a Data Access Page
Editing Data Using a Data Access Page
Group Records in a Data Access Page