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 3 Workshop Lessons and Topics
Prerequisites: Taken Access 2003 Advanced 1 & 2 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 (XP) Advanced".


 Lesson 10 - Using Macros
    Using Properties
    Assigning a Macro to a Control
    Creating a Command Button
    Adding a Condition to a Macro
    Creating a Group Macro
    Creating an Autoexec Macro

 Lesson 11 - Using Switchboards
    Opening and Using a Switchboard
    Creating a Switchboard Form
    Adding a Command Button to a Switchboard
    Setting Startup Options

 Lesson 12 - Creating Custom Toolbars
    Creating a Custom Toolbar
    Adding a Built-in Menu Item
    Creating a Custom Menu Item
    Adding a Command to a Menu Item
    Adding Custom Commands 

Workshop Information Page

 Lesson 12 - Creating Custom Toolbars - (Cont.)
    Docking a Floating Toolbar
    Linking a Toolbar to a Report
    Adding a Separator Bar
    Creating a Shortcut Menu
    Linking a Custom Shortcut Menu
    Adding Buttons to a Custom Toolbar
    Changing a Button Image
    Deleting a Custom Toolbar

 Lesson 13 - Exporting Data to Excel and Word
    Exporting Data to an Excel Workbook
    Dragging and Dropping Data into Excel
    Creating Excel Workbooks - Office Links
    Creating Word Documents - Office Links

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