| |
| |
| |
| Building a Foundation for Your Access Applications | |
| |
| |
| |
| Introduction to Access Development | |
| |
| |
| What Types of Applications Can You Develop in Access? | |
| |
| |
| 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 | |
| |
| |
| |
| A Strategy for Developing Access Applications | |
| |
| |
| Why Strategize? | |
| |
| |
| Splitting Tables and Other Objects | |
| |
| |
| Basing Forms and Reports on Queries | |
| |
| |
| Understanding the Access Runtime Engine | |
| |
| |
| Resource | |
| |
| |
| EXE Versus Access Database: What It Means to You | |
| |
| |
| The Importance of Securing Your Database | |
| |
| |
| Using Access as a Front-End | |
| |
| |
| Applying the Strategy to the Computer Consulting Firm 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 | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Required: Make the User Enter a Value | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Indexed: Speeding Up Searches | |
| |
| |
| Try It | |
| |
| |
| The All-Important Primary Key | |
| |
| |
| Working with the Lookup Feature | |
| |
| |
| Working with Table Properties | |
| |
| |
| Using Indexes to Improve Performance | |
| |
| |
| Access Tables and the Internet | |
| |
| |
| Practical Examples: Designing the Tables Needed for the Computer Consulting Firm's Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Relationships: Your Key to Data Integrity | |
| |
| |
| Understanding Relationships | |
| |
| |
| Examining the Types of Relationships | |
| |
| |
| Establishing Relationships | |
| |
| |
| Try It | |
| |
| |
| Establishing Referential Integrity | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Looking At the Benefits of Relationships | |
| |
| |
| Examining Indexes and Relationships | |
| |
| |
| Practical Examples: Establishing the Relationships Between the Tables Included in the Time and Billing Database | |
| |
| |
| 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 Selecting Fields | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Ordering Your Query Result | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Working with Dates in Criteria | |
| |
| |
| Understanding How Query Results Can Be Updated | |
| |
| |
| Building Queries Based on Multiple Tables | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Creating Calculated Fields | |
| |
| |
| Try It | |
| |
| |
| Getting Help from the Expression Builder | |
| |
| |
| Summarizing Data with Totals Queries | |
| |
| |
| Try It | |
| |
| |
| Excluding Fields from the Output | |
| |
| |
| Nulls and Query Results | |
| |
| |
| Refining Your Queries with Field and Query Properties | |
| |
| |
| Field List Properties | |
| |
| |
| Building Parameter Queries When You Don't Know the Criteria at Design Time | |
| |
| |
| Try It | |
| |
| |
| Practical Examples: Building Queries Needed by the Time and Billing Application for the Computer Consulting Firm | |
| |
| |
| Summary | |
| |
| |
| |
| What Every Developer Needs to Know About Form Basics | |
| |
| |
| 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 | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Designing Forms for Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| What Every Developer Needs to Know About Report Basics | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Building Reports Needed for Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| VBA 101: The Basics of VBA | |
| |
| |
| VBA Explained | |
| |
| |
| Access Class Modules, Standard Modules, Form Modules, and Report Modules Explained | |
| |
| |
| Working with Variables | |
| |
| |
| Adding Comments to Your Code | |
| |
| |
| Using the Line-Continuation Character | |
| |
| |
| Using the VBA Control Structures | |
| |
| |
| Passing Parameters and Returning Values: An Introduction | |
| |
| |
| Working with Built-In Functions | |
| |
| |
| Tools for Working with the Module Window | |
| |
| |
| Practical Examples: Event Routines, User-Defined Functions, and Subroutines Needed for the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Advanced VBA Techniques | |
| |
| |
| Navigation Tips and Tricks | |
| |
| |
| Executing Procedures from the Module Window | |
| |
| |
| The DoCmd Object: Performing Macro Actions | |
| |
| |
| What Are User-Defined Types and Why Would You Use Them? | |
| |
| |
| Working with Constants | |
| |
| |
| Working with Arrays | |
| |
| |
| Advanced Function Techniques | |
| |
| |
| Property Let and Get: Working with Custom Properties | |
| |
| |
| Class Modules | |
| |
| |
| Working with Empty and Null | |
| |
| |
| Understanding and Effectively Using Compilation Options | |
| |
| |
| Customizing the IDE | |
| |
| |
| Practical Examples: Putting Advanced Techniques to Use in the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| The Real Scoop on Objects, Properties, and Events | |
| |
| |
| Understanding Access's Object Model | |
| |
| |
| The Forms Collection | |
| |
| |
| 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 | |
| |
| |
| Using the New Keyword | |
| |
| |
| Passing Objects to Functions and Subroutines | |
| |
| |
| Returning to a Unique Item in a Collection | |
| |
| |
| Determining the Type of a Control | |
| |
| |
| Special Properties That Refer to Objects | |
| |
| |
| Practical Examples of Working with Objects | |
| |
| |
| Summary | |
| |
| |
| |
| What Are Macros and When Do You Need Them? | |
| |
| |
| Why Learning About Macros Is Important | |
| |
| |
| The Basics of Creating and Running a Macro | |
| |
| |
| Running an Access Macro | |
| |
| |
| Try It | |
| |
| |
| Modifying and Existing Macro | |
| |
| |
| Documenting Your Macro: Adding Comments | |
| |
| |
| Testing a Macro | |
| |
| |
| Try It | |
| |
| |
| When You Should Use Macros and When You Shouldn't | |
| |
| |
| Converting a Macro to VBA Code | |
| |
| |
| Creating an AutoExec Macro | |
| |
| |
| Creating an AutoKeys Macro | |
| |
| |
| The DoCmd Object | |
| |
| |
| Practical Examples: Adding an AutoExec Macro to the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Advanced Query Concepts | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Applying These Techniques in Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| Let's Get More Intimate with Forms: Advanced Techniques | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Applying Advanced Techniques to Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| Let's Get More Intimate with Reports: Advanced Techniques | |
| |
| |
| 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 | |
| |
| |
| Practical Examples | |
| |
| |
| Summary | |
| |
| |
| |
| What Are the Data Access Objects and Why Are They Important? | |
| |
| |
| Understanding Data Access Objects | |
| |
| |
| Examining the Data Access Object Model | |
| |
| |
| Getting to Know DBEngine | |
| |
| |
| Using CurrentDB() | |
| |
| |
| Understanding Recordset Types | |
| |
| |
| Selecting Among the Types of Recordset Objects Available | |
| |
| |
| Working with Recordset Properties and Methods | |
| |
| |
| Modifying Table Data Using Code | |
| |
| |
| Creating and Modifying Database Objects Using Code | |
| |
| |
| Using the Containers Collection | |
| |
| |
| Practical Examples: Applying These Techniques to Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| What To Do When Things Don't Go As Planned | |
| |
| |
| |
| Debugging: Your Key to Successful Development | |
| |
| |
| Understanding the Importance of Debugging | |
| |
| |
| Avoiding Bugs | |
| |
| |
| Harnessing the Power of the Debug Window | |
| |
| |
| Invoking the Debugger | |
| |
| |
| Using Breakpoints to Troubleshoot | |
| |
| |
| Try It | |
| |
| |
| Stepping Through Code | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Try It | |
| |
| |
| Using Step Out | |
| |
| |
| Try It | |
| |
| |
| Setting the Next Statement to Execute | |
| |
| |
| Try It | |
| |
| |
| Using the Calls Window | |
| |
| |
| Try It | |
| |
| |
| Working with the Locals Pane | |
| |
| |
| Working with Watch Expressions | |
| |
| |
| Try It | |
| |
| |
| Continuing Execution After a Runtime Error | |
| |
| |
| Looking At Gotchas with the Debug Window | |
| |
| |
| Practical Examples: Debugging Real Applications | |
| |
| |
| Summary | |
| |
| |
| |
| Handling Those Dreaded Runtime Errors | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Incorporating Error Handling | |
| |
| |
| Summary | |
| |
| |
| |
| Preparing Your Applications for a Multiuser Environment | |
| |
| |
| |
| Developing for a Multiuser Environment | |
| |
| |
| 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 | |
| |
| |
| Creating Custom Counters | |
| |
| |
| Using Unbound Forms | |
| |
| |
| Using Replication to Improve Performance | |
| |
| |
| Practical Examples: Making an Application Multiuser Ready | |
| |
| |
| Summary | |
| |
| |
| |
| Using External Data | |
| |
| |
| Understanding External Data | |
| |
| |
| 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 Connection String | |
| |
| |
| Working with Passwords | |
| |
| |
| Refreshing and Removing Links | |
| |
| |
| Creating an External Table | |
| |
| |
| Looking At Special Considerations | |
| |
| |
| Troubleshooting | |
| |
| |
| Looking At Performance Considerations and Links | |
| |
| |
| Working with HTML Documents | |
| |
| |
| Practical Examples: Working with External Data from within Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| Client/Server Techniques | |
| |
| |
| Understanding the Client/Server Model | |
| |
| |
| Deciding Whether to Use the Client/Server Model | |
| |
| |
| Roles Access Plays in the Application Design Model | |
| |
| |
| Learning the Client/Server Buzzwords | |
| |
| |
| Upsizing: What to Worry About | |
| |
| |
| Proactively Preparing for Upsizing | |
| |
| |
| Defining an ODBC Data Source | |
| |
| |
| Connecting to a Database Server | |
| |
| |
| Working with Linked Tables | |
| |
| |
| Summary | |
| |
| |
| |
| Client/Server Strategies | |
| |
| |
| Developing Client/Server Strategies | |
| |
| |
| Selecting the Best Recordset Type | |
| |
| |
| Using Forward-Scrolling Snapshots | |
| |
| |
| Using Key Set Fetching | |
| |
| |
| Using Pass-Through Queries and Stored Procedures | |
| |
| |
| Using ODBCDirect | |
| |
| |
| Preconnecting to the Server | |
| |
| |
| Reducing the Number of Connections | |
| |
| |
| Optimizing Data Handling | |
| |
| |
| Optimizing Queries and Forms | |
| |
| |
| Practical Examples: Using Client/Server Strategies | |
| |
| |
| Summary | |
| |
| |
| |
| Transaction Processing | |
| |
| |
| Understanding Transaction Processing | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Improving the Integrity of the Time and Billing Application Using Transaction Processing | |
| |
| |
| Summary | |
| |
| |
| |
| Optimizing Your Application | |
| |
| |
| Understanding Optimization | |
| |
| |
| Modifying Hardware and Software Configurations | |
| |
| |
| Understanding What Jet 3.5 Does to Improve Performance | |
| |
| |
| Letting the Performance Analyzer Determine Problem Areas | |
| |
| |
| Designing Tables to Optimize Performance | |
| |
| |
| Designing Queries to Optimize Performance | |
| |
| |
| Changing Code to Improve Performance | |
| |
| |
| Designing Forms and Reports to Improve Performance | |
| |
| |
| Practical Examples: Improving the Performance of the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Replication Made Easy | |
| |
| |
| What Is Replication? | |
| |
| |
| Uses of Replication | |
| |
| |
| Understanding When Replication Isn't Appropriate | |
| |
| |
| An Overview of the Implementation of Replication | |
| |
| |
| 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 | |
| |
| |
| Implementing Replication by Using Code | |
| |
| |
| Practical Examples: Managing the Time and Billing Application with Replication | |
| |
| |
| Summary | |
| |
| |
| |
| Extending the Power of Access | |
| |
| |
| |
| Automation: Communicating with Other Applications | |
| |
| |
| Understanding Automation | |
| |
| |
| Defining Some Automation Terms | |
| |
| |
| Declaring an Object Variable to Reference Your Application | |
| |
| |
| Using CreateObject and GetObject | |
| |
| |
| Manipulating an Automation Object | |
| |
| |
| Controlling Excel from Access | |
| |
| |
| Closing an Automation Object | |
| |
| |
| Creating a Graph from Access | |
| |
| |
| Controlling Word from Access | |
| |
| |
| Controlling PowerPoint from Access | |
| |
| |
| Controlling Access from Other Applications | |
| |
| |
| Practical Examples: Using Automation to Extend the Functionality of the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Using ActiveX Controls | |
| |
| |
| ActiveX Controls Explained | |
| |
| |
| Incorporating ActiveX Controls in Access 97 | |
| |
| |
| Adding ActiveX Controls to Forms | |
| |
| |
| Setting Properties of an ActiveX Control at Design Time | |
| |
| |
| Coding Events of an ActiveX Control | |
| |
| |
| The Calendar Control | |
| |
| |
| The UpDown Object | |
| |
| |
| The StatusBar Control | |
| |
| |
| The Common Dialog Control | |
| |
| |
| The Rich Textbox Control | |
| |
| |
| The TabStrip Control | |
| |
| |
| The ImageList Control | |
| |
| |
| Licensing and Distribution Issues | |
| |
| |
| Practical Examples: Implementing ActiveX Controls | |
| |
| |
| 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 | |
| |
| |
| Static Versus Dynamic HTML Formats | |
| |
| |
| The Publish to the Web Wizard | |
| |
| |
| Working with HTML Templates | |
| |
| |
| Sending Data to an FTP or HTTP Server | |
| |
| |
| Taking Advantage of Hyperlinks | |
| |
| |
| The Microsoft WebBrowser Control | |
| |
| |
| The Web Toolbar | |
| |
| |
| Replication Over the Internet | |
| |
| |
| Summary | |
| |
| |
| |
| Managing Application Development with Visual SourceSafe | |
| |
| |
| What Is Visual SourceSafe? | |
| |
| |
| 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 | |
| |
| |
| Understanding the Limitations of Visual SourceSafe | |
| |
| |
| Practical Examples: Putting the Time and Billing Application Under SourceSafe Control | |
| |
| |
| Summary | |
| |
| |
| |
| Leveraging Your Application: Creating Your Own Libraries | |
| |
| |
| Understanding Library Databases | |
| |
| |
| Preparing a Database to Be a Library | |
| |
| |
| Creating a Reference | |
| |
| |
| Debugging a Library Database | |
| |
| |
| Securing an Access Library | |
| |
| |
| Practical Examples: Building a Library for Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| Using Builders, Wizards, and Menu Add-Ins | |
| |
| |
| Defining Builders, Wizards, and Menu Add-Ins, Builders | |
| |
| |
| Using Builders | |
| |
| |
| Using Wizards | |
| |
| |
| Using Menu Add-Ins | |
| |
| |
| Practical Examples: Designing Your Own Add-Ins | |
| |
| |
| Summary | |
| |
| |
| |
| Putting the Final Polish on Your Application | |
| |
| |
| |
| Using External Functions: The Windows API | |
| |
| |
| Using the Win32 API | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Applying What You Have Learned to the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Database Security Made Easy | |
| |
| |
| Reviewing Your Options for Securing a Database | |
| |
| |
| Implementing Share-Level Security: Establishing a Database Password | |
| |
| |
| Encrypting a Database | |
| |
| |
| Establishing User-Level Security | |
| |
| |
| Providing an Additional Level of Security: Creating an MDE File | |
| |
| |
| Looking At Special Issues | |
| |
| |
| Practical Examples: Securing the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Complex Security Issues | |
| |
| |
| Controlling Security Via Code | |
| |
| |
| Maintaining Groups Using Code | |
| |
| |
| Maintaining Users Using Code | |
| |
| |
| Listing All Groups and Users | |
| |
| |
| Working with Passwords | |
| |
| |
| Assigning and Revoking Permissions to Objects Using Code | |
| |
| |
| Encrypting a Database By Using Code | |
| |
| |
| Accomplishing Field-Level Security By Using Queries | |
| |
| |
| Prohibiting Users from Creating Objects | |
| |
| |
| Accomplishing Prohibited Tasks By Logging on a Different User | |
| |
| |
| Securing Client/Server Applications | |
| |
| |
| Examining Security and Replication | |
| |
| |
| Practical Examples: Applying Advanced Techniques to Your Application | |
| |
| |
| Summary | |
| |
| |
| |
| Documenting Your System | |
| |
| |
| Understanding Why You Should Document | |
| |
| |
| Preparing Your Application to Be Self-Documenting | |
| |
| |
| Using Database Properties to Document the Overall Database | |
| |
| |
| Using the Database Documenter | |
| |
| |
| Writing Code to Create Your Own Documentation | |
| |
| |
| Practical Examples: Applying What You Learned to the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Database Maintenance Techniques | |
| |
| |
| Understanding What Database Maintenance Is All About | |
| |
| |
| Compacting Your Database | |
| |
| |
| Repairing Your Database | |
| |
| |
| Summary | |
| |
| |
| |
| Developing a Help File | |
| |
| |
| Deciding To Create a Help File | |
| |
| |
| Looking at Help from a User's Perspective | |
| |
| |
| Planning the Help File | |
| |
| |
| Building the Help Components | |
| |
| |
| Adding Custom Help to Your Applications | |
| |
| |
| Getting Help with Help: Authoring Tools | |
| |
| |
| Practical Examples: Adding Help to the Time and Billing Application | |
| |
| |
| Summary | |
| |
| |
| |
| Distributing Your Application with ODE | |
| |
| |
| Distributing Your Application: An Introduction | |
| |
| |
| Looking At the ODE | |
| |
| |
| 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 | |
| |
| |
| Practical Examples: Distributing the Time and Billing Application | |
| |
| |
| 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 tblTimeCardExpenses Table | |
| |
| |
| The tblTimeCardHours Table | |
| |
| |
| The tblTimeCards Table | |
| |
| |
| The tblWorkCodes Table | |
| |
| |
| |
| Naming Conventions | |
| |
| |
| Index | |