Microsoft Access 2002 Training Course

Training Course Outline

• Working with a Relational Database
  • Identify Uses of a Relational Database
  • Define Database Terminology
  • Create a New Database Based on a Template
  • Examine the New Database
• Planning a Database
  • Identify Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize the Data
  • Designate Primary and Foreign Keys
  • Identify Table Relationships
• Building the Basic Structure
  • Create a Blank Database
  • Create a Table using a Wizard
  • Compare Datasheet and Design Views
  • Create Tables in Design View
  • Create Relationships between Tables
• Working with Tables
  • Modify a Table Design
  • Work in Datasheet View
  • Work with Subdatasheets
• Creating and Working with Select Queries
  • Examine a Query
  • Create a Query Using a Wizard
  • Work in Query Design View
  • Select Records
  • Edit Values in a Query Datasheet
  • Add a Calculated Field to a Query
  • Perform a Calculation for a Group of Records
• Creating and Using Forms
  • Create AutoForms
  • Create a Form Using a Wizard
  • Modify the Design of the Form
  • Use Forms to Work with Data
• Creating and Using Reports
  • Create an AutoReport
  • Create a Report Using a Wizard
  • Examine a Report in Design View
  • Create a Calculated Field
  • Change the Format of a Control
  • Change the Style of a Report
  • Adjust Report Width

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

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