Powerful Queries Using Microsoft Access 2010 2017-08-04T14:26:49+00:00

Project Description

Welkin Course Code: PQM0

Course Features

Using a query, you can get specific information about your data from your database. You can use queries to filter your data, to perform calculations with your data, and to summarize your data. You can also use queries to automate many data management tasks and to review changes in your data before you commit to those changes. In the course, you will learn the techniques to create queries in Microsoft Access. Course topics include:

  • Creating a Basic Query
  • Building Criteria Expressions
  • Working with Multiple-table Queries
  • Creating PivotTable Queries
  • Querying with SQL Statements

This course will let you be more productive and effective in executing Queries with Microsoft Access.

  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on approach

Learn from the Experts

Get Professional Recognition


Certify your Access skills with Microsoft Office Specialist certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Access with the course Microsoft Access Programming.

Course Fee


Course Duration

6 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Access.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
 Cantonese / PC
1000-13006 hrs/
2 sessions
 Cantonese / PC
1900-22006 hrs/
2 sessions
THU, FRI1,380.00
 Cantonese / PC
1900-22006 hrs/
2 sessions
MON, WED1,380.00
 Cantonese / PC
1900-22006 hrs/
2 sessions
TUE, THU1,380.00
 Cantonese / PC
6 hrs/
2 sessions
 Cantonese / PC
1900-22006 hrs/
2 sessions
MON, TUE1,380.00
 Cantonese / PC
1000-13006 hrs/
2 sessions
 Cantonese / PC
1900-22006 hrs/
2 sessions
THU, FRI1,380.00
Powerful Queries Using Microsoft Access 2010/2007
Complete your Enrol
How to enrol/pay online

This course provides you with the skills and knowledge to write and use queries that can extract information from Access databases and perform calculations.

  1. Creating a Basic Query
    • Introducing Access Queries
    • Trying the Simple Query Wizard
    • Using the Query Design Window
    • Testing the Other Query Wizards
    • Creating Other Types of Queries
  2. Building Criteria Expressions
    • Writing Expressions for Query Criteria and Data Validation
    • Understanding the Elements of Expressions
    • Operators
    • Literals
    • Identifiers
    • Functions
    • Intrinsic and Named Constants
    • Creating Access Expressions
  3. Working with Multiple-Table Queries
    • Introducing Joins on Tables
    • Joining Tables to Create Multitable Queries
    • Using Lookup Fields in Tables
    • Adding Subdatasheets to a Table or Query
    • Outer, Self, and Theta Joins
    • Updating Table Data with Queries
    • Making All Fields of Tables Accessible
    • Making Calculations on Multiple Records
    • Designing Parameter Queries
    • Creating Crosstab Queries
    • Writing UNION Queries and Subqueries
  1. Creating Advanced Queries
    • Getting Acquainted with Action Queries
    • Creating New Tables with Make-Table Queries
    • Creating Action Queries to Append Records to a Table
    • Deleting Records from a Table with an Action Query
    • Updating Values of Multiple Records in a Table
    • Testing Cascading Deletion and Cascading Updates
  2. Creating PivotTable Queries
    • Understanding the Role of PivotTables and PivotCharts
    • Slicing and Dicing Data with PivotTables
    • Setting PivotTable Property Values
    • Exporting the PivotTable to Excel
    • Optimizing Performance of PivotTables
    • Formatting and Manipulating PivotCharts
  3. Querying with SQL Statements
    • Understanding the Role of SQL in Access 2007
    • Understanding SQL Grammar
    • Writing SELECT Queries in SQL
    • Writing Action Queries and Stored Procedures
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

You may also be interested in