Microsoft Access 2016 Level 2 Training

access enter key and keys icon

The course builds on the introductory skills gained in Level 1 training.

Participants learn how to ensure data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

Glass Rock Solutions provides this training either as virtual (online) training or in-person (face-to-face).

At the completion of this course, you should be able to:

  • use various data validation features in Access to protect data
  • format the data in a table
  • perform more advanced queries using a variety of querying techniques
  • create and use parameter queries
  • create calculated queries
  • modify and adapt an existing form according to specific needs
  • create a navigation form for a database in Access 2016
  • create forms using a combination of wizards and manual techniques
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
  • create and manage custom categories and groups in the Navigation Pane

Upon completion of this course, participants are encouraged to undertake Microsoft Access training Level 3.

Book now


Please fill out the form below and someone from our team will be in touch within the next 48 hours to get your training started.

    GLASS ROCK CLIENT TESTIMONIALS

    “Fabulous, encouraging, challenging and honest. I am so please to have spent two days learning/ sharing with you. Thank you.”

    Sharon, CBA

    GLASS ROCK CLIENT STORIES

    Image

    Simone Heaperman - Landcom Program Manager

    When Simone Heaperman, the program manager, picked up the phone to speak with Preetie Shehkkar at Glass Rock Solutions, she had much to address and set right.

    Image

    Jane Hodgen - Tata Consultancy Services

    Tata Consultancy Services, a global technology leader with 450,000 employees worldwide, expect the best from anyone who works for them.

    Image

    Stuart Freer - University of New South Wales

    When Stuart Freer came to Australia, he was recruited as the Director, IT Service Delivery and Infrastructure, at the University of New South Wales.

    WE ARE HERE TO HELP
    CONTACT US TO FIND OUT HOW

      Glass Rock Consulting

      Melbourne Office
      Level 23, Collins Square Tower 5
      727 Collins Street,
      Melbourne Victoria 3008
      Sydney Office
      Australia Square, Level 33
      264 George Street,
      Sydney NSW 2000

      We acknowledge the First Australians as the traditional custodians of this continent. We pay our respect to the elders of the community, past, present and future.