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 97
with Ken Getz
CD-ROM Training

for Developers by Developers™


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

Master Microsoft Access 97 application development using these 12 easy-to-follow video tapes. Whether you are learning Microsoft Access 97 development for the first time or adding to your reference library, these videos are second to none.

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

  • 12 videos
  • Over 15 hours of media run time
  • Over 1100 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
Microsoft Access 97
Video

 12 Videos

$695.00  
Video & Books

 12 Videos + Printed Books

$815.00  
Read about with Ken Getz .
Course Outline (Outlines are subject to change.)

Level 1: Microsoft Access 97

Sessions Hours Pages
4 Videos 5 hours 400

Level 1 videos introduce you to developing applications in Microsoft Access 97. They teach you the basics of database design and how to create queries that get just the data you need. Level 1 also gets you started using VBA and covers topics in form and report design.

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 (82 min)

Database Design
1.1 Why Bother with Design?
1.2 Relational Model Basics
1.3 Normalization

Select Queries
2.1 Review of Query Basics
2.2 Parameter Queries
2.3 Multi-Table Queries and Joins
2.4 Query Properties

SESSION 2 (79 min)

Getting Started with VBA
3.1 Introduction to Microsoft Visual Basic for Applications
3.2 Creating a Simple Function
3.3 Calling a Function from a Query
3.4 Introduction to Events

Advanced Queries
4.1 Aggregate Queries
4.2 Action Queries
4.3 Access SQL
Appendix: Creating Union and Data Definition Queries

SESSION 3 (69 min)

Topics in Form Design
5.1 Programming Forms
5.2 Using the Tab Control to Create Multipage Forms
5.3 Creating Custom Menus, Shortcut Menus, and Toolbars
5.4 Creating a Startup Form

Designing and Building Reports
6.1 Getting Just the Data You Want
6.2 Creating Reports with Multiple Columns
6.3 Numbering Items on a Report
6.4 Using BackColor to Create Alternate Gray Lines

SESSION 4 (84 min)

Working with Controls
7.1 Using New Control Features
7.2 Using Subforms
7.3 Using OLE Data on Forms
7.4 Using ActiveX Controls

Using VBA
8.1 Why Use VBA?
8.2 Where Do You Put the Code?
8.3 Calling Macro Actions Using the DoCmd Object
8.4 Using the Development Environment
8.5 IntelliSense to the Rescue
8.6 Using the Debug Window
8.7 Modifying the Development Environment
8.8 Finding Your Procedures

back to top


Level 2: Microsoft Access 97

Sessions Hours Pages
5 Videos 5 hours 400

Level 2 Microsoft Access 97 videos teach you how to work with variables and procedures and use branching and looping structures in your code. Level 2 videos also cover debugging and error handling techniques and show you how to begin event-driven programming. The Level 2 videos also get into more advanced topics including how to work with recordsets and start developing multiuser applications.

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 5 (75 min)

Variables and Procedures
9.1 Introduction to Variables
9.2 Variables and Data Types
9.3 Using Constants
9.4 Investigating Built-In Functions
9.5 Optional and Named Arguments


Control Structures
10.1 Branching Structures
10.2 Looping Structures


SESSION 6 (74 min)

Debugging
11.1 Breakpoints
11.2 Watch Expressions
11.3 The Call Stack
11.4 The Debugging Process


Introduction to Objects
12.1 Overview of the Microsoft Access Object Hierarchy
12.2 Working with Forms and Controls
12.3 Using Object Variables
12.4 Special VBA Constructs for Objects


SESSION 7 (60 min)

Working with Events
13.1 Watching Events Happen
13.2 Form Events
13.3 Keyboard Events
13.4 Mouse Events


Error Handling
14.1 Recognizing a Run-Time Error
14.2 The Error Handling Standard
14.3 Setting the Error Trap
14.4 Exiting the Error Handler
14.5 An Alternative: Inline Error Handling


SESSION 8 (70 min)

Tips and Tricks with Forms
15.1 Using MultiSelect ListBox Controls
15.2 Using Pop-up Forms
15.3 Handling New Entries in a Combo Box
15.4 Controlling a Form’s Closing


Working with Recordsets
16.1 Getting Started
16.2 Creating a Recordset
16.3 Working with Recordset Properties and Methods
Appendix: Finding Data in a Recordset


SESSION 9 (61 min)

Working with a Form's Recordset
17.1 Filtering and Sorting Forms
17.2 Finding a Row on a Form
17.3 Mark a Row and Return to It Later


Designing Multiuser Applications
18.1 Multiuser Architecture
18.2 Locking
18.3 Keeping Recordsets Current
Appendix: Transaction Processing

back to top


Level 3: Microsoft Access 97

Sessions Hours Pages
3 Videos 3 hours 300

Level 3 Microsoft Access 97 videos focus on deploying your applications in Internet, replication, and client/server environments. They also teach you how to secure your database, use Automation, and work with recordsets using DAO.

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 (51 min)

Access and the Internet
19.1 Introduction to the Internet
19.2 Hyperlinking with Access
19.3 Publishing Static Data on the Web
Appendix: HTML Topics


Access and Automation
20.1 Access as an Automation Client
20.2 Working with ActiveX Controls
20.3 Access as an Automation Server


SESSION 11 (91 min)

Data Access Objects
21.1 What Is DAO, Anyway?
21.2 Working with Recordsets
21.3 Creating and Using QueryDefs
Appendix: SQL Review


Securing Your Databases
22.1 Choosing the Right Security System
22.2 Workgroups
22.3 Users and Groups
22.4 Permissions
22.5 Using the Security Wizard to Properly Secure Your Database
Appendix: Object Ownership


SESSION 12 (51 min)

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
Appendix: Replication Manager and Internet Synchronization


Client/Server Application Design
24.1 Introduction to Client/Server
24.2 Open Database Connectivity (ODBC)
24.3 Using Server Data with Access
24.4 Designing Client/Server Applications

back to top


Your Instructor

Ken Getz is a senior consultant with MCW Technologies and splits his time between programming, writing, and training. He specializes in tools and applications written in Visual Studio .NET and Visual Basic. Ken has had a long relationship with Application Developer's Training Company (www.appdev.com), and has been training and writing courseware for almost ten years. Most recently, he has written and presented training courses for Professional Training via CD-ROM series, including VB.NET, ASP.NET, ADO.NET (all with co-authors Mary Chipman and Andy Baron), VB6, VB5, and Access 2000/97 (with co-author Paul Litwin). Ken is also co-author of several best-selling books, including Access 2002 Developer's Handbooks (with Paul Litwin and Mike Gunderloy (Sybex)), Access Cookbook (with Andy Baron and Paul Litwin (O'Reilly)), VBA Developer's Handbook (with Mike Gilbert (Sybex)), and ASP.NET Developer's JumpStart (with Paul D. Sheriff (Addison-Wesley)). Ken is a frequent speaker at technical conferences and has spoken often at Microsoft's Tech-Ed conference. Ken's also a technical editor for Access-VB-SQL Advisor magazine and a columnist for Informant Publications' asp.netPRO magazine.



 
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