Skip Navigation
  Tops, Training in Office and Productivity Skills George Mason Logo
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only   image for the corner of the table. Layout image only
image for the corner of the table. Layout image only

Access 2003 Advanced - Part 1 Workshop Lessons and Topics
Prerequisites: Taken Access 2003 Intermediate 1, 2, & 3 workshops or have the following skills: be able to design and modify tables, work with primary keys; create and modify relationships between tables using referential integrity; create a basic form using the Form Wizard; and create a basic report using the Report Wizard.

  The manual used for this workshop is "Access 2003 Advanced".

 Lesson 1 - Using Charts
    Creating a Chart
    Adding a Chart to a Form or Report
    Activating Microsoft Graph to Edit
    Changing the Chart Type
    Changing the Chart Title
    Formatting the Chart Title
    Adding Data Labels to a Chart  

Lesson 2 - Using Subforms/Subreports
    Working with Subforms/Subreports
    Creating a Subform/Subreport
    Editing the Layout of a Subform
    Displaying a Subform in Datasheet View
    Displaying a Subform Total

Workshop Information Page
 Lesson 3 - Using Other Form Techniques
    Adding a Command Button
    Saving a Form as a Report
    Creating a PivotTable or PivotChart View
 
Lesson 4 - Using ActiveX Controls
    Working with ActiveX Controls
    Registering an ActiveX Control
    Adding an ActiveX Control
    Attaching an ActiveX Control
image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
image for the corner of the table. Layout image only  
image for the corner of the table. Layout image only
image for the corner of the table. Layout image only image for the corner of the table. Layout image only

Voice (703) 993-3426 | Fax (703) 993-4747 | Johnson Center 311 | 4400 University Drive, MS 5C4 | Fairfax, VA 22030