New Horizons Computer Learning Center
410-597-9722

Access 2003 - Level 2

Course Length: 2 Days

Overview:
In this course, students will extend their knowledge into some of the more specialized and advanced capabilities of Access 2003.

Prerequisites:
Access 2003 - Level 1

Course Objectives:
Upon successful completion of this course, students will be able to:

• Restructure an existing set of data to improve the design of a database
• Use a variety of techniques to summarize and present data with queries
• Create and revise basic Access macros
• Create macros that improve data entry efficiency and integrity
• Improve the effectiveness of data entry in forms
• Improve the effectiveness of data displayed in reports
• Maintain an Access database by using various utility tools

Course Content

• Import Data
• Analyze Tables
• Create a Junction Table
• Improve Table Structure

Lesson 2: Writing Advanced Queries

• Create Unmatched and Duplicates Queries
• Group and Summarize Records Using the Criteria Field
• Summarize Data with a Crosstab Query
• Create a PivotTable and a PivotChart
• Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

• Create a Macro
• Attach a Macro to a Command Button
• Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

• Set Tabs
• Require Data Entry with a Macro
• Display a Message Box with a Macro
• Automate Data Entry

Lesson 5: Making Forms More Effective

• Change the Display of Data Conditionally
• Display a Calendar on a Form
• Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

• Cancel Printing of a Blank Report
• Include a Chart in a Report
• Arrange Data in Columns
• Create a Report Snapshot

Lesson 7: Maintaining an Access Database

• Link Tables to External Data Sources
• Back Up a Database
• Compact and Repair a Database
• Protect a Database with a Password
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com