Essentials of Access: Creating Tables and Forms

3 Hours
Versions 2007 and 2010

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

Understanding Databases

Examining Important Screen Elements

Opening Databases

Understanding the Main Database Objects

Tables

Forms

Queries

Reports

Steps for Designing a Database

Creating Databases, Tables, and Relationships

Creating Databases

Understanding Fields and Data Types

Creating and Modifying Tables

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

Navigating Between Fields

Adding Records in Form View

Find us

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