Description:

To register, click the "More Info" link above

This two-day workshop is designed for both those who wish to create a database from scratch and to make design changes to an existing database.

Day 1 Objectives

2010 Environment

Become comfortable in the new Access 2013 environment of Tabs & Ribbons

Database Design & Relationships

Define a structured purpose, scope, and objectives for the database

Learn data-gathering techniques that enable quicker starts, clarify the types if information needed from the database, and help in naming fields, grouping them into tables, and relating tables to each other

Consolidate data into user friendly critical content areas

Understand and implement three types of table relationships (one-to-one, one-to-many, and many-to-many) and eliminate weak relationships with a junction table

Apply normalization tests to evaluate the integrity of the database design

Tables

Create relationships between tables

Enforce referential integrity between tables to keep records in related fields valid and accurate; view sub-datasheets to related tables

Create lookup lists and set different properties of a field in the

Design view of a table

Create an input mask for data entry

Set validation rules and text for a field

Day 2 Objectives

Queries

Understand the purpose of various queries

Create a query from scratch and specify criteria

Create queries that are based on more than one table and create a calculated field

Use queries to summarized data from tables

Forms and Reports

Create forms & reports using the wizards and modify those forms with styles

Reorganize the form layout by moving fields to change the order in which they appear on the form

Modify properties to define an object's appearance, behavior, and characteristics

Customize headers and footers to prepare for printing