Microsoft Access Programming Training
Access Developer XP Training Videos or CD-ROMs
 This set of training videos are designed to teach you how to develop applications
for Access XP. Alison Balter is a Microsoft Certified Instructor who will take you step-by-step through the training. Videos or CDs can be ordered individually by
application need or you may order the complete set for your reference library at a considerable savings.
Microsoft Access XP Programming for Developer 2002 Training Videos
|
Level 1 Video
|
kyacdx1
|
$99.95
|
|
|
Level 2 Video
|
kyacdx2
|
$99.95
|
|
|
Level 3 Video
|
kyacdx3
|
$99.95
|
|
|
Level 4 Video
|
kyacdx4
|
$99.95
|
|
|
Level 5 Video
|
kyacdx5
|
$99.95
|
|
|
Level 6 Video
|
kyacdx6
|
$99.95
|
|
|
Level 7 Video
|
kyacdx7
|
$99.95
|
|
|
Level 8 Video
|
kyacdx8
|
$99.95
|
|
|
Level 9 Video
|
kyacdx9
|
$99.95
|
|
|
Level 10 Video
|
kyacdxx
|
$99.95
|
|
|
Level 11 Video
|
kyacdxx1
|
$99.95
|
|
|
Level 12 Video
|
kyacdxx2
|
$99.95
|
|
|
Level 13 Video
|
kyacdxx3
|
$99.95
|
|
|
Level 14 Video
|
kyacdxx4
|
$99.95
|
|
|
Level 15 Video
|
kyacdxx5
|
$99.95
|
|
|
Set of 15 Access Developer XP 2002 Videos Levels 1-15 details
|
kyacdxa
|
$1199.95
|
|
Access Developer Training CD-ROMs
|
Level 1 CD
|
kyacdx1m
|
$99.95
|
|
|
Level 2 CD
|
kyacdx2m
|
$99.95
|
|
|
Level 3 CD
|
kyacdx3m
|
$99.95
|
|
|
Level 4 CD
|
kyacdx4m
|
$99.95
|
|
|
Level 5 CD
|
kyacdx5m
|
$99.95
|
|
|
Level 6 CD
|
kyacdx6m
|
$99.95
|
|
|
Level 7 CD
|
kyacdx7m
|
$99.95
|
|
|
Level 8 CD
|
kyacdx8m
|
$99.95
|
|
|
Level 9 CD
|
kyacdx9m
|
$99.95
|
|
|
Level 10 CD
|
kyacdxxm
|
$99.95
|
|
|
Level 11 CD
|
kyacdxx1m
|
$99.95
|
|
|
Level 12 CD
|
kyacdxx2m
|
$99.95
|
|
|
Level 13 CD
|
kyacdxx3m
|
$99.95
|
|
|
Level 14 CD
|
kyacdxx4m
|
$99.95
|
|
|
Level 15 CD
|
kyacdxx5m
|
$99.95
|
|
|
Set of 15 Access Developer XP 2002 CDs Levels 1-15 details
|
kyacdxam
|
$1199.95
|
|
Microsoft Access XP Developer 2002 Training Videos or CDs
Level 1
1.0Access as a Development Tool
1.1Why This Section is Important
1.2What Types of Applications Can You Develop in Access?
1.3Access as a Scalable Product
1.4What Exactly Is a Database?
1.5Getting to Know the Database Objects
1.6Object Naming Conventions
1.7Hardware Requirements
1.8How Do I Get Started Developing an Access Application?
2.0What Every Developer Needs to Know about Tables
2.1Why This Section is Important
2.2Building a New Table
2.3Selecting the Appropriate Field Type for Your Data
2.4Working with Field Properties
2.5The All-Important Primary Key
2.6Working with Table Properties
2.7Using Indexes to Improve Performance
top
Level 2
1.0Relationships: Your Key to Data Integrity
1.1Why this Section is Important
1.2Introduction to Database Design
1.3Establishing Relationships in Access
1.4Establishing Referential Integrity
1.5Looking at the Benefits of Relationships
1.6Examining Indexes & Relationships
2.0What Every Developer Needs to Know about Query Basics
2.1Why this Section is Important?
2.2What Is a Query & When Should You Use One?
2.3Everything You Need to Know about Query Basics
2.4Ordering Your Query Result
2.5Refining Your Query with Criteria
2.6Working with Dates in Criteria
2.7Understanding How Query Results Can Be Updated
2.8Building Queries Based on Multiple Tables
2.9Creating Calculated Fields
2.10Getting Help from the Expression Builder
2.11Summarizing Data with Totals Queries
2.12Excluding Fields from the Output
2.13Nulls & Query Results
2.14Refining Your Queries with Field, Field List, & Query Properties
2.15Building Parameter Queries When You Don't Know the Criteria at Design Time
top
Level 3
1.0What Every Developer Needs to Know about Forms: Basics
1.1Why This Section is Important
1.2Uses of Forms
1.3Anatomy of a Form
1.4Creating a New Form
1.5Working with the Form Design Window
1.6Selecting the Correct Control for the Job
1.7Control Morphing
1.8Conditional Formatting
1.9What Form Properties Are Available & Why Use Them?
1.10What Control Properties Are Available & Why Use Them?
2.0What Every Developer Needs to Know about Forms: Beyond the Basics
2.1Why This Section is Important
2.2Bound, Unbound, & Calculated Controls
2.3Using Expressions to Enhance Your Forms
2.4The Command Button Wizards: Programming Without Typing
2.5Building Forms Based on More Than One Table
2.6Basing Forms on Queries: The Why & How
2.7Access Forms & the Internet
top
Level 4
1.0What Every Developer Needs to Know about Reports
1.1Why this Section it Important
1.2Types of Reports Available
1.3Anatomy of a Report
1.4Creating a New Report
1.5Working with the Report
Design Window
1.6Selecting the Correct
Control for the Job
1.7What Report Properties Are Available & Why Use Them?
1.8What Control Properties Are Available & Why Use Them?
1.9Inserting Page Breaks
1.10Unbound, Bound, & Calculated Controls
1.11Using Expressions to Enhance Your Reports
1.12Building Reports Based on More Than One Table
1.13Working with Sorting & Grouping
1.14Basing Reports on Stored Queries versus Embedded SQL Statements
1.15Access Reports & the Internet
top
Level 5
1.0VBA: An Introduction
1.1Why this Section is Important
1.2VBA Explained
1.3What Are Access Class Modules, Standard Modules, Form Modules, & Report Modules?
1.4Working with Variables
1.5Adding Comments to Your Code
1.6Using the Line Continuation Character
1.7Using the VBA Control Structures
1.8Passing Parameters &
Returning Values
1.9Executing Procedures from the Module Window
1.10The DoCmd Object: Performing Macro Actions
1.11Working with Built-In Functions
1.12Working with Constants
1.13Tools for Working in the Visual Basic Editor
1.14Customizing the VBE
top
Level 6
1.0Objects, Properties, Methods, & Events Explained
1.1Why This Section is Important
1.2Understanding Objects, Properties, Events, & Methods
1.3Using the Object Browser to Learn About Access's Objects
1.4Referring to Objects
1.5Properties & Methods Made Easy
1.6Declaring & Assigning Object Variables
1.7Understanding the Differences Between Objects & Collections
1.8Passing Objects to Subroutines
& Functions
1.9 Determining the Type of a Control
1.10Special Properties That Refer to Objects
1.11Understanding Access's Object Model
1.12New Access 2002 Properties
top
Level 7
1.0Advanced Form Techniques
1.1Why This Section Is Important
1.2What Are the Form Events & When Do You Use Them?
1.3What Are the Section & Control Events & When Do You Use Them?
1.4Referring to Me
1.5What Types of Forms Can I Create & When Are They Appropriate?
1.6Using Built-In Dialog Boxes
1.7Adding Custom Menus, Toolbars, & Shortcut Menus to Your Forms
1.8Taking Advantage of Built-In Form-Filtering Features
1.9Including Objects from Other Applications: Linking Versus Embedding
1.10OpenArgs
1.11Switching a Form's Record Source
1.12Power Combo Box & List Box Techniques
1.13Power Sub-form Techniques
1.14Synchronizing a Form with Its Underlying Recordset
1.15Creating Custom Properties & Methods
top
Level 8
1.0Advanced Report Techniques
1.1Why This Section Is Important
1.2Events Available for Reports & When to Use Them
1.3Order of Events for Reports
1.4Events Available for Report Sections & When to Use Them
1.5Programmatically Manipulating Report Sections
1.6Special Report Properties
1.7Controlling the Printer
1.8Practical Examples of Report Events & Properties
top
Level 9
1.0Advanced Query Techniques
1.1Why this Section is Important
1.2Action Queries
1.3Special Query Properties
1.4Optimizing Queries
1.5Crosstab Queries
1.6Outer Joins
1.7Self Joins
1.8Understanding SQL
1.9Union Queries
1.10Pass-Through Queries
1.11The Propagation of Nulls & Query Results
1.12Subqueries
1.13Using SQL to Update Data
1.14Using SQL for Data Definition
1.15Using the Result of a Function as the Criteria for a Query
1.16Passing Parameter Query Values from a Form
1.17 Jet 4.0 ANSI-92 Extensions
top
Level 10
1.0Advanced VBA Techniques
1.1Why This Section Is Important
1.2What Are User-Defined Types & Why Would You Use Them?
1.3Working with Constants
1.4Working with Arrays
1.5Advanced Function Techniques
1.6Working with Empty & Null
1.7Creating & Working with Custom Collections
1.8Low-level File Handling
1.9Understanding & Effectively Using Compilation Options
1.10Importing & Exporting Code Modules
1.11Working with Project Properties
top
Level 11
1.0Exploiting the Power of Class Modules
1.1Exploring the Benefits of Class Modules
1.2Object Orientation-An Introduction
1.3Creating & Using a Class Module
1.4Setting Values with Property Set
1.5Creating Multiple Class Instances
1.6The Initialize & Terminate Events
1.7Working with Enumerated Types
1.8Building Hierarchies of Classes
1.9Adding a Parent Property to Classes
1.10The Implements Keyword
1.11Working with Custom Collections
1.12Adding Your Own Events
1.13Practical Examples of Class Modules
top
Level 12
1.0What Are ActiveX Data Objects & Why Are They Important?
1.1Understanding ActiveX Data Objects & Data Access Objects
1.2Using ActiveX Data Objects Versus Data Access Objects
1.3Examining the ActiveX Data
Object Model
1.4Understanding ADO
Recordset Types
1.5Working with ADO Recordset Properties & Methods
1.6Modifying Table Data
Using ADO Code
1.7Creating & Modifying Database Objects Using ADO Code
2.0What Are Data Access Objects & Why Are They Important?
2.1Examining the Data Access
Object Model
2.2Getting to Know DBEngine
2.3Using CurrentDB()
2.4Understanding DAO
Recordset Types
2.5Selecting Among the Types of DAO Recordset Objects Available
2.6Working with DAO Recordset Properties & Methods
2.7Modifying Table Data
Using DAO Code
2.8Creating & Modifying Database Objects Using DAO Code
2.9Using the DAO Containers Collection
top
Level 13
1.0Debugging: Your Key to Successful Development
1.1Why This Section is Important
1.2Avoiding Bugs
1.3Harnessing the Power of the Immediate Window
1.4Invoking the Debugger
1.5Using Breakpoints to Troubleshoot
1.6Stepping Through Code
1.7Setting the Next Statement to Execute
1.8Using the Calls Window
1.9Working with the Locals Window
1.10Working with Watch Expressions
1.11Continuing Execution After a Runtime Error
1.12Looking At Gotchas with the Immediate Window
1.13Using Assertions
1.14Debugging Tips
2.0Error Handling: Preparing for the Inevitable
2.1Why This Section Is Important
2.2Implementing Error Handling
2.3Using On Error Statements
2.4Using Resume Statements
2.5Clearing an Error
2.6Examining the Cascading Error Effect
2.7Using the Err Object
2.8Raising an Error
2.9Using the Errors Collection
2.10Creating a Generic Error Handler
2.11Preventing Your Own Error Handling from Being Invoked
2.12Creating a Call Stack
2.13Building a Custom Error Handler Class
2.14Working with Error Events
2.15Creating a List of Error Codes & Descriptions
top
Level 14
1.0Using ActiveX Controls
1.1Why this Section is Important
1.2Incorporating ActiveX Controls in Access 2002
1.3Setting Properties of an ActiveX Control at Design Time
1.4Coding Events of an ActiveX Control
1.5Using the Calendar Control
1.6Using the UpDown Control
1.7Using the StatusBar Control
1.8Using the Common Dialog Control
1.9Using the Rich Textbox Control
1.10Using the TabStrip Control
1.11Using the ImageList Control
1.12Licensing & Distribution Issues
2.0Automation: Communicating with Other Applications
2.1Why This Section Is Important
2.2Defining Some Automation Terms
2.3Declaring an Object Variable to Reference Your Application
2.4Creating an Automation Object
2.5Manipulating an Automation Object
2.6Early Binding Versus Late Binding
2.7Controlling Excel from Access
2.8Closing an Excel Automation Object
2.9Creating a Graph from Access
2.10Controlling Word from Access
2.11Controlling PowerPoint from Access
2.12Automating Outlook from Access
2.13Controlling Access from Other Applications
top
Level 15
1.0Optimizing Your Application
1.1Why This Section Is Important
1.2 Introducing Optimization
1.3 Modifying Hardware & Software Configurations
1.4What Jet 3.5 Did to Improve Performance
1.5Understanding What Jet 4.0 Does to Improve Performance
1.6Letting the Performance Analyzer Determine Problem Areas
1.7Designing Tables to Optimize Performance
1.8Designing Queries to Optimize Performance
1.9Making Coding Changes to Improve Performance
1.10Designing Forms & Reports to Improve Performance
2.0Documenting Your Application
2.1Why This Section Is Important
2.2Preparing Your Application to Be Self-Documenting
2.3Using the Database Documenter
2.4Writing Code to Create Your Own Documentation
3.0Maintaining Your Application
3.1Why This Section Is Important
3.2Compacting Your Database
3.3Converting an Access Database
3.4Detecting Broken References
|
