Skip to content

Mastering Microsoft Access 2000 Development

Spend $50 to get a free DVD!

ISBN-10: 0672314843

ISBN-13: 9780672314841

Edition: 1999

Authors: Alison Balter

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Alison's book takes a highly technical topic and presents it in a manner that is easy to comprehend. You'll want to read it from cover to cover, but it can also act as an excellent reference. Learn thorough knowledge of Access application development, real-world solutions to specific development and programming problems, and professional programming techniques backed by concise, no-nonsense explanations of the underlying theories. Debugging and troubleshooting methods are also included.
Customers also bought

Book details

List price: $49.99
Copyright year: 1999
Publisher: Sams
Publication date: 6/26/1999
Binding: Mixed Media
Pages: 1392
Size: 7.25" wide x 9.25" long x 2.00" tall
Weight: 4.994
Language: English

Introduction
The Basics of Access Development
Access as a Development Tool
What Types of Applications Can You Develop in Access?
Access as a Scalable Product
What Exactly Is a Database?
Getting to Know the Database Objects
Object Naming Conventions
Hardware Requirements
How Do I Get Started Developing an Access Application?
Summary
What Every Developer Needs to Know About Tables
Building a New Table
Selecting the Appropriate Field Type for Your Data
Working with Field Properties
The All-Important Primary Key
Working with the Lookup Feature
Working with Table Properties
Using Indexes to Improve Performance
Access Tables and the Internet
Summary
Relationships: Your Key to Data Integrity
Examining the Types of Relationships
Establishing Relationships
Establishing Referential Integrity
Looking at the Benefits of Relationships
Examining Indexes and Relationships
Summary
What Every Developer Needs to Know About Query Basics
What Is a Query and When Should You Use One?
Everything You Need to Know About Query Basics
Ordering Your Query Result
Refining Your Query with Criteria
Working with Dates in Criteria
Understanding How Query Results Can Be Updated
Building Queries Based on Multiple Tables
Creating Calculated Fields
Getting Help from the Expression Builder
Summarizing Data with Totals Queries
Excluding Fields from the Output
Nulls and Query Results
Refining Your Queries with Field, Field List, and Query Properties
Building Parameter Queries When You Don't Know the Criteria at Design Time
Summary
What Every Developer Needs to Know About Forms
Uses of Forms
Anatomy of a Form
Creating a New Form
Working with the Form Design Window
Selecting the Correct Control for the Job
Control Morphing
Conditional Formatting
What Form Properties Are Available and Why Use Them?
What Control Properties Are Available and Why Use Them?
Bound, Unbound, and Calculated Controls
Using Expressions to Enhance Your Forms
The Command Button Wizards: Programming Without Typing
Building Forms Based on More Than One Table
Basing Forms on Queries: The Why and How
Access Forms and the Internet
Summary
What Every Developer Needs to Know About Reports
Types of Reports Available
Anatomy of a Report
Creating a New Report
Working with the Report Design Window
Selecting the Correct Control for the Job
What Report Properties Are Available and Why Use Them
What Control Properties Are Available and Why Use Them
Inserting Page Breaks
Unbound, Bound, and Calculated Controls
Using Expressions to Enhance Your Reports
Building Reports Based on More Than One Table
Working with Sorting and Grouping
Improving Performance and Reusability by Basing Reports on Stored Queries
Access Reports and the Internet
Summary
VBA: An Introduction
VBA Explained
What Are Access Class Modules, Standard Modules, Form Modules, and Report Modules?
Working with Variables
Adding Comments to Your Code
Using the Line Continuation Character
Using the VBA Control Structures
Passing Parameters and Returning Values
Executing Procedures from the Module Window
The DoCmd Object: Performing Macro Actions
Working with Built-In Functions
Working with Constants
Tools for Working in the Visual Basic Editor
Customizing the VBE
Summary
Objects, Properties, Methods, and Events Explained
Understanding Access's Object Model
Understanding Objects, Properties, Events, and Methods
Using the Object Browser to Learn About Access's Objects
Referring to Objects
Properties and Methods Made Easy
Declaring and Assigning Object Variables
Understanding the Differences Between Objects and Collections
Passing Objects to Subroutines and Functions
Determining the Type of a Control
Special Properties That Refer to Objects
Summary
Advanced Form Techniques
Why This Chapter Is Important
What Are the Form Events and When Do You Use Them?
What Are the Section and Control Events and When Do You Use Them?
Referring to Me
What Types of Forms Can I Create and When Are They Appropriate?
Using Built-In Dialog Boxes
Adding Custom Menus, Toolbars, and Shortcut Menus to Your Forms
Taking Advantage of Built-In Form-Filtering Features
Including Objects from Other Applications: Linking Versus Embedding
OpenArgs
Switching a Form's Record Source
Power Combo Box and List Box Techniques
Power Subform Techniques
Synchronizing a Form with Its Underlying Recordset
Creating Custom Properties and Methods
Summary
Advanced Report Techniques
Why This Chapter Is Important
Events Available for Reports and When to Use Them
Order of Events for Reports
Events Available for Report Sections and When to Use Them
Special Report Properties
Practical Applications of Report Events and Properties
Summary
Advanced Query Techniques
Action Queries
Special Query Properties
Optimizing Queries
Crosstab Queries
Outer Joins
Self Joins
Understanding SQL
Union Queries
Pass-Through Queries
The Propagation of Nulls and Query Results
Subqueries
Using the Result of a Function as the Criteria for a Query
Passing Parameter Query Values from a Form
Summary
What Are ActiveX Data Objects and Data Access Objects and Why Are They Important?
Understanding Data Access Objects
Using ActiveX Data Objects Versus Data Access Objects
Examining the ActiveX Data Object Model
Understanding ADO Recordset Types
Working with ADO Recordset Properties and Methods
Modifying Table Data Using ADO Code
Creating and Modifying Database Objects Using ADO Code
Examining the Data Access Object Model
Getting to Know DBEngine
Using CurrentDB()
Understanding DAO Recordset Types
Selecting Among the Types of DAO Recordset Objects
Working with DAO Recordset Properties and Methods
Modifying Table Data Using DAO Code
Creating and Modifying Database Objects Using DAO Code
Using the DAO Containers Collection
Summary
What to Do When Things Don't Go as Planned
Debugging: Your Key to Successful Development
Avoiding Bugs
Harnessing the Power of the Immediate Window
Invoking the Debugger
Using Breakpoints to Troubleshoot
Stepping Through Code
Setting the Next Statement to Execute
Using the Calls Window
Working with the Locals Window
Working with Watch Expressions
Continuing Execution After a Runtime Error
Looking At Gotchas with the Immediate Window
Summary
Error Handling: Preparing for the Inevitable
Why This Chapter Is Important
Implementing Error Handling
Working with Error Events
Using On Error Statements
Using Resume Statements
Clearing an Error
Examining the Cascading Error Effect
Using the Err Object
Raising an Error
Using the Errors Collection
Creating a Generic Error Handler
Preventing Your Own Error Handling from Being Invoked
Summary
Optimizing Your Application
Why This Chapter Is Important
Introducing Optimization
Modifying Hardware and Software Configurations
Understanding What Jet 4.0 Does to Improve Performance
Letting the Performance Analyzer Determine Problem Areas
Designing Tables to Optimize Performance
Designing Queries to Optimize Performance
Making Coding Changes to Improve Performance
Designing Forms and Reports to Improve Performance
Summary
Developing Multiuser and Enterprise Applications
A Strategy to Developing Access Applications
Why This Chapter Is Important
Splitting Databases into Tables and Other Objects
Basing Forms and Reports on Queries or Embedded SQL Statements
Understanding the Access Runtime Engine
Using an EXE Versus Access Database: What It Means to You
Understanding the Importance of Securing Your Database
Using Access as a Front End
Summary
Developing Multiuser Applications
Designing Your Application with Multiuser Issues in Mind
Understanding Access's Locking Mechanisms
Locking and Refreshing Strategies
Form Locking Strategies
Recordset Locking
Effectively Handling Locking Conflicts
Testing a Record for Locking Status
Using Code to Refresh or Requery
Understanding the LDB File
The User Roster
Creating Custom Counters
Using Unbound Forms
Using Replication to Improve Performance
Summary
Using External Data
Why This Chapter Is Important
Importing, Linking, and Opening: When and Why
Importing External Data
Creating a Link to External Data
Opening an External Table
Understanding Windows Registry Settings
Using the Jet OLEDB: Link Provider String
Working with Passwords
Refreshing and Removing Links
Looking at Special Considerations
Troubleshooting
Looking at Performance Considerations and Links
Working with HTML Documents
Summary
Client/Server Techniques
Understanding the Client/Server Model
Deciding Whether to Use the Client/Server Model
The Roles Access Plays in the Application Design Model
Learning the Client/Server Buzzwords
Upsizing: What to Worry About
Proactively Preparing for Upsizing
Using the Upsizing Wizard
Defining an ODBC Data Source
Connecting to a Database Server
Working with Linked Tables
Using Pass-Through Queries
Executing and Creating Stored Procedures
Using a Microsoft Access Data Project to Access Client/Server Data
Summary
Client/Server Strategies
Why This Chapter Is Important
Selecting the Best Recordset Type
Using Pass-Through Queries and Stored Procedures
Using Access Data Projects
Optimizing Data Handling
Optimizing Queries and Forms
Summary
A Client/Server Application in Action
Why This Chapter Is Important
Creating a Client/Server Application Using Linked Tables
Creating a Client/Server Application Using an Access Data Project
Summary
Transaction Processing
Why This Chapter Is Important
Understanding the Benefits
Modifying the Default Behavior
Implementing Explicit Transaction Processing
Looking at Transaction Processing Issues
Using Transaction Processing in a Multiuser Environment
Using Transaction Processing in a Client/Server Environment
Summary
Replication Made Easy
Why This Chapter Is Important
Uses of Replication
Understanding When Replication Isn't Appropriate
Understanding the Implementation of Replication
Understanding the Replication Architecture: What Makes Replication Tick?
Understanding Replication Topologies
Changes That Replication Makes to Your Database
Making a Database Replicable
Preventing Objects from Being Replicated
Creating Additional Replicas
Synchronizing Replicas
Resolving Replication Conflicts
Using the Replication Manager
Using Partial Replication
Implementing Replication Using Code
Summary
Black-Belt Programming
Advanced VBA Techniques
Why This Chapter Is Important
What Are User-Defined Types and Why Would You Use Them?
Working with Constants
Working with Arrays
Advanced Function Techniques
Working with Empty and Null
Creating and Working with Custom Collections
Understanding and Effectively Using Compilation Options
Importing and Exporting Code Modules
Working with Project Properties
Summary
Using ActiveX Controls
ActiveX Controls Explained
Incorporating ActiveX Controls in Access 2000
Setting Properties of an ActiveX Control at Design Time
Coding Events of an ActiveX Control
Using the Calendar Control
Using the UpDown Control
Using the StatusBar Control
Using the Common Dialog Control
Using the Rich Textbox Control
Using the TabStrip Control
Using the ImageList Control
Licensing and Distribution Issues
Summary
Automation: Communicating with Other Applications
Why This Chapter Is Important
Defining Some Automation Terms
Declaring an Object Variable to Reference Your Application
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
Summary
Exploiting the Power of the Windows API
Why This Chapter Is Important
Declaring an External Function to the Compiler
Working with Constants and Types
Calling DLL Functions: Important Issues
Examining the Differences Between 16-Bit and 32-Bit APIs
Using API Functions
Getting Information About the Operating Environment
Determining Drive Types and Available Drive Space
Summary
Exploiting the Power of Class Modules
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
Working with Custom Collections
Summary
Creating Your Own Libraries
Why This Chapter Is Important
Preparing a Database to Be a Library
Creating a Reference
Debugging a Library Database
Securing an Access Library
Summary
Using Builders, Wizards, and Menu Add-Ins
Why This Chapter Is Important
Using Builders
Using Wizards
Using Menu Add-Ins
Summary
Access and the Internet
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 (.ASP Files)
Working with HTX/IDC Files
Testing ASP and HTX/IDC Files
Working with HTML Templates
Sending Data to an FTP or HTTP Server
Taking Advantage of Hyperlinks
Introducing the Web Toolbar
Implementing Replication Over the Internet
Summary
Using Data Access Pages
Understanding Data Access Pages
Creating Data Access Pages
Modifying Important Properties of a Data Access Page
Modifying the Record Navigation Control Properties
Creating Grouped Data Access Pages
Augmenting Data Access Pages with VBScript
Summary
Adding Polish to Your Application
Database Security Made Easy
Why This Chapter Is Important
Implementing Share-Level Security: Establishing a Database Password
Encrypting a Database
Establishing User-Level Security
Providing an Additional Level of Security: Creating an MDE
Looking at Special Issues
Summary
Advanced Security Techniques
Why This Chapter Is Important
Maintaining Groups Using Code
Using Code to Maintain Users
Listing All Groups and Users
Working with Passwords
Assigning and Revoking Permissions to Objects Using Code
Encrypting a Database Using Code
Accomplishing Field-Level Security Using Queries
Prohibiting Users and Groups from Creating Objects
Accomplishing Prohibited Tasks by Logging On as a Different User
Securing Client/Server Applications
Security and Replication
Summary
Documenting Your Application
Why This Chapter Is Important
Preparing Your Application to Be Self-Documenting
Using the Database Documenter
Writing Code to Create Your Own Documentation
Summary
Maintaining Your Application
Why This Chapter Is Important
Compacting Your Database
Summary
Microsoft Office Developer
Distributing Your Application: An Introduction
Looking at MOD
Summary
Managing Application Development with Visual SourceSafe
Why This Chapter Is Important
How Do I Install Visual SourceSafe?
Using Visual SourceSafe: An Overview
The Logistics of Managing a Project with Visual SourceSafe
Leveraging the Power of Visual SourceSafe
Changes Visual SourceSafe Makes to Access's Behavior
Getting Help for Visual SourceSafe
Understanding the Limitations of Visual SourceSafe
Summary
Distributing Your Application
Why This Chapter Is Important
Introducing the Package and Deployment Wizard
Loading the Package and Deployment Wizard Add-In
Distributing Your Application to Run with a Full Copy of Access
Using Full Versions Versus Runtime Versions of Access
Preparing Your Database for Use with the Access Runtime Version
Looking at Other Issues
Summary
Appendixes
Table Structures
The tblClients Table
The tblCompanyInfo Table
The tblEmployees Table
The tblErrorLog Table
The tblErrors Table
The tblExpenseCodes Tables
The tblPaymentMethods Table
The tblPayments Table
The tblProjects Table
The tblTimCardExpenses Table
The tblTimeCardHours Table
The tblTimeCards Table
The tblWorkCodes Table
Naming Conventions
Index