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.

Access 2000
Excel 2000
Word 2000
PowerPoint 2000
Access 2002
Excel 2002
Word 2002
PowerPoint 2002
Office 2000
Office XP
Windows 2000 Pro
Windows 2000 Server
Visual C++
JavaScript
Computer Hardware
ColdFusion 4.5
HTML 4.0

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.


 


In addition to our training courses we also offer free online certification exams on several topics including Microsoft Office, Computer Hardware, HTML, PC Basics and more.

Click here for online certification exams.

CS-234 Microsft Access 2000


This professionally developed training course spans 4 volumes and contains over 6 hours of quality instructor led training on Microsoft Access 2000. Multimedia content allows you to quickly learn Access concepts and the video format makes the training easy to learn as you can stop pause and review the training at any time. A detailed outline of the course as well as a short introduction to the trainer are included below.

   Access 2000 Essentials set of 3 (CD) $159.95
   Access 2000 Essentials set of 3 (VHS) $159.95
   Shipping (US only)
FREE

About The Trainer:

Alison Balter is a Microsoft Certified Systems Developer and Microsoft Access Trainer who specializes in Windows applications training. Alison is a former president of the Independent Computer Consultants Association of Los Angeles, a Microsoft Solution Provider and a member of the Borland Connection.

Beginning Access 2000 (2 Hrs 6 Mins)

1.0 Introduction (26 Mins)
1.1 Starting Access
1.2 Opening an Existing Database
1.3 The Access Desktop
1.4 The Database Window
1.5 A Preview of the Database Components
2.0 Working with an Existing Database (33 Mins)
2.1 Viewing & Navigating Table Data
2.2 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 (25 Mins)
3.1 Moving from Record to Record
3.2 Finding
3.3 Sorting
3.4 Filtering
3.5 AutoForms
3.6 Using a Form Wizard
3.7 Conditional Formatting
4.0 Report Basics (15 Mins)
4.1 Moving form Page to Page
4.2 Zooming In & Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports & the Report Wizard
4.6 Page Setup
5.0 Printing Database Objects (5 Mins)
5.1 Printing Table Datasheets
5.2 Printing Queries
5.3 Printing Forms
5.4 Printing Reports
6.0 Getting Help (8 Mins)
6.1 The Office Assistant & Index Searching
6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts (12 Mins)
7.1 Backing Up & Restoring a Database
7.2 Compacting & Repairing a Database
7.3 Converting a Database to a Previous Version
7.4 Organizing Database Objects into Groups

Intermediate Access 2000 (2 Hrs 4 Mins)

1.0 Planning & Designing a Database (20 Mins)
1.1 Evaluating Inputs & Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables (49 Mins)
2.1 Creating Tables Using a Wizard
2.2 Creating Tables from Scratch & Data Types
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes
3.0 Working with Relationships (27 Mins)
3.1 Introduction to Relationships
3.2 Benefits of Relationships
3.3 Types of Relationships
3.4 Referential Integrity
3.5 Indexes & Relationships
3.6 Printing Relationships
4.0 Designing Simple Queries (27 Mins)
4.1 Selecting Fields & Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables


Advanced Access 2000 (2 Hrs 3 Mins)

1.0 Building & Modifying Forms (51 Mins)
1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving
1.4 Aligning Controls
1.5 Changing Control Properties
1.6 Changing the Tab Order Controls
1.7 Form Properties
1.8 Working with Combo Boxes & List Boxes
2.0 Building & Modifying Reports (26 Mins)
2.1 Understanding Report Bands
2.2 Working with Controls
2.3 Creating Groups & Totals Reports
2.4 Working with Report Properties
2.5 Modifying Selection Criteria
3.0 Database Startup Options (5 Mins)
3.1 Setting the Application
3.2 Designing other Startup Information
4.0 Importing (41 Mins)
4.1 Exporting to another Database
4.2 Exporting to an Excel Spreadsheet
4.3 Exporting to ASCII
4.4 Exporting to HTML
4.5 Importing from anther Access Database
4.6 Importing Spreadsheet Data
4.7 Importing ASCII Data
4.8 Importing from HTML
4.9 Linking to Another Access Database
4.10 Linking to Other types of Databases
4.11 The Linked Table Manager


Please visit our special offers page to view some superb offers from our partners on the web. To view our special offers click here.

Or continue browsing our courses below.


3D Studio Max
A+ 2003
Microsoft Access 2007
Acrobat 4
ActiveX and OLE
Adobe Illustrator
Adobe InDesign CS
Adobe PhotoShop CS
ASP .NET
AutoCAD 2000
C Programming
C# Programming
Cisco CCNA
CompTIA Security+
CorelDRAW 10
Crystal Reports 8
Delphi 6

Exchange Server 2000
Flash 5
Frontpage 2000
ICDL/ECDL
IIS 5
Java 2
Linux 101
Linux 102
Lotus Notes 5
MicroSoft .NET
Network+ 2002
Oracle 8iR2
Outlook 2000
Outlook XP
PageMaker 6.5
Paradox 8

Perl 5
PhotoDraw 2000
PhotoPaint 8
SQL Server 2000
TCP/IP 4
Unix
Visio 2002
VB .NET
VBScript 5
Visual FoxPro 6
MCSE 2000
Windows XP User
WordPerfect 9
WordPerfect 11
XML
ZenWorks 3.0

     

     


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

  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

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