Back to All Events

Microsoft Access Training: Introduction (Level 1 of 3)

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Access series, click here.

Access Level 1: Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • define the purpose of and terminology associated with a relational database and Access objects.
  • follow the steps required to properly design a database.
  • create tables to hold data and then establish table relationships.
  • modify the design of and work with data in tables.
  • create, modify the design of, and work with select queries.
  • create and modify forms to work with your data.
  • create and modify reports to select, organize, and print data.

Course Content

Lesson 1: Working with a Relational Database

Topic 1A: Identify Uses of a Relational Database

Topic 1B: Define Database Terminology

Topic 1C: Create a New Database Based on a Template

Topic 1D: Examine the New Database

Lesson 2: Planning a Database

Topic 2A: Identify Database Purpose

Topic 2B: Review Existing Data

Topic 2C: Determine Fields

Topic 2D: Group Fields into Tables

Topic 2E: Normalize the Data

Topic 2F: Designate Primary and Foreign Keys

Topic 2G: Identify Table Relationships

Lesson 3: Building the Basic Structure

Topic 3A: Create a Blank Database

Topic 3B: Create a Table using a Wizard

Topic 3C: Compare Datasheet and Design Views

Topic 3D: Create Tables in Design View

Topic 3E: Create Relationships between Tables

Lesson 4: Working with Tables

Topic 4A: Modify a Table Design

Topic 4B: Work in Datasheet View

Topic 4C: Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

Topic 5A: Examine a Query

Topic 5B: Create a Query Using a Wizard

Topic 5C: Work in Query Design View

Topic 5D: Select Records

Topic 5E: Edit Values in a Query Datasheet

Topic 5F: Add a Calculated Field to a Query

Topic 5G: Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

Topic 6A: Create AutoForms

Topic 6B: Create a Form Using a Wizard

Topic 6C: Modify the Design of the Form

Topic 6D: Use Forms to Work with Data

Lesson 7: Creating and Using Reports

Topic 7A: Create an AutoReport

Topic 7B: Create a Report Using a Wizard

Topic 7C: Examine a Report in Design View

Topic 7D: Create a Calculated Field

Topic 7E: Change the Format of a Control

Topic 7F: Change the Style of a Report

Topic 7G: Adjust Report Width

 

Later Event: May 18
USM Gulf Park Visit