Access Solutions Tips, Tricks, and Secrets

Two Microsoft Access MVPs show how you can become an Access power userMicrosoft Access is the world's leading database system, with millions of users and hundreds of thousands of developers. The best practices, tips, and techniques in this book can turn users into power users. Millions of users are eager to make the most of Access, the most popular database system in the world These Microsoft MVPs examine every feature of Access 2010, providing advice on each core area of Access and techniques for capturing, sharing and reporting Access data across the full suite of Microsoft Office applications Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web siteAccess 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.

Arvin Meyer is Chief Database Architect at Data Strategies and a 10-year Microsoft MVP. He also performs Webmaster duties for The Access Web (www.mvps.org/access), the major Access FAQ resource in the world with over 35,000 hits daily. He is one of the technical editors of Microsoft Access Small Business Solutions, published by Wiley.

Douglas J. Steele has been an Access MVP since 1999. He has written about Access for Smart Access magazine, Advisor Media, and Database Journal, and is technical editor for the Access 2010 Bible, published by Wiley.

Acknowledgments
Introduction
Tables 1
Creating Tables for Web Applications
Alternative to the Hyperlink Data Type
Fill a Table with Numbers
Queries
A Single Query to Do Both Updates and Insertions
Using a Cartesian Product to Generate a Calendar
Using a Multiselect List Box as a Query Parameter
Forms
Cascading Combo Boxes
Cascading Combo Boxes on Continuous Forms
Paired List Boxes
Marquees, Scrolling Messages, and Flashing Labels
Custom Tab Controls
Simulating Web-Style "Hover" Buttons
Custom Form Navigation Controls
Calendar Form
Simulating Drag-and-Drop in Access Forms
Providing Visual Feedback for Drag-and-Drop
Control List Boxes with Drag-and-Drop
Taking Advantage of Report Capabilities
Page 1 of N for Groups
Always Starting a Group on an Odd Page for Duplex Printing
Dynamically Changing the Sort Order of a Report
Week-at-a-Glance-Type Report
Day-at-a-Glance-Type Report
Using VBA
Useful String Functions
Useful Functions
Relinking Front-End Databases to Back-End Databases in the Same Folder
SaveAsText and LoadFromText: Undocumented Backup and Anti-Corruption Tricks
Reminders-Building Tickler Forms and Utilities
Using Disconnected Recordsets
Implementing Soundex
Automating Applications and ActiveX Controls
Charting Using Excel
Using the TreeView Control
Using the ListView Control
Adding Images to the TreeView Control
Using the TreeView and ListView Controls Together
Access and the Web
Building an Access Web Application
Embedding a Web Control in a Form
Building a Time Picker in a Web Form: An Introduction to Web Macros
RSS Feeds
Detecting Whether You've Got Internet Connectivity
Utilities
Drilling Down to Data
Utility for Renaming a Form's Controls
Document Management Using Access
Ultra-Fast Searching
Index
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Access Solutions Tips, Tricks, and Secrets from Microsoft Access MVPs

Summary

Author Biography

Table of Contents

Supplemental Materials