Share

 

Microsoft Access 2000 Course
Available in VHS Video and CD-ROM

About Your Instructor

Alison Balter, your trainer, is a Microsoft Certified Solutions Developer. Not only has she written a number of Access books, but she is also a contributing editor and spokesperson for Advisor Publications. She has instructed numerous people in the private, government and corporate sectors in her 13 years of experience as an independent trainer.


Other Office 2000 CD-ROMs/Videos

Microsoft Word 2000

Microsoft Excel 2000

Microsoft PhotoDraw 2000

Microsoft PowerPoint 2000

Microsoft Front Page 2000

Microsoft Access 2000 Books

Alison Balter's Mastering Microsoft Access 2000 Development
Alison Balter's Mastering Microsoft Access 2000 Development

Teach Yourself Microsoft Access 2000 Visually
Teach Yourself Microsoft Access 2000 Visually

Access 2000 Developer's Handbook>
Access 2000 Developer's Handbook

Microsoft Access 2000 Bible
Microsoft Access 2000 Bible

Special Edition Using Microsoft Access 2000
Special Edition Using Microsoft Access 2000

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development and User Series

by Alison Balter
You'll receive Microsoft Access 2000 Application Development Levels 1-16 and the five user courses. That's a total of 21 tapes for the special price of only $1299.95! That's a savings of $500 off the individual courses!
Covers Microsoft Access 2000
$1299.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Beginning

by Alison Balter
Introduction (26 Minutes): Starting Access;Opening an Existing Database The Access Desktop; The Database Window; A Preview of the Database Components
Working with an Existing Database (33 Minutes): Viewing and Navigating Table Data; Editing Table Data; Adding Records to a Table; Selecting and Deleting Records; Find and Replace; Modifying the Appearance of a Datasheet; Spell-Check and Auto-correct
Form Basics (25 Minutes): Moving from Record to Record; Finding; Sorting; Filtering; AutoForms; Using a Form Wizard; Conditional Formatting
Report Basics (15 Minutes): Moving form Page to Page; Zooming In and Out; Viewing Multiple Pages; Printing; AutoReports & the Report Wizard; Page Setup
Printing Database Objects (5 Minutes): Printing Table Datasheets; Printing Queries; Printing Forms; Printing Reports
Getting Help (8 Minutes): The Office Assistant & Index Searching; Context-Sensitive Help & Printing Help Topics
Database Maintenance & Shortcuts (12 Minutes): Backing Up and Restoring a Database; Compacting and Repairing a Database; Converting a Database to a Previous Version; Organizing Database Objects into Groups
Covers Microsoft Access 2000
2 Hours, 6 Minutes
$59.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Intermediate

by Alison Balter
Planning and Designing a Database (20 Minutes): Evaluating Inputs and Outputs; Normalization; Creating a Database Using a Wizard; Creating a Database from Scratch
Building and Modifying Tables (49 Minutes): Creating Tables Using a Wizard; Creating Tables from Scratch & Data Types; Setting Primary Keys; Field Properties; Input Masks; The Lookup Wizard; Indexes
Working with Relationships (27 Minutes): Introduction to Relationships; Benefits of Relationships; Types of Relationships; Referential Integrity; Indexes and Relationships; Printing Relationships
Designing Simple Queries (27 Minutes): Selecting Fields & Ordering the Query Result; Refining Queries with Criteria; Updatability of Query Results; Queries Based on Multiple Tables
Covers Microsoft Access 2000
2 Hours, 4 Minutes
$59.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Advanced

by Alison Balter
Building and Modifying Forms (51 Minutes): Adding Controls; Selecting Controls; Moving, Sizing and Deleting Controls; Aligning Controls; Changing Control Properties; Changing the Tab Order Controls; Form Properties; Working with Combo Boxes and List Boxes
Building and Modifying Reports (26 Minutes): Understanding Report Bands; Working with Controls; Creating Groups and Totals Reports; Working with Report Properties; Modifying Selection Criteria
Database Startup Options (5 Minutes): Setting the Application, Icon, and Startup Form; Designing other Startup Information
Importing, Exporting and Linking (39 Minutes): Exporting to another Database; Exporting to an Excel Spreadsheet; Exporting to ASCII; Exporting to HTML; Importing from anther Access Database; Importing Spreadsheet Data; Importing ASCII Data; Importing from HTML; Linking to Anther Access Database; Linking to anther types of Database; The Linked Table Manager
Covers Microsoft Access 2000
2 Hours, 3 Minutes
$59.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Expert Topics

