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

by ;
  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2010-10-12
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $16.40
  • Rent Book $44.99
    Add to Cart Free Shipping


Supplemental Materials

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 Rental copy of this book is 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.


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

Tables 1
Creating Tables for Web Applications
Alternative to the Hyperlink Data Type
Fill a Table with Numbers
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
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
Drilling Down to Data
Utility for Renaming a Form's Controls
Document Management Using Access
Ultra-Fast Searching
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review