Access 2000

Target Student: This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.

Prerequisites: To ensure your success, we recommend you first take the following Solveway courses or have equivalent knowledge:
? Access 2002 Foundation
? Access 2002 Intermediate
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Lesson 1: Structuring Existing Data
Topic 1A: Use the Table Analyzer Wizard for Help
Topic 1B: Decide on Your Own Design
Topic 1C: Create a Junction Table
Topic 1D: Modify the Original Tables and Complete the Design
Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data
Topic 2A: Group and Summarize Records in Different Ways
Topic 2B: Summarize with a Crosstab Query
Topic 2C: Pivot Query Results
Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable
Topic 5A: Change the Display of Data Under Certain Conditions
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful
Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart
Topic 6C: Arrange Data in Columns
Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data
Topic 7A: Merge Access Data with a Word Document
Topic 7B: Publish Access Data as a Word Document
Topic 7C: Analyze Access Data in Excel