Course Outline
Access - Intermediate Part II
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 create more complex forms and subforms, how to create and use macros, and how to create more complex reports.

• Database Management Applications
• Forms
  • Reviewing Customer Purchase Query
  • Designing the Subform
  • Adding the Subform to the Main Form
  • Adding a Button
  • Changing the Properties
  • Modifying the Data Entry Properties
  • Adding a "Title" Field
  • Changing the Tab Order
  • "Purchase" Form
  • Adding a Combo Box
  • Adding a Text Box
  • Adding an Option Group
  • Looking at a Completed Form

   

• Introducing Macro Actions
• Setting a Prompt in Parameter Queries
• OLE Data Types
• Inserting an OLE Object
• Form Design Tips
• Properties
• Format Paintbrush Feature Reports
  • Creating the Report
  • Reviewing Report Components
  • Modifying a Header/Footer
  • Adding a Field
  • Attaching the Correct Macros
  • Calculated Fields
• Reviewing the Macros
• Customer Dialog Forms
  • Assigning the Macros
  • Entering Criteria
  • Underlying Query