Description:

To register, click the “More info” link above

Day One

2013 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