Access Beginning: Create Your First Database

Upcoming Dates

Friday, July 28, 2017
9:00 AM - 12:00 PM*
Trainer: Tim
How would you prefer to attend?
Thursday, August 24, 2017
9:00 AM - 12:00 PM*
Trainer: Tim
How would you prefer to attend?
Tuesday, September 19, 2017
9:00 AM - 12:00 PM*
Trainer: Tim
How would you prefer to attend?
*All times are in the US/Pacific timezone.

Class Details

Price per person:$149
Length of class:three hours
Version covered:2016 for Windows

Description

In this three-hour training session, you will learn to create and manage a simple Access database. You will navigate within the Microsoft Access application environment, work in Datasheet view, create a simple database, import data from Excel, and work with records.


Prerequisites

This class is ideally suited for people with basic computing skills, such as using a mouse and opening and closing windows. No Access or database experience is required.


Outline

Getting Started with Access
- Understand tables, relationships and keys
- Understand the Access interface
- The Datasheet view
- Working with columns
- Navigating records
- Printing a datasheet

Create a simple Access database
- Create new fields
- Import data from Excel
- Create lookups
- Use the Help system

Working with Table Data
- Create new records
- Edit and delete records
- Find and replace
- Spell check


Printable Course Description