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/Investment

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

Public Course at Softek Private Course at Your Office Private Course at Softek
This class is $500 flat fee up to 8 students $575 flat fee up to 8 students
only offered $550 flat fee up to 12 students $625 flat fee up to 12 students
for private groups. $35 per additional student $35 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.

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