Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Creating Tables and Forms
in Microsoft Access

Version 2010 • 2013 • 2016

3 Hours

Learn the basics of creating a relational database. This course covers how to create tables and establish relationships. You will also learn 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

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

Creating Databases, Tables, and Relationships (cont'd)

  • 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

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

This class is only offered for private groups.

Private Group Classes

Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9 to 12pm and 1 to 4pm).

Conducted at Your Office

$500 flat fee for up to 8 students
$550 flat fee for up to 12 students
$35 per additional student

Conducted at Softek’s Facility

$575 flat fee for up to 8 students
$625 flat fee for up to 12 students
$35 per additional student

Have more or less students? Or, need to schedule more than one training day? Click here for a price quote based on your training needs. 

Why choose Softek?

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