This program covers the more advanced features of select queries and introduces action queries in Microsoft Access.

Overview

This program covers the more advanced features of select queries and introduces action queries in Microsoft Access.

Program Content

  • Create action queries to update, append and delete records
  • Use N2(), IIF() and StrConv() functions
  • Create crosstab and parameter queries.

Learning Outcomes

Participants should be able to:

  • Use advanced functions in select queries
  • Use crosstab queries for summary views
  • Use action queries to update and delete records.
Program code 997
Skill Level Advanced
Duration Half day
Time 9.00 AM - 12.30 PM
Dates
  • 29 November, 2018
  • 15 April, 2019
  • 30 August, 2019
  • 29 November, 2019
Location AIM WA Floreat
* Minimum numbers are required for program to proceed
Calculate your ROI

Estimate the potential returns from your investment in an AIM WA training program.

Go Calculate

Make a Booking

    Waitlist only
    Limited spaces
    Please contact AIM WA Client Services on (08) 9383 8000 for booking information.

    *Prices Include GST

    More Computer Skills Programs

    • Access - Database Design

      Do you need to design new Microsoft Access databases? Then this program can provide you with the relevant skills It will show you how to develop queries, how to create reports using your data and how to send letters from the database using a Word mail merge. If you have the skills and knowledge introduced in AIM's Access - Database Design program, then this Intermediate program is right for you.

       
    • Access - Introduction to Macros

      This program covers the implementation of macros in a Microsoft Access database.

       
    • Access - Create Select Queries

      This program focuses on how to create select queries in a Microsoft Access database.

       
    • Access - Work with Existing Databases

      This program covers the skills you need to work with existing databases. It introduces the concept of databases and pays particular attention to searching for information in a database.

       
    Make an Enquiry