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.


This complete training course for the Paradox 8 includes 4 VHS tapes and contains over 6 hours of professional quality instructor led training. Multimedia content allows you to quickly learn key concepts and the VHS format lets you quickly pause and review important areas. A detailed outline of the course as well as a short introduction to the trainer are included below.

   Paradox 8 set of 4 (VHS) $159.95
   Shipping (US only)
FREE

About The Trainer:

Alison Balter is a highly experienced independent trainer and consultant, specializing in Windows applications training and development. During her seventeen years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded her company in 1990, their client base has expanded to include major corporations and government agencies such as Shell Oil, the Motion Picture Editors Guild, the International Cinematographers Guild, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, and others. Alison's company, InfoTechnology Partners, Inc., is a Microsoft Certified Partner and Alison was one of the first professionals in the computer industry to become a Microsoft Certified Solutions Developer. Alison is the author of over 400 internationally marketed computer training videos. She travels throughout North America giving training seminars in Visual InterDev, SQL Server, Microsoft Access, Visual Basic, and Visual Basic for Applications. She is also featured regularly in the National Technological University live satellite television broadcasts.

Alison is a regular contributing columnist for Access/Office/Visual Basic Advisor as well as other computer publications. She is also a regular on the Access and Visual Basic national speaker circuit. She was one of four speakers on the Visual Basic/Visual Studio World Tour, a seminar series co-sponsored by Application Developers Training Company and Microsoft.

Alison is the author of Alison Balters Mastering Access 2002 Desktop Development, Alison Balters Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 97 Development, and Alison Balter's Mastering Access 95 Development. She is also a co-author of three other Access books published by SAMS Publishing: Essential Access 95, Access 95 Unleashed and Access 97 Unleashed. Alison's firm, InfoTechnology Partners, Inc., is available for consulting work and on-site training in Microsoft Access and Visual Basic, as well as for Windows NT/2000, Windows 9x networking, and Microsoft Exchange Server.

 

 Beginning (2 Hrs.)

  Getting Started (16 Min.)

  • Working with an existing database
  • Creating a database using the database expert
  Working with Table Data (18 Min.)

  • Opening an existing Table
  • Viewing Table Data
  • Editing Table Data
  • Adding New Records
  • Deleting a Record
  Customizing Table View (16 Min.)

  • Changing Column Width and Row Height
  • Modifying the Column Order
  • Modifying Column Properties
  • Working with Column Heading Properties
  • Manipulating Grid Properties
  • Freezing Column Scrolling
  • Saving Table View Properties
  • Restoring Default Table View Properties
  • Working in Form View
  Manipulating Table Data (12 Min.)

  • Searching for Data
  • Replacing Table Data
  • Filtering Table Data
  • Modifying the Order of Table Data
  Getting Help (6 Min.)

  • Using Help Features
  Creating Your Own Tables (24 Min.)

  • Using the Table Expert
  • Creating a Table Without an Expert
  • Modifying a Table Structure
  • Adding Indexes to the Table
  Query Basics (11 Min.)

  • Creating a New Query
  • Entering Simple Criteria
  • Saving and Using a Query
  • Printing a Query Result
  Form Basics (6 Min.)

  • Creating a Form Using the Form Expert
  Report Basics (10 Min.)

  • Creating a New Report
  • Using the Report Expert

 Intermediate (2 Hrs. 1 Min.)

  Managing Files (30 Min.)

  • Using the Project Viewer
  • Modifying the Working Directory
  • Working with Aliases
  • Copying, Renaming and Deleting files
  • Borrowing Table Structure
  • Removing Table Data
  • Transferring Data from Table to Table
  • Sorting Table Data
  • Exporting Data to Another File type
  • Importing Data from an External file
  Customizing the Environment (7 Min.)

  • Establishing Application Preferences
  • Manipulating Toolbars
  Advanced Table View Techniques (21 Min.)

  • Advanced Find
  • Working with Memo Fields
  • Data Entry Shortcuts
  • Formatting Numbers and Dates
  • Working with Data Dependent Properties
  Advanced Table Design Techniques (23 Min.)

  • Entering Minimum and Maximum Values
  • Selecting a Default
  • Entering a Picture Template
  • Designating a Field as Required
  • Utilizing Table Lookups
  Advanced Query Techniques (28 Min.)

  • Advanced Field Selection Techniques
  • Working with the Answer Table
  • Modifying Query Properties
  • Advanced Criteria Selection
  • Using Queries to Insert Records
  • Using a Query to change Table Data
  • Using Queries to Delete Data
  • Including Calculations in Queries
  Advanced Report Features (11 Min.)

  • Working with Mailing Labels
  • The Merge Expert

 Advanced (1 Hr. 51 Min.)

  Advanced Form Techniques (36 Min.)

  • Selecting, Moving, Resizing, and Copying Objects
  • Using the Alignment Toolbar
  • Adding Text
  • Adding Fields
  • Enhancing the Form with Boxes and Lines
  • Selecting Data with Combo Boxes
  • Modifying Object Properties
  • Adding Command Buttons
  • Designing a Multi-page Form
  Working with Multiple Tables (24 Min.)

  • Advanced Database Design
  • Establishing Referential Integrity
  • Working with Data Models
  Designing Multi-table Queries (25 Min.)

  • Linking Tables without the Data Model
  • Linking Multiple Tables with the Data Model
  • Inner Joins
  • Outer Joins
  • Self Joins
  • Including Calculations in Multi-table Queries
  • Summarizing Data in Multi-table Queries
  Designing Multi-tables Forms (25 Min.)

  • Creating a Multi-table Form with the Expert
  • Working with a Data Model
  • Building a Multi-table Form from Scratch
  • Working with a Data Frame
  • Building a Form from a Multi-table Query

 Power Features (1 Hr. 31 Min.)

  Designing Multi-table Reports (10 Min.)

  • Creating a Multi-table Report with the Expert
  • Working with a Data Model
  Power Form Techniques (15 Min.)

  • Using the Object Explorer
  • Setting Window Properties
  • Copying a Style to the Toolbar
  • Working with Style Sheets
  Power Report Techniques (28 Min.)

  • Working with Report Objects
  • Working with Objects Properties
  • Adding Report Bands (Grouping)
  • Adding Summary Calculations
  • Moving and Deleting a Report Band
  • Removing Grid Lines
  • Inserting Page Breaks
  • Filtering Report Data
  • Page Layout and Print Options
  Putting it all Together with a Launcher (6 Min.)

  • Creating a Launcher
  Power Query Techniques (15 Min.)

  • Performing Summary Calculations
  • Applying Criteria to Summary Calculations and Sets of Records
  Working with Crosstabs (6 Min.)

  • Creating a Crosstab Query
  Object Linking and Embedding (10 Min.)

  • Embedded Objects
  • Linked Objects
  • Unbound OLE Objects

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.