Skip to content

Access Hacks Tips and Tools for Wrangling Your Data

Spend $50 to get a free DVD!

ISBN-10: 0596009240

ISBN-13: 9780596009243

Edition: 2005

Authors: Ken Bluttman

List price: $34.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!

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is "Access Hacks from O'Reilly. This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, "Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next…    
Customers also bought

Book details

List price: $34.99
Copyright year: 2005
Publisher: O'Reilly Media, Incorporated
Publication date: 4/27/2005
Binding: Paperback
Pages: 351
Size: 5.75" wide x 8.50" long x 0.75" tall
Weight: 1.056
Language: English

James R. Troyer is professor emeritus of botany at North Carolina State University.

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