Access 2003: Advanced

« back to previous page

Description:	The student will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and maintain an Access database by using various utility tools.
Prerequisites:	Intermediate Access or equivalent experience
Length:	One day

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

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

Simplifying Tasks with Macros
• Create a Macro
• Attach a Macro to a Command Button
• Restrict Records Using a Where Condition

Adding Interaction and Automation with Macros
• Require Data Entry with a Macro
• Displaying a Message Box with a Macro
• Automate Data Entry

Making Forms More Effective
• 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
• Including a Chart in a Report
• Arranging Data in Columns
• Create a Report Snapshot

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