Access 2002: 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 use Access data in other Office applications.
Prerequisites:	Intermediate Access 2002 or equivalent experience
Length:	One day

Structuring Existing Data
• Use the Table Analyzer Wizard for Help
• Decide on Your Own Design
• Create a Junction Table
• Modifying the Original Tables and Completing the Design
• Compact and Repair a Database

Summarizing Data
• Group and Summarize Records in Different Ways
• Summarize with a Crosstab Query
• Pivot Query Results
• Displaying a Graphical Summary on a Form

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

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 Usable
• Change the Display of Data Under Certain Conditions
• Display a Calendar on a Form
• Organize Information with Tab Pages

Making Reports More Powerful
• Cancel Printing of a Blank Report
• Including a Chart
• Arranging Data in Columns
• Distributing Reports as a Snapshot

Expanding the Reach of Your Data
• Merge Access Data with a Word Document
• Publishing Access Data as a Word Document
• Analyze Access Data in Excel

Access Object Names

Summary and Review