Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - MS Access - Advanced


distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services


MS Access - Advanced

FEE: $490

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Business Professional
  • Support Personnel


    1. Queries
      • Coding a parameter query is similar to the select query; the difference is that the select query is static and the parameter query prompts the user for selection criteria before running.
      • Code and test a AutoLookup queries.
      • Enter one value into a query; based on a related table, the query fills in the remaining values in the table datasheet.
    2. Form Design
      • Use the wizard to generate and design a form.
      • Modify the generated form.
    3. Subforms
      • Create a form and subform at the same time.
      • Create a subform and add it to another form.
      • Create a form with two subforms.
      • Create a form with nested subforms.
    4. Indexes
      • Test the performance benefits of using an index.
      • Create and use a unique index.
    5. Macros
      • Use the Macro Builder to create a macro.
      • Create a stand-alone macro.
    6. Macros: Adding Functionality
      • Create an embedded macro.
      • Specify conditions to control a macro.
    7. Group Macro: Creation
      • Create a macro group with several related macros.
    8. Switchboards
      • Create a switchboard.
      • Add and delete items to a switchboard.
      • Edit items in a switchboard.
      • Display the main switchboard on startup. n~Report Design.
      • Use control layouts to align data.
      • Add and remove report page header and footer sections.
      • Alternating line colors on the report.
      • Conditional formatting of the report.
    9. Grouping Data in a Report
      • Create a report that allows data to be grouped on a column using the Report Wizard.
      • Create a report that allows data to be grouped on non-standard numeric ranges.
    10. Running Summary: Creation
      • Use a DSum function and criteria in a query to create a running sum.
      • Use a totals query with a DSum() function to create a running total over a group.
    11. Date/Time Control: Inserting
      • Place the DateTime picker control on the form; then specify whether the user is to select a date or time.
      • Bind the form to a Date/Time field and the format for the date or time.

    Web-based Training   Blended Learning    


Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.