Access 2000 Training
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! |
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.
Multimedia 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: x86/400 mhz (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, or Windows Vista.
Access 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
Expires Sep 30, 2010
Save 10% to 20%
most training titles
For corporate orders, call to get a special quote or click here to receive a price quote by email.
Computer Training
Videos/CD-ROMs
Product List
Office
Other Categories
Autodesk
IT Certification
Microsoft Office
Soft skills
Computer Programming
Purchase Orders
Accepted from Corp., Gov., & Educational Institutions: Click here
