Training & Development-Professional Development Curriculum

Microsoft Access, Level 1

MS Access is based on four "objects"-Tables, Queries, Forms, and Reports. In this one-day class, you'll learn how these four objects work together to form the foundation of your database. You will plan and modify a Table, which is where your information resides. You will learn how to extract the information you need by using Queries. You will create a Form that will make data easier to enter. Your data will be grouped and summarized by creating a Report.

Presenter: Frank Widman, Senior Technical Training Consultant

Prerequisite: Windows Experience

Enrollment: Use our Online Registration Form, or call 459-5565.

Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.

Related Courses:

• Access, Level 2
• Access, Level 3
• Introduction to Relational Databases

Course Outline

An Introduction to Database Management

• Definition of Terms

Creating a Database

• Planning the Structure
• Creating a Table
• Understanding Field Creation
• Defining a Primary Key
• Viewing the Table

Modifying and Adding Fields

• Editing a Field Name or Type
• Adding a New Field
• Using Field Property Options
• Adding a Validation Rule
• Adding an Input Mask

Sorting Records

• Sorting Records Using One Field
• Sorting Using Multiple Fields

Deleting Data and Fields

• Clearing a Field
• Deleting a Record
• Deleting a Field

Creating a Form

• Creating an AutoForm
• Modifying a Form
• Changing the Width and Background of the Form
• Resizing and Moving Fields
• Modifying with a Form's Tab Order
• Adding a List Box to a Form
• Adding a Custom Button to a Form

Entering Data

• Selecting Fields and Entering Data

Finding Records

• Filtering by Selection
• Filtering Excluding Selection
• Using Advanced Filter
• Creating AND Filters
• Creating OR Filters

Managing the Database

• Creating a New Record
• Entering Data
• Saving the Database
• Selecting Records
• Editing Data

Creating and Using Queries

• Creating a Query from a Filter and/or Sort
• Creating a Query Using the Simple Query Wizard
• Viewing Multiple Windows

Formatting a Datasheet

• Changing Font and Size
• Adjusting Column Width and Row Height
• Formatting Numbers and Dates

Creating a Report

• Creating a Report Using AutoReport
• Creating a Report Using a Wizard
• Modifying a Report

Printing a Report

Using On-Line Help and the Toolbar