Access 2003 - Advanced

Duration: 1 day
Cost: $90.00 per student

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Import Data
Topic 1B: Analyze Tables
Topic 1C: Open to Database Environment
Topic 1D: Improve Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create Unmatched and Duplicates Queries
Topic 2B: Group and Summarize Records Using the Criteria Field
Topic 2C: Summarize Data with a Crosstab Query
Topic 2D: Create a Pivot Table and a PivotChart
Topic 2E: 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 Using a Where Condition

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 Effective

Topic 5A: Change the Display of data Conditionally
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

Topic 6A:Cancel Printing of a Blank Report
Topic 6B: Include a Chart in a Report
Topic 6C: Arrange Data in Columns
Topic 6D: Create a Report Snapshot

Lesson 7: Maintaining an Access Database

Topic 7A: Link Tables to External Data Sources
Topic 7B: Back Up a Database
Topic 7C:Compact and Repair a Database
Topic 7D: Protect a Database with a Password
Topic 7E:Determine Object Dependency
Topic 7F: Document a Database
Topic 7G: Analyze the Performance of a Database