INTERMEDIATE
Course
length: 2
half-day sessions
Who
should attend: Anyone
responsible for the setup of a relational database for others to use
Suggested
Background: Access
Introduction or equivalent experience
This course will take
you through a complete project from designing custom input forms, to creating
reports that group and summarize information.
During the class, you will also learn the principles of relational database
design, and how to assist and control data entry.
Upon
completion of this course, you will be able to:
Design a
Relational Database
Plan, create, and restructure a database
Define and use primary keys and indexes
Create relationships between tables
Understand and establish referential integrity
Control
Data Input
Understand and establish validity checks
Control display formats
Create input masks
Create
Custom Forms
Create columnar forms
Understand and work with form controls
Set the tab order
Add text and fields
Assist
Data Entry
Create drop down lists, check boxes, and option buttons
Create table lookups and calculated fields
Create and use master / detail forms
Sort, find, and filter records
Create
Advanced Reports
Create grouped
reports with totals and summaries
Work
with report and control properties