Intermediate Microsoft Access

Instructor:   Paul N. Lee, [Owner/Consultant of Nahee Enterprises]

This course assumes you have taken the previous introductory Fundamentals class, or that you have equivalent knowledge of Access from other classes and/or personal experience.   This Intermediate Access workshop will continue where the Fundamentals left off.   We will review table design and setting relationships.   Learn more about indexes, joins, setting up calculations, import data from text files and other Access files.   Referential integrity and forms with drop down boxes for data input will be used.   Event handling on a form will be discussed.   Besides the class handouts, a CD is supplied with over 1,625 files of examples, templates, add-ins, training, help files, 458 actual databases, and 300+ tips/tricks (a total of over 540-MB of information).

The following is the outline used for this class:

  1. Brief Overview
    1. (see "Microsoft Access Fundamentals" outline)
    2. Objects of an Access Database.
    3. Normalizing a Database with Existing Data.

  2. Tables and Queries.
    1. Importing and Linking Data.
      1. Import.
      2. Link.
    2. Cleaning Up and Breaking Down.
    3. Joining Tables.

  3. Forms.
    1. Building the basic Form.
    2. Creating and adding Sub-Forms.
    3. Adding functionality to a form.
    4. Creating simple statistical data.
      1. List Boxes.
      2. Charts.

  4. Reports.
    1. Creating Mailing Labels.
    2. Sub-Reports.
      1. Create a subreport in an existing report.
      2. Add an existing report to another report as a subreport.

  5. Modules.
    1. Events and Procedures.
      1. Order of events for controls on forms.
        1. Moving the focus to a control.
        2. Changing and updating data in a control.
      2. Order of events for records on forms.
        1. Moving the focus to records and updating data in records.
        2. Deleting records.
        3. Creating a new record.
      3. Order of events for forms and subforms.
        1. Opening and closing a form.
        2. Moving between forms.
        3. Working with data on a form.
        4. Working with subforms.
      4. Order of events for keystrokes and mouse clicks.
        1. Keyboard events.
        2. Mouse events.
      5. Order of events for reports and report sections.
        1. Events for reports.
        2. Events for report sections.

  6. Reference Tables.
    1. Microsoft Access Specifications.
      1. Access database or project.
      2. Table.
      3. Query.
      4. Form and Report.
      5. Macro.
    2. DataType Property.
    3. FieldSize Property
    4. Format Property
      1. Date/Time.
        1. Predefined Formats.
        2. Custom Formats.
      2. Number and Currency.
        1. Predefined Formats.
        2. Custom Formats.
      3. Text and Memo.
      4. Yes/No.
        1. Predefined Formats.
        2. Custom Formats.
    5. Wildcard Search Criteria.
    6. Startup command-line options.