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 learning approach
  • Best practices demonstrated and explained

Learn from the Experts

Get Your Skills Certified

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
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Powerful Queries Using Microsoft Access 2010
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in