Microsoft Access

Northeast Technical Institute
Hermon, Scarborough, Maine, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.

Access, like other relational database management systems, is not easy to learn all on your own. There are concepts and theories about relational databases that are essential to working with these data repositories. Even if you will only be using a database created by someone else, understanding how a database is designed and structured will make your work easier and help you troubleshoot any data problems you might encounter. Almost all users of Access need to create queries, forms, or reports, and this course will get you started.

PREREQUISITES

Although no prior knowledge of databases is required, you should be familiar with basic computer operations before beginning this course. Experience using Microsoft Windows and a mouse is also required.

BENEFITS

In this course, you will learn the basic skills you need in order to begin designing and creating relational databases with Access. After taking this course, you will be able to go out and build databases that will harness the power of your company’s information. You will be able to run queries to find information on the spot and turn raw data into useful, customized forms and reports that will help your business to run more smoothly.

CERTIFICATION

This courses will help prepare students to take the following Certification:

(MOS) Microsoft Office Specialist

PERFORMANCE BASED OBJECTIVES

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. 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 OUTLINE

Working with a Relational Database

Identify Uses of a Relational Database
Define Database Terminology
Create a New Database Based on a Template
Examine the New Database
Planning a Database

Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys
Identify Table Relationships

Building the Basic Structure

Create a Blank Database
Create a Table using a Wizard
Compare Datasheet and Design View
Create Tables in Design View
Create Relationships between Tables
Working with Tables

Modify a Table Design
Work in Datasheet View
Work with Subdatasheets
Creating and Working with Select Queries

Examine a Query
Create a Query using a Wizard
Work in Query Design View
Select Records
Edit Values in a Query Datasheet
Add a Calculated Field to a Query
Perform a Calculation for a Group of Records
Creating and Using Forms

Create AutoForms
Create a Form Using a Wizard
Modify the Design of the Form
Use Forms to Work with Data
Creating and Using Reports

Create an AutoReport
Create a Report Using a Wizard
Examine a Report in Design View
Create a Calculated Field
Change the Format of a Control
Change the Style of a Report
Adjust Report Width
...''

Phone:(800) 447-1151

School Address:

Northeast Technical Institute
51 US Route 1, Suite K
Scarborough, ME 04074

Northeast Technical Institute
19 White Pine Road
Hermon, ME 04401

Northeast Technical Institute
191 Merrimack Street, Suite 701
Haverhill, MA 01830

Northeast Technical Institute
in partnership with Allied CS
55 Hampshire Road
Methuen, MA 01844

Jobs & Resumes: Hermon, Scarborough
Houses & Roommates: Hermon, Scarborough

Network Administration (MCSA, MCSE)
Software Administration (MCAD)
Web Master (w/3D Animation)
Database Administrator (MCDBA)
Truck Driving
Bartending/Mixology
Bar and Beverage Management
Basic Bartending
Business Administration
Legal Transcription
Microsoft Excel
Microsoft FrontPage
Microsoft PowerPoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Windows XP
QuickBooks

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.