Advanced
Microsoft Access 2007

Course Content

• Lesson 1: Structuring Existing Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure
• Lesson 2: Writing Advanced Queries
  • Create Subqueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
• Lesson 3: Simplifying Tasks with Macros
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
• Lesson 4: Making Effective Use of Forms
  • Display a Calendar on a Form
  • Organize Information with Tab Pages
  • Display a Summary of Data in a Form
• Lesson 5: Making Reports More Effective
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Create a Report Snapshot
• Lesson 6: Maintaining an Access Database
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

---

All Access Courses

Access 2010 Classes	Access 2007 Classes	Access 2003 Classes
What's New in Access 2010 > Introduction > Intermediate > Advanced >	What's New in Access 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Access >

---