Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!


Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!

Course Highlights

  • Create a new database, copy a database, or work with an existing one.
  • Use Datasheet view to work with table and query fields and properties.
  • Find, sort, and filter data. Set up a table for optimum data entry through the use of Input Masks, Validation Rules and Help Text.
  • Understand table relationships, field dependencies, and form and report controls.

About This Course

This Microsoft Office Access 2003 Course will lead you through the interface and design capabilities of Access 2003. With quick tips and detailed instructions, you will learn how to track and report information with ease. This course was developed for all Access users – beginner through advanced.

In this course, you will learn how to take advantage of and work in-depth with many of the Access objects (such as tables, forms, queries and reports) as well as how to import data from external applications, share your database information, and much more.

This Microsoft Office Access 2007 Essentials Training Course contains three levels of instruction designed to walk you through using Access to develop detailed databases.

There are over 50 lessons in this Access course – all designed to increase your productivity.

Access 2003: Beginner Level

1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database Fields, Properties, and Datasheet View
1.5 Copying Databases
2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting & Deleting Records
2.5 Find & Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check & Auto-correct
3.0 Form Basics
3.1 Using a Form Wizard and Moving from Record to Record
3.2 Finding Data
3.3 Sorting Data
3.4 Filtering Data
3.5 AutoForms
4.0 Report Basics
4.1 AutoReports & the Report Wizard
4.2 Zooming In & Out
4.3 Moving from Page to Page
4.4 Viewing Multiple Pages
4.5 Printing

Access 2003: Intermediate Level

1.0 Planning & Designing a Database
1.1 Copy Database for Intermediate Lessons
1.2 Creating a Database Using a Wizard
2.0 Building & Modifying Tables
2.1 Evaluating Inputs and Outputs
2.2 Creating Tables Using a Wizard
2.3 Creating Tables without the Use of a Wizard, Field Properties, Input Masks
2.4 The Lookup Wizard
2.5 Format, Default Value, Validation Rules and Validation Text
3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Setting Primary Keys
3.3 Indexes, Relationships and Normalization
3.4 Printing Relationships

Access 2003: Advanced Level

1.0 Designing Simple Queries
1.1 Selecting Fields in Single and Multiple Tables
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results
2.0 Building and Modifying Forms
2.1 Adding Controls
2.2 Selecting, Moving, Sizing, Deleting and Aligning Controls
2.3 Changing Control Properties
2.4 Changing the Tab Order Controls and Form Properties
2.5 Working with Combo Boxes & List Boxes
3.0 Building & Modifying Reports
3.1 Creating Groups and Total Reports
3.2 Understanding Report Bands
3.3 Working with Controls
3.4 Working with Report Properties
3.5 Modifying Selection Criteria
4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 Import Data to Access
4.3 Export data from Access
4.4 Create and Modify Calculated Fields and Aggregate Functions
4.5 Create a Data Access Page
4.6 Back up a database
4.7 Compact and repair databases


Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
2003 / 2007
2003 / 2007
2003 | 2007
2010 | 2007
2010 | 2007
2010 | 2007
2010 | 2007
2010 | 2007
Office for Mac
Excel for Mac
Entourage for Mac
PowerPoint for Mac
Word for Mac

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003

Typing Speed Test
Test your typing speed with our certified typing speed test today.


© 2002-2011 National Computer Science Academy, All Rights Reserved.