Get quick tips for making the most of Microsoft Access.
Overview
Syllabus
Introduction
- Making the most of Access
- Storyboarding
- Planning table and field names
- Quick table setups
- Effective naming conventions
- Using input masks
- Making validation rules
- Building lookup tables
- Creating one-to-many relationships
- Type mismatch errors
- Editing relationships
- Fast forms with subforms
- Creating read-only forms
- Find your way with navigation forms
- Create combo and list boxes
- Make bigger buttons to speed data entry
- Adding forgotten fields to an existing form
- Adjusting tab order in forms
- Playing Go Fish with your data
- Finding missing data
- Updating records with a query
- Aligning form and report content
- Resizing field boxes and labels
- Distributing form and report content
- Creating labels for forms and reports
- Drawing straight lines
Taught by
Alicia Katz Pollock
