Access 2000 Training Course by AppDev

Access 2000 Training Course

Your Access 2000 Instructors

Ken Getz

Paul Litwin
Ken Getz (MCSD, MCP) and Paul Litwin (MCSD, MCP) are your instructors for Microsoft Access 2000 Professional Training via 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 CD-ROMs. In addition, Ken is the author of AppDev�s Visual Basic courseware, videos, and CD-ROMS, and Paul is the author of AppDev�s Visual InterDev and Active Server Pages (ASP) courseware, videos, and CD-ROMs.

Access 2000 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

Access 2000 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

Access 2000 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 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 5

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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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?

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Access 2000 CD-ROM 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

Return to Access Training CD's Main Page

Check out the complete list of AppDev Training

Please Note: All manuals included with the training are in electronic form (PDF files on CD ROM's).

Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

Order ASP CD's

SIMILAR PRODUCTS

Training Tools

AppDev Training

Copyright �2008 HALLoGRAM Publishing, Aurora CO. All Rights Reserved
All products mentioned in this site are trademarks of their respective owners
Prices are subject to change without notice
dmcakegrim