by Alison Balter
Advanced Query Design Techniques (58 Minutes): Calculated Fields; Summarizing Data; Excluding Fields; Parameter Queries; Make Table, Append, Update, and Delete Queries; The Find Duplicates Wizard; The Find Unmatched Wizard; Inner & Outer Joins; Self & Union
Advanced Form Design Techniques (37 Minutes): Working with Built-in Tab Control; Working with Headers, Footers and Combo Boxes; Creating Multi-Table Forms and Subforms; Adding OLE Objects to Forms; Using a Bitmap as a Form Background; Adding Calculated Controls to a Form; Other Important Form Control Properties; Creating a Switchboard; Saving a Form as HTML
Advanced Report Design Techniques (19 Minutes): Building Reports with Sub-Reports; Setting Section Properties; Adding Graphics to a Report; Adding / Modifying Calculations
Covers Microsoft Access 2000
1 Hour, 55 Minutes
$59.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Web/Security

by Alison Balter
Access and the Web (23 Minutes): Creating Data Access Pages; Modifying Data Access Page Properties; Modifying Record Navigating Control Properties; Grouping and Sorting Data within Data Access Pages
Charting Table Data (17 Minutes): Using the Chart Wizard; Linking a Chart to a Record
Security Basics (10 Minutes): Establishing a Database Password; Modifying a Database Password; Encrypting and Decrypting a Database
Replication Basics (23 Minutes): Introduction to Replication; Converting a Database to a Design Master; Creating Additional Replicas; Synchronizing Changes; Managing Conflicts
Developing Apps with Macros (29 Minutes): Creating a Macro; Running a Macro; Adding Macro Names; Modifying an Existing Macro; Adding Conditions to a Macro
Special Topics (19 Minutes): Optimizing Data Types Usage; Establishing One-to-One Relationships; Using Add-ins; Report and Form Section Properties
Covers Microsoft Access 2000
2 Hours, 2 Minutes
$59.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 3-Course Series

by Alison Balter
You'll receive Microsoft Access 2000 Beginning, Intermediate and Advanced courses for the special price of only $149.95!!!
Covers Microsoft Access 2000
$149.95US

Phone Order (800) 736-8973

Video Format Info

Return Policy

Microsoft Access 2000 5 Course Series

by Alison Balter
You'll receive Microsoft Access 2000 Beginning, Intermediate and Advanced courses plus Microsoft Access 2000 Expert Topics and Web/Security for the special price of only $249.95!!!
Covers Microsoft Access 2000
$249.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 1

by Alison Balter
Access as a Development Tool (37 Minutes): Types of Applications You Can Develop; What Exactly is a Database; Getting to Know the Database Objects; Object Naming Conventions; Hardware Requirements; Getting Started Developing an Application
Tables (39 Minutes): Building a New Table; Selecting the Appropriate Field Type; Working with Field Properties; The Primary Key; The Lookup Feature; Table Properties; Using Indexes to Improve Performance
Relationships (21 Minutes): Introduction to Relationships; Types of Relationships; Referential Integrity; Benefits of Relationships; Indexes and Relationships
Query Basics (26 Minutes): Query Basics; The Query and Query Result; Refining Queries with Criteria; Updatability of Query Results; Queries Based on Multiple Tables
Covers Microsoft Access 2000
2 Hours, 5 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 2

by Alison Balter
More About Query Basics (28 Minutes): Calculated Fields; Summarizing Data; Excluding Fields; Nulls and Query Results; Field, Field List, and Query Properties; Parameter Queries
Forms (1 Hour 1 Minute): Uses of Forms; Anatomy of a Form; Creating a Form; The Form Design Window; Working with Controls; Form Properties; Control Properties; Bound, Unbound, and Calculated Controls; Command Button Wizards; Forms Based on More than One Table
Reports (35 Minutes): Types of Reports; Anatomy of a Report; Creating a New Report; The Report Design Window; Report Properties; Control Properties; Bound, Unbound, and Calculated Controls; Reports Based on More than One Table; Sorting and Grouping
Covers Microsoft Access 2000
2 Hours, 5 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 3

