Access 2000 CBT Course
CBT Training IT Training Courses & Microsoft Training Courses
 
             
home
products
information
resellers
contact
sitemap

Access 2000 CBT Course
[to previous page]   [other products in "Office 2000"]
  Access 2000 CBT Course or a generic image.
 
Product:

Access 2000 CBT Course

This course will help you create, manage and work in Access 2000. Learn tables, relationships, query, forms, reports, looping constructs and much more.
Price:
excl. VAT
  on DVD - Single User Lic.    £80.47 
  on DVD - Lending Lib. Lic.    £207.97 
 
Description:
Beginner
Introduction
  • Starting Access
  • Opening an Existing Database
  • The Access Desktop
  • The Database Window
  • A Preview of the Database Components
Working with an Existing Database
  • Viewing & Navigating Table Data
  • Editing Table Data
  • Adding Records to a Table
  • Selecting & Deleting Records
  • Find & Replace
  • Modifying the Appearance of a Datasheet
  • Spell-Check & Auto-correct
Form Basics
  • Moving from Record to Record
  • Finding
  • Sorting
  • Filtering
  • AutoForms
  • Using a Form Wizard
  • Conditional Formatting
Report Basics
  • Moving form Page to Page
  • Zooming In & Out
  • Viewing Multiple Pages
  • Printing
  • AutoReports & the Report Wizard
  • Page Setup
Printing Database Objects
  • Printing Table Datasheets
  • Printing Queries
  • Printing Forms
  • Printing Reports
Getting Help
  • The Office Assistant & Index Searching
  • Context-Sensitive Help & Printing Help Topics
Database Maintenance & Shortcuts
  • Backing Up & Restoring a Database
  • Compacting & Repairing a Database
  • Converting a Database to a Previous Version
  • Organizing Database Objects into Groups
Intermediate
Planning & Designing a Database
  • Evaluating Inputs & Outputs
  • Normalization
  • Creating a Database Using a Wizard
  • Creating a Database from Scratch
Building & Modifying Tables
  • Creating Tables Using a Wizard
  • Creating Tables from Scratch & Data Types
  • Setting Primary Keys
  • Field Properties
  • Input Masks
  • The Lookup Wizard
  • Indexes
Working with Relationships
  • Introduction to Relationships
  • Benefits of Relationships
  • Types of Relationships
  • Referential Integrity
  • Indexes & Relationships
  • Printing Relationships
Designing Simple Queries
  • Selecting Fields & Ordering the Query Result
  • Refining Queries with Criteria
  • Updatability of Query Results
  • Queries Based on Multiple Tables
Advanced
Building & Modifying Forms
  • Adding Controls
  • Selecting Controls
  • Moving
  • Aligning Controls
  • Changing Control Properties
  • Changing the Tab Order Controls
  • Form Properties
  • Working with Combo Boxes & List Boxes
Building & Modifying Reports
  • Understanding Report Bands
  • Working with Controls
  • Creating Groups & Totals Reports
  • Working with Report Properties
  • Modifying Selection Criteria
Database Startup Options
  • Setting the Application
  • Designing other Startup Information
Importing
  • Exporting to another Database
  • Exporting to an Excel Spreadsheet
  • Exporting to ASCII
  • Exporting to HTML
  • Importing from another Access Database
  • Importing Spreadsheet Data
  • Importing ASCII Data
  • Importing from HTML
  • Linking to Another Access Database
  • Linking to another types of Database
  • The Linked Table Manager
Similar    
Products: 		Access 2000 Developer Series (16 levels)
Access 2000 Expert Topics Training
Access 2000 Complete Training
Access 2000 Web Security Training

2Gb USB 2.0 Flash Drive on Special Offer.

Paypal, Verified By Visa, Mastercard SecureCode, Cheques or Invoice

RCS Newsletter
*Verify: 909593

Quick Links
 ***Special offers ***
 Bookmark this Site
 CBT Courses
 Demo's/Intro's (new)
 eBooks
 LMS (Enterprise)
 Recent Additions
 Top 20 List
 MCSE 2003 Courses
 Terms & Conditions
Our Customers

excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
 thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"

More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language

Copyright 2002-2008 RCS Limited. All rights reserved. More ...
RCS Limited for home study/ self study/home learning/CBT/Computer Based Training