Home > Courses Certifications > Microsoft Office > Access 2002 Level 2 synopsis

Microsoft Access 2002 Level 2

Access 2002 Level 1

Access 2002 Level 3

Prerequisites: Students must have completed Access 2002 Level 1 or have equivalent knowledge.

Duration: 2 days

 

Lesson 1: Structuring Existing Data

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

Lesson 2: Summarizing Data

• Group and Summarize Records in Different Ways
• Summarize with a Crosstab Query
• Pivot Query Results
• 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

Lesson 4: Adding Interaction and Automation with Macros

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

Lesson 5: Making Forms More Usable

• Change the Display of Data Under Certain Conditions
• Display a Calendar on a Form
• Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

• Cancel Printing of a Blank Report
• Include a Chart
• Arrange Data in Columns
• Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

• Merge Access Data with a Word Document
• Publish Access Data as a Word Document
• Analyse Access Data in Excel