Course Outline
Access - Intermediate Part I
Versions 97/2000/2002(XP)/2003/2007

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn how to structure relationships, use more complex query techniques, and create efficient forms.

• Database Management Applications
• Compacting a Database
• Making a Backup Copy of an Object
• Renaming a Table
• Field Properties
  • Field Size / Format
  • Input Masks
  • Caption
  • Decimal Places
  • Default Value
  • Validation Rule and Validation Text Required
  • Allow Zero Length
  • Indexed
  • Lookup Tab
• Queries
  • Creating
  • Query Wizards
  • Comparison Operators
  • Changing the Order of Fields
  • Saving the Query
  • Zoom View
  • Finding Blank Records
  • Opening an Object in Design View
  • Removing Fields
  • Calculating
  • "And," "Or" & "Between"

• Queries (continued)
  • Renaming an Expr1 Field
  • Changing Properties of a Field
• Creating Mailing Labels
• Using Relational Databases
• Designing Relational Databases
• Setting & Removing the Primary Key
• Creating Multiple Primary Key Fields
• Relating Tables
  • One-To-Many Relationships
  • Many-To-Many Relationships
  • One-To-One Relationships
• Normalizing Tables
• Referential Integrity
• Specifying Relationships
• Editing Relationships
• Querying Multiple Tables
• Joining Two Fields (Concatenation)
• Types of Joins
• Viewing or Changing Joins
• Totals in Queries
• Forms
  • Designing
  • Changing Paper Size / Margins
  • Working with Design Tools
  • Controls
  • Adding Labels / Adding Color
  • Saving and Printing
• Exiting Access