718-762-1900 888-227-0888

REGISTER NOW

 

Course Description

 

An efficient means of managing data is by using databases. Information can be stored, linked, and managed using a database application such a Microsoft Office Access. In this training session, you will examine database concepts, and create and modify databases and their various objects using Microsoft Office Access.

You will learn

If you do well in this unit, you should be able to:

  • Identify the terminology and functions common to most database management systems.
  • Identify the qualities of valuable information.
  • Identify the elements of good database design.
  • Construct formulas, including the use of built-in functions, and relative and absolute references.
  • Create and use tables.
  • Create and use queries.
  • Create simple reports and forms.
  • Use the Access online Help feature.
  • Discuss ethical issues connected to the use of databases.

Course Outline

 

CHAPTER 27: Introducing Access

 
  • Concept of Database
  • Tables, Queries, Forms, and Other Objects
  • Creating a Database File
  • Designing a Database

CHAPTER 28: Building Your Database Tables

 
  • Creating a Database Table
  • Opening and Viewing Tables
  • Entering and Altering Table Fields
  • Field Properties for Making Sure That Data Entries Are Accurate
  • Indexing for Faster Sorts, Searches, and Queries
  • Establishing Relationships Among Database Tables

CHAPTER 29: Entering the Data

 
  • The Two Ways to Enter Data
  • Entering the Data in Datasheet View
  • Entering the Data in a Form
  • Finding a Missing Record
  • Finding and Replacing Data

CHAPTER 30: Sorting, Querying, and Filtering for Data

 
  • Sorting Records in a Database Table
  • Filtering to Find Information
  • Querying: The Basics
  • Six Kinds of Queries

CHAPTER 31: Presenting Data in a Report

 
  • Creating a Report
  • Opening and Viewing Reports
  • Tweaking a Report