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

Fundamentos de Excel para Negocios
Universidad Austral via Coursera
Excel Skills for Business: Essentials
Macquarie University via Coursera
مهارات برنامج Excel للعمل: المبادئ الأساسية
Macquarie University via Coursera
Spreadsheets for Beginners using Google Sheets
Coursera Project Network via Coursera
Build and Utilize Forms in LibreOffice Base
Coursera Project Network via Coursera