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

0. Introduction

01 - Making the most of Access

1. Planning

02 - Storyboarding
03 - Planning table and field names

2. Building a Table

04 - Quick table setups
05 - Effective naming conventions

3. Field Properties

06 - Using input masks
07 - Making validation rules
08 - Building lookup tables

4. Relationships

09 - Creating one-to-many relationships
10 - Type mismatch errors
11 - Editing relationships

5. Data Entry

12 - Fast forms with subforms
13 - Creating read-only forms
14 - Find your way with navigation forms
15 - Create combo and list boxes
16 - Make bigger buttons to speed data entry
17 - Adding forgotten fields to an existing form
18 - Adjusting tab order in forms

6. Queries

19 - Playing Go Fish with your data
20 - Finding missing data
21 - Updating records with a query

7. Reports

22 - Aligning form and report content
23 - Resizing field boxes and labels
24 - Distributing form and report content
25 - Creating labels for forms and reports
26 - Drawing straight lines