Access 2010 Enhancing Tables

Objective

Learn more about creating and manipulating Access tables. Use advanced data types, create calculated fields, customize field properties, use input masks and validation rules, save field templates, and work with table data.

Prerequisite Skills

Course Description

Do you want to allow database users to attach files to fields? Do you want to create fields for hyperlinks to websites or e-mail addresses? Do you want to provide users with a list of valid entries for a field? Do you want to ensure the data that users enter meets specific criteria or is formatted in a specific way?

Attend this course if you want to:

• Create attachment fields.

• Create hyperlink fields.

• Create Lookup & Relationship fields.

• Set field properties for number fields.

• Create input masks.

• Add field validation rules to a field.

• Add record validation rules to a field.

• Save a field or set of fields as a user defined type.

Class Length

90 minutes

Delivery Options

• Virtual classroom - public
  ($70 per student; check times and register here)

• Virtual classroom - dedicated (up to ten people from the same organization)
  ($480 per class; contact us for more details)

• Virtual classroom - one on one
  (Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)

• On-site instructor-led
  (Contact us for details)

 

   

Related Information Register Now Access 2010 Course List Delivery Methods