YoVDO

Access 2010: Shortcuts

Offered By: LinkedIn Learning

Tags

Microsoft Access Courses File Management Courses Database Management Courses Data Entry Courses

Course Description

Overview

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

Related Courses

Datenmanagement mit SQL
openHPI
Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera
Getting and Cleaning Data
Johns Hopkins University via Coursera
Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق)
MongoDB for .NET Developers
MongoDB University