by Alison Balter
Introduction to VBA (28 Minutes): Why Use VBA; Types of Modules; Anatomy of a Module; Option Explicit; Event Procedures; User-defined Procedures; Scope of Procedures
Working with Variables (16 Minutes): Declaring Variables; Data Types; Scope and Lifetime of Variables
Comments and Line Continuation (5 Minutes): Adding Comments & Line Continuation
Control Structures (11 Minutes): If-Then-Else; Conditional If; Select Case
Looping Constructs (19 Minutes): Do WhileLoop; DoLoop While; Do UntilLoop & DoLoop Until; For Next; WithEnd With; For EachNext
Passing Parameters and Returning Values (9 Minutes): Passing Parameters Positionally; Returning Values
Built-in Functions (16 Minutes): Format; Instr; Left & Right; Mid; Ucase; DatePart, DateDiff & DateAdd; The Object Browser
Working with Constants (9 Minutes): Symbolic Constants; Intrinsic Constants
The Visual Basic Editor (10 Minutes): IntelliSense; The VBE Environment; Customizing the VBE Environment
Covers Microsoft Access 2000
2 Hours, 6 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 4

by Alison Balter
Objects, Properties, Methods, and Events (49 Minutes): The Object Model; Objects, Properties, Methods, and Events Defined; The Object Browser; Referring to Objects; Object Variables; Objects Versus Collections; Passing Objects to Subroutines and Functions; Determining the Type of a Control
Advanced Form Techniques (4 Minutes): Form Events; The Sequence of Form Events; Section and Control Events; Types of Forms; Built-in Dialogs; Menus, Toolbars, and Shortcut Menus
3.0 More Advanced Form Techniques (20 Minutes): Switching a Forms RecordSource; Power Combo and Listbox Techniques; Power Subform Techniques; Synchronizing a Form with its Underlying Recordset
Covers Microsoft Access 2000
2 Hours, 14 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 5

by Alison Balter
Advanced Report Techniques (23 Minutes): Report Events; Sequence of Events; Section Events; Sequence of Section Events; Report Properties
Report Events & Properties (27 Minutes): Changing Reports Record Source; Displaying Summary and Detail Information; Printing Mailing Labels; Determining Mailing Label Positions; Printing Page Headers
Advanced Query Techniques (16 Minutes): Action Queries; Query Properties; Optimizing Queries; Building Cross-tab Queries; Outer Joins and Self Joins; SQL & Union Queries; Passing Parameters Queries
Covers Microsoft Access 2000
2 Hours, 7 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 6

by Alison Balter
ActiveX Data Objects and Data Access Objects Introduced (20 Minutes): Understanding ADO and DAO; ADO versus DAO; The ADO Object Model
ADO Recordset Types (12 Minutes): CursorType; LockType; Options Parameter
Working with ADO Recordset Properties and Methods (28 Minutes): Record-Movement Methods; Detecting Limits of a Recordset; Counting Records in a Recordset; Sorting, Filtering, and Finding Records; AbsolutePosition; The Bookmark Property; Executing Parameterized Queries
Modifying Table Data (19 Minutes): Updating Records using ADO; Deleting Records; Adding Records
Creating and Modifying Database Objects Using Code (15 Minutes): Adding a Table; Removing a Table; Establishing Relationships; Creating Queries
Data Access Objects: A Crash Course (32 Minutes): The DAO Object Hierarchy; DAO Recordset Types; DAO Recordset Properties and Methods; Sorting, Filtering, and Finding using DAO Code; Running a Parameter Query using DAO Code; Modifying Data & Adding & Deleting Records; Creating a Table and other Objects
Covers Microsoft Access 2000
2 Hours, 7 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 7

