Access Quick Tips

27mIntermediate2019-02-27

Authors

Laurie Ann Ulrich

CEO of Limehat & Company

Course details

Microsoft Access is a powerful tool for collecting, querying, and reporting data. This series provides tips on how to do all that more effectively. Laurie Ann Ulrich—author of Access for Dummies—provides solutions and shortcuts for making your database more logical, your form and queries more useful, your reports more informative and engaging, and your workflow more efficient. From storyboarding your database to setting up input masks and parameter prompts, these tips are perfect for novice and experienced users alike.

Learning objectives
Planning your database
Building tables
Setting field properties
Creating relationships
Creating forms for data entry
Finding data with queries
Updating records with queries
Building better reports

Skills covered

Microsoft AccessDesktop DatabasesQuick TipsBusiness Software and ToolsMicrosoft

Concepts

Introduction

Making the most of Access

Planning

Storyboarding
Planning table and field names

Building a Table

Quick table setups
Effective naming conventions

Field Properties

Using input masks
Making validation rules
Building lookup tables

Relationships

Creating one-to-many relationships
Type mismatch errors
Editing relationships

Data Entry

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

Queries

Playing Go Fish with your data
Finding missing data
Updating records with a query

Reports

Aligning form and report content
Resizing field boxes and labels
Distributing form and report content
Creating labels for forms and reports
Drawing straight lines