Access 2007 II. Data Manipulation CCE-578

Students will edit existing tables and set field properties to help maintain accurate data input. Create Input Masks, set Default Values, setup Validation Rules, and customize Date & Time formats. Learn how to find, sort, and filter and print data.

Course Outline

In the second of four workshops, students will look at editing existing tables and setting field properties to help maintain accurate data input. Field Property settings let you create Input Masks, set Default Values, setup Validation Rules, and customize Date & Time formats. Students will learn how to find, sort, and filter data in a table and to print that data.

Additional Details

Pre-Requisites

Access 2007 I. Introduction CCE-577 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