Creating Tables and Forms in Microsoft Access

3 Hours

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the basics of creating a relational database using Microsoft Access. This 3-hour course will also teach students how to quickly create a form to help enter data into the tables.

Course Objectives

Understand the basics of an Access database
Create a new database, create tables, define fields, and modify the structure
Create tables and establish a relationship
Enter and edit data using the Datasheet view of the table
Create and edit forms for data entry

Course Outline

Understanding the Basics of Databases

Understanding Databases
Examining Important Screen Elements
Microsoft Access View
The Office Button/Backstage View
Opening Databases
Message Bar
Quick Access Toolbar
Title Bar
Ribbon
Navigation Pane
Status Bar
Understanding the Main Database Objects
Tables
Forms
Queries
Reports
Steps for Designing Databases

Creating Databases, Tables, and Relationships

Creating Blank Databases
Understanding Fields and Data Types
Creating and Modifying Tables
Creating and Modifying Tables in Datasheet View
Creating and Modifying Tables in Design View
Customizing the Navigation Pane
Opening Tables in Datasheet View
Switching Between Datasheet and Design View
Closing Tables
Establishing Relationships between Tables

Entering Data and Working with Tables

Adding Records
Using Data Entry Shortcuts
Editing Information and Undoing Changes
Saving Layout Changes to Tables
Entering Data into Related Tables
Deleting Records

Creating Forms to Facilitate Data Entry

Creating Forms Using the Form Command
Closing Forms
Opening Forms
Switching Between Form Views
Understanding Form Sections
Widening Forms
Working With Layouts and Fields
Formatting Objects
Working with Labels
Navigating Between Fields
Adding Records in Form View
Deleting Records

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students	$850
5-8 students	$1000
9-12 students*	$1100
*$35 per additional student

Private Group Class: At Your Location
1-4 students	$1100
5-8 students	$1250
9-12 students*	$1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.

Choose Your Learning Adventure: