Microsoft Access
Level 3


Participants will learn how to use parameter and action queries, use macros to automate and streamline an Access database and use Access in conjunction with the Internet and other windows based applications.


Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1 and 2, or equivalent knowledge

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          Designing parameter and action queries
          Creating parameter queries
          Creating action queries

          Outer join and crosstab query techniques

          Joining tables and working with join properties
          Crosstab queries
          Editing limitations in query datasheets

          Form design enhancements

          Building a form based on joined tables; using functions in forms
          Using option groups and additional form design enhancements

          Using command buttons and macros with forms

          Creating macros and command buttons
          Using macros to control form properties
          Using macros to provide user interaction and automate tasks
          Using macros to provide user interaction
          Using macros to automate tasks

          Advanced report techniques

          Hiding duplicate data, grouping data, and using functions in reports

          Introduction to the Internet

          Using hyperlinks


          Replicating databases
          Using Access with other applications

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2021