Register Now      202-747-5000

Creating Tables and Forms in Microsoft Access

365 | 2019 | 2016
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

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).

We offer the above listed class as a private group class in the following delivery formats:

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 or Softek
1-4 students $1000
5-8 students $1150
9-12 students* $1250
*$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 $125 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. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee