HBI College Course Outline - Access 2003

Microsoft Access 2003 - Level 3

COURSE DESCRIPTION

Extend your knowledge into some of the more specialized and advanced capabilities of Access. Learn techniques to structure existing data, write advanced queries, simplify tasks, add interaction and automation with macros, make forms and reports more effective, and maintain an Access database.

PREREQUISITES

Microsoft Access 2003 - Level 1

CORE TOPICS
Structuring Existing Data		Adding Interaction & Automation with Macros
Import data Analyze tables Create a junction table Improve table structure		Require data entry with a macro Displaying a message box with a macro Automate data entry
Writing Advanced Queries		Maintaining an Access Database
Create unmatched and duplicate 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		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
Simplifying Tasks with Macros		Making Forms more Effective
Create a macro Attach a macro to a command button Restrict records using a Where Condition		Change the display of data conditionally Display a calendar on a form Organize information with tab pages
Making Reports More Effective
Cancel printing of a blank report Include a chart in a report Arrange data in columns Create a report snapshot

Your partner in customized corporate education.

Call 905 949 9900 Extension 2474
to talk about your training needs,
or email
corporatetraining@hbicollege.com