Access Solutions Tips, Tricks, and Secrets from Microsoft Access MVPs
by Meyer, Arvin; Steele, Douglas J.Edition: 1st
Format: Paperback
Pub. Date: 2010-10-12
Publisher(s): Wiley
Other versions by this Author
List Price: $49.99
Buy New
Special Order. We will make every effort to obtain this item but cannot guarantee stock or timing.
$49.94
Rent Book
Select for Price
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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.
Author Biography
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.
Table of Contents
| 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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.