| |
| |
| Credits | |
| |
| |
| Preface | |
| |
| |
| |
| Core Access | |
| |
| |
| |
| Help Users Find the Objects They Need | |
| |
| |
| |
| Personalize Your Access Application | |
| |
| |
| |
| Work Fast and Avoid Typos | |
| |
| |
| |
| Optimize Data Changes | |
| |
| |
| |
| Transfer Data Between Versions of Access | |
| |
| |
| |
| Organize and Enhance Your Macros | |
| |
| |
| |
| Rid Your Database of Clutter | |
| |
| |
| |
| Protect Valuable Information | |
| |
| |
| |
| Work with Any Amount of Data | |
| |
| |
| |
| Find Database Objects in a Snap | |
| |
| |
| |
| Use a Junction Table | |
| |
| |
| |
| Stop the Database from Growing | |
| |
| |
| |
| Tables | |
| |
| |
| |
| Create an AutoNumber Field with a Custom Value | |
| |
| |
| |
| Copy Data Between Tables Without an Append Query | |
| |
| |
| |
| Steer Clear of System Tables | |
| |
| |
| |
| Hide Sensitive Information | |
| |
| |
| |
| Simulate Table Triggers | |
| |
| |
| |
| Create Tables Faster | |
| |
| |
| |
| Entry and Navigation | |
| |
| |
| |
| Help Users Navigate Through Long Forms | |
| |
| |
| |
| Help Users Enter Additional Text | |
| |
| |
| |
| Let Users Add Custom Items to Predesigned Lists | |
| |
| |
| |
| Populate and Sort Lists with Flair | |
| |
| |
| |
| Use Custom Controls on Your Forms | |
| |
| |
| |
| Confirm Record Updates Before Saving | |
| |
| |
| |
| Put a Clock on a Form | |
| |
| |
| |
| Be Tab-Smart | |
| |
| |
| |
| Highlight the Active Control | |
| |
| |
| |
| Presentation | |
| |
| |
| |
| Separate Alphabetically Sorted Records into Letter Groups | |
| |
| |
| |
| Create Conditional Subtotals | |
| |
| |
| |
| Use Conditional Formatting to Point Out Important Results | |
| |
| |
| |
| Provide a Direct Link to a Report | |
| |
| |
| |
| Protect Intellectual Property | |
| |
| |
| |
| Create a Slideshow in Access | |
| |
| |
| |
| Play Videos in Access Forms | |
| |
| |
| |
| View Reports Embedded in Forms | |
| |
| |
| |
| Put Line Numbers on a Report | |
| |
| |
| |
| Shade Alternating Lines on a Report | |
| |
| |
| |
| Save Paper by Reducing Whitespace | |
| |
| |
| |
| Include the Date, Time, and Page Count | |
| |
| |
| |
| Queries and SQL | |
| |
| |
| |
| Return a Sample of Records | |
| |
| |
| |
| Create Bulletproof Insert Operations | |
| |
| |
| |
| Find Unmatched Records on Multiple Field Keys | |
| |
| |
| |
| Place a Grand Total in a Query | |
| |
| |
| |
| Sort Any Arbitrary String of Characters | |
| |
| |
| |
| Summarize Complex Data | |
| |
| |
| |
| Get All Combinations of Data | |
| |
| |
| |
| Don''t Let Nulls Ruin Data Summaries | |
| |
| |
| |
| Use a Custom Function in a Query | |
| |
| |
| |
| Create Access Tables with SQL Server Scripts | |
| |
| |
| |
| Use Wildcards in Queries | |
| |
| |
| |
| Get Cleaner Or-Based Criteria | |
| |
| |
| |
| Get Cleaner And-Based Criteria | |
| |
| |
| |
| Create an Outer Join | |
| |
| |
| |
| Use Regular Expressions in Access Queries | |
| |
| |
| |
| Multiuser Issues | |
| |
| |
| |
| Test for Duplication | |
| |
| |
| |
| Distribute a Split Database with Predefined Table Links | |
| |
| |
| |
| Build a Time-Out Feature | |
| |
| |
| |
| Implement Unique Usernames | |
| |
| |
| |
| External Programs and Data | |
| |
| |
| |
| Import Noncontiguous Ranges of Data from Excel | |
| |
| |
| |
| Use Excel to Reorient Access Data | |
| |
| |
| |
| Use Excel Functions Inside Access | |
| |
| |
| |
| Use Word to Compare Data in Two Access Tables | |
| |
| |
| |
| Import Varied XML Data into Access | |
| |
| |
| |
| Export XML Data Sanely | |
| |
| |
| |
| Break Through VBA''s Transformation Barrier | |
| |
| |
| |
| Leverage SQL Server Power by Calling Stored Procedures | |
| |
| |
| |
| Manage Word Documents from Access | |
| |
| |
| |
| Use Access as a Front End to MySQL | |
| |
| |
| |
| Send Access Data Through Outlook Automatically | |
| |
| |
| |
| Create Access Tables from Outside Access | |
| |
| |
| |
| Write VBA with the Macro Recorder in Word and Excel | |
| |
| |
| |
| Programming | |
| |
| |
| |
| Store Initial Control Selections for Later Recall | |
| |
| |
| |
| Write Code Faster by Turning Off Syntax-Checking | |
| |
| |
| |
| Substitute Domain Aggregate Functions for SQL Aggregate Functions | |
| |
| |
| |
| Shrink Your Code with Subroutines | |
| |
| |
| |
| Shrink Your Code with Optional Arguments | |
| |
| |
| |
| Protect Programming Code from Curious Users | |
| |
| |
| |
| Build a Secret Developer Backdoor into Your Applications | |
| |
| |
| |
| Help Users Drill Down to a Record | |
| |
| |
| |
| Prevent Users from Disabling Your Startup Options | |
| |
| |
| |
| Inform Users of a Long Process | |
| |
| |
| |
| Allow Users to Choose a Back-End Database | |
| |
| |
| |
| Override the Timeout Interval | |
| |
| |
| |
| Save Values from Unbound Controls for Later Recall | |
| |
| |
| |
| Sort Records Randomly | |
| |
| |
| |
| Bulk-Update Controls on a Form | |
| |
| |
| |
| Provide Complete XML Control to Any Version of Access | |
| |
| |
| |
| Use Custom Enumerations | |
| |
| |
| |
| Convert Text to the Desired Case | |
| |
| |
| |
| Create a Code Library | |
| |
| |
| |
| Automatically Check for Database Table Updates | |
| |
| |
| |
| Third-Party Applications | |
| |
| |
| |
| Document Your Database with Total Access Analyzer | |
| |
| |
| |
| Build an Application Shell with EZ Application Generator | |
| |
| |
| |
| Load Your Database with Test Data | |
| |
| |
| |
| Use Access as an XML Database | |
| |
| |
| |
| The Internet | |
| |
| |
| |
| Export a Report as HTML | |
| |
| |
| |
| Use a Browser Inside Access | |
| |
| |
| |
| Pull the HTML Source Code from a Web Site | |
| |
| |
| |
| Download Files Using the Web Browser Control | |
| |
| |
| |
| Use a Smart Tag to Open a Web Page | |
| |
| |
| Index | |