Microsoft Access 2003 and 2007 Training Course

Login
Password


Free Exams! Test your skills with one of our certification exams and see how you stack up right now. Homepage 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