Save 40% on Coursera Plus Annual

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2010: Shortcuts

via LinkedIn Learning

Go to class Write review
Coursera Ad

Google, IBM & Meta Certificates — Less Than ₹22/Day

Learn More → Corporate Finance Institute Ad

Build the Finance Skills That Lead to Promotions — Not Just Certificates

Learn More →

Overview

Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Get quick tips for making the most of Microsoft Access.

Syllabus

Introduction
  • Making the most of Access
1. Planning
  • Storyboarding
  • Planning table and field names
2. Building a Table
  • Quick table setups
  • Effective naming conventions
3. Field Properties
  • Using input masks
  • Making validation rules
  • Building lookup tables
4. Relationships
  • Creating one-to-many relationships
  • Type mismatch errors
  • Editing relationships
5. 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
6. Queries
  • Playing Go Fish with your data
  • Finding missing data
  • Updating records with a query
7. 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

Taught by

Alicia Katz Pollock

Reviews

4.7 rating at LinkedIn Learning based on 99 ratings

Start your review of Access 2010: Shortcuts

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.