Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft Access 2000
with Ken Getz & Paul Litwin
CD-ROM Training


View the Course Outline
(Level 1 | Level 2 | Level 3)

To begin developing your programming skills, start with Level 1, Creating Applications in Microsoft Access. Build on your programming skills with Level 2 and learn advanced development techniques in Level 3.

Course includes 60+ hours of total training time...

  • 15 CDs
  • Over 20 hours of media run time
  • Over 1500 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
Microsoft Access 2000
CD-ROM

 15 CD-ROMs

$995.00  
CD-ROM & Books

 15 CD-ROMs + Printed Books

$1145.00  
Read about with Ken Getz & Paul Litwin.
Course Outline (Outlines are subject to change.)

Level 1: Creating Applications

Sessions Hours Pages
3 CDs 4 hours 300

Level 1 CD-ROMs introduce you to application development using Microsoft Access 2000. You’ll learn the tools you need to create a simple Microsoft Access application including tables, queries, forms, reports, and just enough VBA code to get you started. By the end of Level 1, you’ll lean how to put an application together, including how to create menus and how to launch your application from a startup form.

In Level 1 you will learn...
  • Design tables and queries so you can store and retrieve your information the best way possible.
  • Create useful, attractive form for data input and application navigation.
  • Create reports that display the data you want, formatted the way you want it.
  • Use hyperlinks and the Access Wizards to help create a full Access application without writing any code.
Prerequisites: To get the most out of Creating Applications in Microsoft Access, you should be familiar with the basics of creating tables and entering in Microsoft Access. Experience in creating and maintaining forms, reports, and queries is helpful, but not required.
SESSION 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


SESSION 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


SESSION 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 Simple 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

back to top


Level 2: Programming

Sessions Hours Pages
6 CDs 8 hours 600

Level 2 looks at the critical aspects of application development using Microsoft Access. You’ll dig deeper into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). Level 2 teaches you both how to design effective database applications, including database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. You’ll learn how to programmatically display and manipulate data on forms and reports, and you’ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages.

In Level 2 you will learn...
  • Start using VBA in Microsoft Access.
  • Design efficient table structures to organize your data.
  • Create relationships between tables and set up referential integrity.
  • Display filtered and sorted data on forms and reports.
  • Master tips and tricks that create great reports.
  • Publish live Access data on the Web using Data Access Pages
  • Work with forms’ recordsets.
Prerequisites: To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. Programming experience in any language is helpful, but not required.
SESSION 4

Making Forms and Controls Work
6.1 Modifying a Form’s Caption
6.2 Validating a Form’s Data
6.3 Using a Control’s Data Events
6.4 Introducing the Combo (and List) Box


Working with the VBA IDE
7.1 A Quick Tour of the VBA IDE
7.2 Writing Code
7.3 Testing Code


SESSION5

Effective Database Design
8.1 Why Bother with Design?
8.2 Relational Model Basics
8.3 Normalization


Making the Most of Your Tables
9.1 Building the Rules of the Business into the Database
9.2 Relationships and Referential Integrity
9.3 Creating Indexes


SESSION 6

Parameter and Aggregate Queries
10.1 Creating Parameter Queries
10.2 Aggregate Queries
10.3 Query Properties


Creating Data Access Pages
11.1 Introducing Data Access Pages
11.2 Working with Data Access Pages
11.3 Creating a Data Access Page with Groups
11.4 Deploying Data Access Pages


SESSION 7

Investigating VBA
12.1 Why Use VBA?
12.2 Introducing Modules and Procedures
12.3 Calling Procedures
12.4 Creating Your Own Procedures
12.5 Using Variables
12.6 Variable Data Types
12.7 Finishing the Age Function
12.8 Using Constants


Programming Objects
13.1 Working with Objects
13.2 Working with Collections
13.3 Using Object Variables


SESSION 8

Report Tips and Tricks
14.1 Getting Just the Data You Want
14.2 Creating Reports with Multiple Columns
14.3 Numbering Items on a Report
14.4 Using BackColor to Create Alternate Gray Lines


Controlling Controls
15.1 Using Subforms
15.2 Using MultiSelect ListBox Controls
15.3 Handling New Entries in a Combo Box
15.4 Working with Tab Controls


SESSION 9

