General Information

Course Duration
4 hours

Audience
Anyone wishing to become familiar with Microsoft Access 2000; students wishing to become MOUS certified at Microsoft Access 2000 at the Core level

Prerequisites
Basic familiarity with the Windows 95/98 or NT 4.0/2000 user environments and completion of Microsoft Office 2000: Beginning Access

Topics Covered

• Creating a report
• Hands-on: Adding controls to a report
• Modifying controls and sections
• Hands-on: Modifying format properties
• Hands-on: Using a calculated control
• Navigating and printing
• Creating and modifying reports
• Hands-on: Using Design view
• Control and section properties
• Hands-on: Modifying properties
• Subreports
• Hands-on: Using the subreport control
• Filters in a query
• Hands-on: Applying filters in a query
• Totals and parameter queries
• Modifying query properties
• Action queries and SQL statements
• Specifying join properties
• Optimizing queries
• Importing and exporting data
• Hands-on: Importing data
• Hands-on: Exporting to Excel
• Charts and linking data
• Hands-on: Using charts
• Database utilities
• Saving databases

Course Aim

To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of creating and enhancing a report, working with queries, and integrating data

Learning Objectives

After taking this course, the student should be able to

• create and modify a report
  
  
• add and modify controls and sections
  
  
• use filters in a query
  
  
• use total and parameter queries
  
  
• modify and optimize queries
  
  
• integrate, chart, and link data