Access 2007 III. Queries CCE-579

Students are introduced to the Query menu. Create Queries through the Query Wizard and Design View, modify query results, add criteria to the Query. Create a Calculated Field, design a Parameter Query, Concatenation to join fields, Update Query feature.

Course Outline

In workshop three of four, students are introduced to the Query menu. Learn how to create Queries through the Query Wizard and Design View, modify query results, and add criteria to the Query. Students will also learn how to create a Calculated Field, design a Parameter Query, use Concatenation to join fields, and how to use the Update Query feature within a query.

Additional Details

Pre-Requisites

Access 2007 II. Data Manipulation CCE-578 McMaster University CE Microsoft Office workshops (access. Word, etc.) are designed to be taken sequentially. In most cases, it is recommended the you attend ALL workshops listed in a series. Other prerequisites are noted as applicable.

Certificates offered

A letter outlining your participation.

Cancellation Policy

Participants who withdraw or fail to find a substitute less than 5 business days before the start of their course will be charged a fee based on the workshop duration as follows:
- $50 --- half-day workshop
- $100 --- one-day workshop
- $150 --- two-day workshop
Participants may withdraw or transfer to a different workshop 5 business days or more before the start of the workshop at no penalty. Individuals must notify the Centre for Continuing Education in writing to withdraw from a workshop.
Substitutions for a paid registration are welcome at anytime. The Centre for Continuing Education reserves the right to substitute qualified instructors due to unforeseen circumstances

Map & Reviews

McMaster University CCE
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

For a basic introduction to Macros, this was a good session. Perhaps, the handouts could have included a link to a 'bible' of more advanced commands.

Reviewed by Christopher L. 2011

   

Perfect, exactly what I was expecting/needed.

Reviewed by Christopher L. 2011