Microsoft Access

Our course introduces you to the world of computers using Microsoft Access. Learn how to utilize Access' powerful features to create and design a database. As a busy executive, Technical Advancement's continuing education program will give you the skills required to meet today's corporate challenges, and provide you with the necessary software knowledge to compete in today's technical world.

LEVEL 1

Access Basics
The Database Concept
Database Terms
Relational Database Concept


Database
Database Window
Creating a Database
Saving a Database
Opening a Database


Design View
Creating a Table
Field Name
Data Type
Description
Field Size
Numeric Field


Datasheet View
Adding new Fields
Deleting Fields
Renaming a Field
Finding Records
Sorting Records


Reports
AutoReports
Page Header/Footer
Mailing Labels


Additional Features
Forms
Queries
Office Links

LEVEL 2

Regional Database
The Foreign Key
Defining a Relationship
Enforce Referential Integrity
Join Type
Queries with Relational Database


Customized Forms
Form Header
Detail
Form Footer
Size Handles
Drop-Down Lists
Fill/Back Color


Custom Reports
Label
Expression


Advanced Queries
Crosstab Queries
Using Expressions
Criteria
Date Expressions
Operator
Between And


Additional Features
The Validation Rule
Validation Text
Macros
Command Buttons


Professional Training
 training classroom rental locations Locations
computer training room rental facility Training Room Rental



Technical Advancement is a full service technology firm.  We offer services in software development, networking, and Web site creation. Our seasoned staff of certified engineers, developers, and technical professionals can help you solve your IT challenges. Technical Advancement has been servicing our clients business and technology needs since 1982
 September 7, 2010 11:02:11 PM