Microsoft Access 2002 Training Course


(Advanced)
Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Training Course Outline

  • Structuring Existing Data
    • Use the Table Analyzer Wizard for Help
    • Decide on Your Own Design
    • Create a Junction Table
    • Modify the Original Tables and Complete the Design
    • Compact and Repair a Database
  • Summarizing Data
    • Group and Summarize Records in Different Ways
    • Summarize with a Crosstab Query
    • Pivot Query Results
    • Display 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
    • Display 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
    • Include a Chart
    • Arrange Data in Columns
    • Distribute Reports as a Snapshot
  • Expanding the Reach of Your Data
    • Merge Access Data with a Word Document
    • Publish Access Data as a Word Document
    • Analyze Access Data in Excel
Course Duration: 1 Day

To see more details as to our East Anglian Training Venues click one of the links below:

Cambridge | Milton Keynes | Norwich | Peterborough | Luton | Ipswich