The Knowledge Network
1510 Central Avenue
Albany, NY 12205
Phone (518)452-2675
Fax: (518)452-2872
Office Hours:
Mon-Fri 9:00am-6:00pm
learn@knowledgenetwork.org

Microsoft^© Access 2003 - Level 2

Location: Colonie

• Structuring Existing Data
  • Import Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure
     
• Writing Advanced Queries
  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query 
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form
     
• Simplifying Tasks with Macros
  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition
     
• 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 Effective
  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages
     
• Making Reports More Effective
  • Cancel Printing of a Blank Report
  • Include a Chart in a Report
  • Arrange Data in Columns
  • Create a Report Snapshot
     
• Maintaining an Access Database
  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database