by Alison Balter
Debugging (56 Minutes): Avoiding Bugs; The Immediate Window; Invoking the Debugger & Breakpoints; Stepping Through Code & Modifying Values; Placing Breakpoints; The Step Over Feature; The Step Out Feature; Setting the Next Statement to Execute; The Call Stack Window; The Locals Window; Watch Expressions
Error Handling (38 Minutes): Implementing Error Handling; Error Events; Using OnError Statements; Resume Statements; Clearing Errors; The Cascading Error Effect; The Error Object; Raising an Error; The Errors Collection
Generic Error Handlers (21 Minutes): Invoking Generic Error Handlers; Logging Errors; Determining the Appropriate Response to an Error; Creating an Error Form
Covers Microsoft Access 2000
1 Hour, 56 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 8

by Alison Balter
Optimizing Your Application (40 Minutes): Optimization - An Overview; Improving Performance with Hardware and Software; Jet 4.0 and Performance; The Performance Analyzer; Designing Tables to Optimize Performance; Designing Queries to Optimize Performance; Making Code Changes to Improve Performance; Designing Forms and Reports to Improve Performance
A Strategy for Application Development (30 Minutes): Splitting Tables and Other Objects; Basing Forms and Reports on Queries; The Access Runtime Engine; Preparing an Application for Distribution; EXE versus Database; The Importance of Security; Access as a Front-end
Developing Multi-user Applications (36 Minutes): Developing with Multi-users in Mind; Access Locking Mechanisms; Locking and Refresh Strategies; Form & Other Locking Strategies; Recordset Locking; Effectively Handling Locking Conflicts; More on Locking Conflicts & Refresh versus Re-query; Understanding the LDB File; Other Multi-user Strategies
Using External Data (29 Minutes): External Data, Importing, Linking, and Opening; Selecting Options; Importing External Data; Creating a Link to External Data; Opening an External Table; Refreshing and Removing Links
Covers Microsoft Access 2000
2 Hours, 16 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 9

by Alison Balter
Client/Server Techniques (1 Hour 18 Minutes): Client/Server - An Introduction; The Client/Server Model; Client/Server Buzz Words; Preparing for Upsizing; The Upsizing Wizard; Defining an ODBC Data Source; Connecting to a Database Server; Building a Client/Server Application from the Get Go
Client/Server Strategies (22 Minutes): Selecting the Best Recordset Type; Pass-through Queries and Stored Procedures; Using Access Data Projects; Optimizing Data Handling; Optimizing Queries and Forms
Client/Server Application (18 Minutes): Creating a Client/Server Application Using Linked Tables; Creating a Client/Server Application Using an Access Data Projects
Covers Microsoft Access 2000
1 Hour, 59 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 10

by Alison Balter
Transactions (18 Minutes): What is Transaction Processing?; Implementing Explicit Transaction Processing; Looking at Transaction Processing Issues; Transaction Processing in a Multi-user Environment
Replication (44 Minutes): Uses of Replication; Implementation of Replication; The Replication Architecture; Replication Topologies; Changes Replication Makes to the Database & Making a Database Replicable; Creating Additional Replicas; Synchronizing Replicas & Resolving Replication Conflicts; Partial Replication; Implementing Replication Using Code
The Replication Manager (30 Minutes): Running the Replication Manager for the First Time; Replicating a Database with the Replication Manager; Creating Replicas with the Replication Manager; Synchronizing with the Replication Manager & Reviewing the History; Synchronization Properties
Covers Microsoft Access 2000
1 Hour, 44 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 11

by Alison Balter
Advanced VBA Techniques (1 Hour): User-Defined Types; Working with Constants; Working with Arrays; Advanced Function Techniques; Working with Empty and Null; Creating and Working with Custom Collections; Compilation Options; Importing and Exporting Code Modules; Project Properties
Using ActiveX Controls (52 Minutes): ActiveX Controls Explained; Incorporating ActiveX Controls; Setting ActiveX Control Properties at Design Time; Coding Events of an ActiveX Control; The Calendar Control; The UpDown Control; The StatusBar Control; The Common Dialog Control; The Rich Textbox Control; The TabStrip Control; The ImageList Control
Covers Microsoft Access 2000
1 Hour, 54 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 12

