Access 2000 Training

Access 2000 Training Videos on CD

Access 2000 Training Course

Hosted by Alison Balter
Approx. 6 hours of Access training on CD

This detailed and comprehensive Access 2000 training course teaches you Access 2000 through step-by-step, easy to understand instructions. Quickly learn beginner to advanced level features in Access 2000.

At the end of this course, you will learn how to design and create tables, export and import database objects, and manage your database project in Access 2000. Learn tables, relationships, query, forms, reports, looping constructs and much more.

Special Offer!
Try the beginners level Access 2000 training CD-ROM for only $10.00

Click here for details.

Our Access 2000 training CD-ROMs include a pretest to assess
your current skill level and a post test to test your newly
acquired knowledge.

Access 2000 Training Series

Clearance item, All Sales are Final. WORKS ON WINDOW XP ONLY: SEE SYSTEM REQ BELOW

Part#: sk-acc00 | Contents: Set of 3 CDs

Format

Reg: $189.00
Sale: $49.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, or Windows XP.
NOT COMPATIBLE with Windows XP 64-Bit Edition, Windows Vista, Windows 7, or Windows 8.

TrainerAccess 2000 Trainer: Alison Balter
Alison 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. 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 also one of four speakers on the Microsoft Visual Basic/Visual Studio World Tour.

Course Outline - Access 2000 Training:

Approx. 6 hrs. of training

ACCESS 2000 BEGINNING (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

ACCESS 2000 INTERMEDIATE (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

ACCESS 2000 ADVANCED (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
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 Anther Access Database
4.10 Linking to anther types of Database
4.11 The Linked Table Manager

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $189.00
Sale price: $49.00

Format

Product Details
  • Part#: sk-acc00
  • Contents: Set of 3 CDs
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player