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

Topics Covered

• Introducing databases
• Planning databases
• Starting Access
• Creating databases
• Hands-on: Creating a database
• Creating tables
• Hands-on: Creating a table
• Modifying a table
• Lookup and Input Mask Wizards
• Hands-on: Modifying Lookup fields
• reating forms and controls
• Hands-on: Adding controls
• Modifying controls and sections
• Hands-on: Formatting control properties
• Entering and changing records
• Working with records
• Hands-on: Entering and sorting records
• Creating and modifying queries
• Hands-on: Creating and specifying a query
• Printing records

Course Aim

To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of planning and creating a database, creating tables and forms, and entering and querying data

Learning Objectives

After taking this course, the student should be able to

• plan and create a database
  
  
• create and modify a table
  
  
• use Lookup and Input Mask Wizards
  
  
• create and modify forms and controls
  
  
• enter, change, and print records
  
  
• create and modify queries