by Alison Balter
Automation: Communicating with Other Applications (1 Hour 2 Minutes): Automation Terms; Declaring an Object Variable; Creating an Automation Object; Manipulating an Automation Object; Controlling Excel from Access & Closing an Excel Automation Object; Creating a Graph from Access; Controlling Word from Access; Controlling PowerPoint from Access; Controlling Access from Other Applications
Exploiting the Power of the Windows API (50 Minutes): Declaring an External Function to the Compiler; Working with Constants and Types & Calling DLL's; Using API Functions
Covers Microsoft Access 2000
1 Hour, 53 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 13

by Alison Balter
Exploiting the Power of Class Modules (59 min): Exploring the Benefits of Class Modules; Object Orientation An Introduction; Creating and Using a Class Module; Creating Multiple Class Instances; The Initialize and Terminate Events; Class Module Examples; Working with Custom Collections
Creating Your Own Libraries (17 Minutes): Preparing a Database to be a Library; Creating a Reference; Debugging a Library Database; Securing an Access Library
Builders, Wizards, and Menu Add-Ins (40 Minutes): Using Builders; Using Wizards
Covers Microsoft Access 2000
2 Hours, 2 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 14

by Alison Balter
Access and the Internet (46 Minutes): What's New with Access and the Internet; Saving Database Objects as HTML; Linking to HTML Files; Importing HTML Files; Deciding Between Static and Dynamic HTML Formats; Working with Active Server Pages; Testing ASP Files; Working with HTX/IDC Files; Working with HTML Templates
Data Access Pages (50 Minutes): Understanding Data Access Pages; Creating Data Access Pages; Modifying Important Properties of a Data Access Page; Modifying Record Navigation Control Properties; Creating Grouped Data Access Pages; Modifying Properties to Change Behavior; Augmenting Data Access Pages with VBScript
Covers Microsoft Access 2000
1 Hour, 37 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 15

by Alison Balter
Security (1 Hour 5 Minutes): Share-Level Security; Encrypting a Database; User-level Security: An Introduction; Creating a Workgroup; Changing the Password for Admin; Setting Up an Administrative User; Securing a Database; Creating Users and Groups; Assigning Rights to Users and Groups; Creating an MDE File; Special Issues
Advanced Security (45 Minutes): Maintaining Groups Using Code; Using Code to Maintain Users; Listing Users and Groups; Working with Passwords; Accomplishing Field-level Security Using Queries
Covers Microsoft Access 2000
1 Hour, 51 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Level 16

by Alison Balter
Documenting Your Application (25 Minutes): Preparing Your Application to be Self-Documenting; Using the Database Documenter; Writing Code to Create Documentation
Maintaining Your Application (16 Minutes): Compacting & Repairing Your Database
The Microsoft Office Developer (26 Minutes): Distributing Your Application; Looking at the MOD
Managing the Development Process with Visual SourceSafe (21 Minutes): Installing Visual SourceSafe; Using Visual SourceSafe
Distributing Your Application (36 Minutes): Introducing the Package and Deployment Wizard; Loading the Package and Deployment Wizard; Distributing an Application to Run with a Full Copy of Access; Using Full Versus Runtime Versions of Access; Preparing a Database for Use with the Runtime
Covers Microsoft Access 2000
2 Hours, 6 Minutes
$99.95US

Phone Order (800) 736-8973

Return Policy

Microsoft Access 2000 Application Development Series

by Alison Balter
You'll receive Microsoft Access 2000 Application Development Levels 1-16 for the special price of only $1159.95!!!
Covers Microsoft Access 2000
$1159.95US

Discover More Training Solutions at Graphics Unleashed


Last Updated Wednesday March 21 2007.

delicious Bookmark this page on del.icio.us digg Digg this page on digg.com reddit Submit this page on reddit.com technorati Search Technorati for links to page

Beauty Unleashed · Books Unleashed · Digital Cameras Unleashed · DVDs Unleashed
Electronics Unleashed · Gourmet Food Unleashed · Health and Personal Care Unleashed · Kitchen Unleashed · Jewelry Unleashed
Magazines Unleashed · Music Unleashed · Posters Unleashed · Software Unleashed
Sporting Goods Unleashed · Tools and Hardware Unleashed · Toys Unleashed · Video Games Unleashed · Videos Unleashed

Copyright © 1995–2009 Unleashed Productions, Inc., All Rights Reserved.