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...
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
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
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
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.
