Microsoft Access 2000, Level 1

This three module program provides a comprehensive set of skills for developing Windows based database applications using Access 2000. In addition to gaining knowledge in Access 2000 students will have an excellent background in Microsoft Windows programming and programming in the new object / component based paradigm. This is a practical course

Level1

Cost: $325 + GST

Set of 3 CD's

All 3 Levels
Cost: $1395 + GST
 Set of 15 CD's

that provides the skills and knowledge to fully exploit the features and capabilities of the Access 2000 environment including tips and secrets from experienced developers. Particular emphasis is placed on VBA "Visual Basic for Applications" language, which is becoming a standard for all Microsoft products, and detailed coverage of the Access 2000 "Data Access Objects". All relevant relational database issues including Client Server development are covered.

CD-ROM 1

Creating Tables and Relationships
1.1 A Few Words About Database Design
1.2 Creating Tables
1.3 Creating Tables Using Design View
1.4 Creating Relationships
1.5 Importing and Linking to External Data

Creating Queries
2.1 Query Basics
2.2 Creating Query Criteria
2.3 Fine Tuning Your Queries
2.4 Multi-Table Queries and Joins

CD-ROM 2

Getting Started with Forms
3.1 Why Use Forms?
3.2 Getting Started
3.3 Creating a Bound Form
3.4 Working with Properties
3.5 Working with Other Control Types
3.6 Creating an Unbound Form
3.7 Managing Your Form’s Interface

CD-ROM 3

Displaying Data with Reports
4.1 Comparing Forms and Reports
4.2 Creating a Basic Report
4.3 Introducing the Sorting and Grouping Window
4.4 Performing Calculations on Reports
4.5 Making Sections Behave
4.6 TextBox Properties
4.7 Performing More Complex Calculations
4.8 Print Setup/Output

Building a Sample Application
5.1 Putting Together an Access Application
5.2 Using Hyperlinks in Access Applications
5.3 Using the Command Button Wizard
5.4 Creating Custom Menus, Shortcut Menus, and Toolbars
5.5 Creating a Startup Form