Microsoft Access 2002 Advanced

Short course

In

Price on request

Description

  • Type

    Short course

  • Methodology

    Inhouse

  • Duration

    1 Day

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access

Course programme

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.Microsoft Access 2002 Training Course (Advanced) 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

Microsoft Access 2002 Advanced

Price on request