Essentials of Access: Creating Tables and Forms

3 Hours
Versions 2003 or 2007

Below is a pre-designed course for Creating Tables and Forms in Microsoft Access.
This 3-hour course introduces users to Microsoft Access and demonstrates how to create and edit tables, define relationships between tables, and create forms to help enter data.

Understanding the Basics of a Database

What is a Database?

Opening a Database

Review Important Screen Elements

Understanding the Main Database Objects

Table

Form

Query

Report

Steps for Designing a Database

Creating a Database

Creating a New Database

Creating New Tables and Defining Fields

Defining Fields

Creating New Tables

Opening Tables

Modifying Table Structures

Relating and Linking Tables

Entering Data and Working with Tables

Adding New Records

Using Data Entry Shortcuts

Editing Information and Undoing Changes

Customizing the Datasheet

Entering Data into Related Tables

Deleting Records

Creating Forms to Work With Data

Reviewing Multi-table Forms

Creating Forms Using the Wizard

Closing Forms

Opening Forms

Customizing Forms

Understanding Form Sections

Widening the Overall Form Size

Working With Layouts and Fields

Formatting Objects

Working With Labels

Navigating Between Records

Navigating Between Fields

Adjusting Tab Order

Adding Records in Form View

Deleting Records

 

Find us
Find us on Facebook  Find us on Twitter

Register Online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.