Programming Forms' Data
16.1 Filtering and Sorting Forms
16.2 Finding a Row on a Form
16.3 Mark a Row and Return to It Later
16.4 Using a Form’s Recordset Property (Access 2000)


Form Tips and Tricks
17.1 Creating a Splash Screen
17.2 Using Popup Forms
17.3 Controlling a Form’s Closing
17.4 Tapping into Keyboard Events
17.5 Using ActiveX Controls

back to top


Level 3: Advanced Development

Sessions Hours Pages
6 CDs 7 hours 600

Level 3 shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You’ll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution.

In Level 3 you will learn...
  • Debug applications and handle errors.
  • Master Microsoft Access security.
  • Use Replication to synchronize data among multiple sites.
  • Design client/server applications with Microsoft Access.
  • Use Automation to incorporate other Windows applications into your Access solutions.
  • Manipulate data using ActiveX Data Objects (ADO).
Prerequisites: To get the most out of Advanced Development in Microsoft Access, you must be very familiar with creating and using all of Access' interactive objects: Tables, queries, forms, and reports. You must also understand how to use VBA to create event procedures in Access forms and user-defined functions that can be used in queries and form controls.
Session 10

Mastering Debugging
18.1 Why Do You Need Debugging?
18.2 Getting Started with Debugging
18.3 Stepping Through Code
18.4 Evaluating Expressions
18.5 Tips on Effective Debugging


Taking Advantage of Queries
19.1 Understanding Joins
19.2 Action Queries
19.3 Access SQL


SESSION 11

Managing Data with ADO
20.1 Introducing ActiveX Data Objects
20.2 Retrieving Data with ADO
20.3 Searching for Data in a Recordset
20.4 Updating Data with ADO


Using Error Handling to Bullet-Proof Your Code
21.1 Handling Run-Time Errors
21.2 The Error Handling Standard
21.3 Taking a Closer Look
21.4 Who Handles Errors?


SESSION 12

Designing Multiuser Applications
22.1 Multiuser Architectures
22.2 Locking
22.3 Keeping Recordsets Current
22.4 Transaction Processing


Exploring Replication
23.1 Replication Basics
23.2 Replicating a Database
23.3 Changes Access Makes to a Database When You Replicate it
23.4 Synchronizing Replicas
23.5 Conflict Management
23.6 Partial Replication


SESSION 13

Automating Office Applications
24.1 What Is Automation?
24.2 Working with Other Applications
24.3 Example: Building an Excel Chart
24.4 MailMerge with Word
24.5 Access as an Automation Server


SESSION 14

Securing Your Applications
25.1 Choosing the Right Security System
25.2 Workgroups
25.3 Users and Groups
25.4 Permissions
25.5 Using the Security Wizard to Properly Secure Your Database


Building Access Data Projects
26.1 Introduction to Access Projects
26.2 Creating a New Project
26.3 Creating SQL Server Objects
26.4 Creating SQL Server Database Diagrams
26.5 Creating SQL Server Views
26.6 Creating SQL Server Stored Procedures


SESSION 15

Developing Access 2000 Client/Server Applications
27.1 Introduction to Client/Server
27.2 MDB versus ADP
27.3 Designing Client/Server Applications
27.4 Designing MDB Client/Server Applications
27.5 Designing ADP Client/Server Applications


Deploying Access Applications
28.1 The Finishing Touches
28.2 Managing VBA Code
28.3 Introducing the Access Runtime Version
28.4 Developing Runtime Applications
28.5 Deploying Access Applications

back to top


Your Instructor

Ken Getz (MCSD, MCP) and Paul Litwin (MCSD, MCP) are your instructors for Microsoft Access 2000 Professional Training via Video and CD-ROM™. Both are Senior Consultants with MCW Technologies, a Microsoft Certified Solution Provider. Ken and Paul specialize in application development, training, and writing about Microsoft Access, Visual Basic, Visual InterDev, and related technologies.

They speak frequently at industry conferences, write articles for various publications, and are co-authors, along with Mike Gilbert, of the best-selling Access 97 Developer’s Handbook and Access 2000 Developer’s Handbook, as well as several other books.

Ken and Paul developed the courseware used in these videos. In addition, Ken is the author of Visual Basic courseware and videos and CD-ROMs, and Paul is the author of Visual InterDev and Active Server Pages (ASP) courseware and videos and CD-ROMs.



 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy