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 Intermediate - Part 3 Workshop Lessons and Topics
Prerequisites: Taken Access 2003 Intermediate - Part 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 Intermediate".

 Lesson 9 - Using Design View
    Hiding the Ruler
    Disabling the Snap to Grid Feature
    Displaying the Field List
    Adding a Field
    Moving Part of a Paired Control
    Aligning Controls
    Spacing Controls
    Using the Toolbox
    Adding a Label
    Adding an Image
    Adding a Rectangle
    Adding a Line
    Editing an Unbound Control
    Using Multiple Undo/Redo in Design View

 Lesson 10 - Using Advanced Form Design
    Using the Forms in Design View
    Creating a Combo Box
    Creating a List Box
    Creating an Option Group
    Adding a Logic Control
    Setting the Tab Order Automatically
    Setting the Tab Order Manually
    Adding a Form Header and Footer
    Creating a Blank Form

Workshop Information Page

 Lesson 11 - Using Advanced Report Design
    Adding Report Sections in Design View
    Creating a Caluclated Control
    Grouping Data in a Report
    Creating Group Headers and Footers
    Creating a Running Summary
    Inserting a Date/Time Control
    Inserting a Page Break
    Changing the Report Margins
    Using the Label Wizard
    Creating a Report without Using a Wizard

 Lesson 12 - Using Editing Tools
    Selecting Objects with the Toolbar
    Changing the Font
    Changing the Font Size
    Changing the Character Format
    Changing the Font Color
    Changing Fill and Background Colors
    Formatting Lines and Borders
    Applying Special Effects
    Using the Format Painter
    Using AutoFormat
    Running the Spelling Checker
    Setting AutoCorrect Options
    Adding AutoCorrect Entries
   

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