Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

Wiley
Wiley.com
Print this page Share

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

ISBN: 978-0-470-59168-0
576 pages
October 2010
Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs (0470591684) cover image
Two Microsoft Access MVPs show how you can become an Access power user
  • Microsoft 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 eager users make Access the most popular database system in the world
    These Microsoft MVPs exploit key features in Access, providing advice on techniques for capturing, sharing and reporting Access data.
  • Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web site

Access 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.

See More
Acknowledgments.

Introduction.

Part I Tables 1.

Tip 1 Creating Tables for Web Applications.

Tip 2 Alternative to the Hyperlink Data Type.

Tip 3 Fill a Table with Numbers.

Part II Queries.

Tip 4 A Single Query to Do Both Updates and Insertions.

Tip 5 Using a Cartesian Product to Generate a Calendar.

Tip 6 Using a Multiselect List Box as a Query Parameter.

Part III Forms.

Tip 7 Cascading Combo Boxes.

Tip 8 Cascading Combo Boxes on Continuous Forms.

Tip 9 Paired List Boxes.

Tip 10 Marquees, Scrolling Messages, and Flashing Labels.

Tip 11 Custom Tab Controls.

Tip 12 Simulating Web-Style "Hover" Buttons.

Tip 13 Custom Form Navigation Controls.

Tip 14 Calendar Form.

Tip 15 Simulating Drag-and-Drop in Access Forms.

Tip 16 Providing Visual Feedback for Drag-and-Drop.

Tip 17 Control List Boxes with Drag-and-Drop.

Part IV Taking Advantage of Report Capabilities.

Tip 18 Page 1 of N for Groups.

Tip 19 Always Starting a Group on an Odd Page for Duplex Printing.

Tip 20 Dynamically Changing the Sort Order of a Report.

Tip 21 Week-at-a-Glance–Type Report.

Tip 22 Day-at-a-Glance-Type Report.

Part V Using VBA.

Tip 23 Useful String Functions.

Tip 24 Useful Functions.

Tip 25 Relinking Front-End Databases to Back-End Databases in the Same Folder.

Tip 26 SaveAsText and LoadFromText: Undocumented Backup and Anti-Corruption Tricks.

Tip 27 Reminders—Building Tickler Forms and Utilities.

Tip 28 Using Disconnected Recordsets.

Tip 29 Implementing Soundex.

Part VI Automating Applications and ActiveX Controls.

Tip 30 Charting Using Excel.

Tip 31 Using the TreeView Control.

Tip 32 Using the ListView Control.

Tip 33 Adding Images to the TreeView Control.

Tip 34 Using the TreeView and ListView Controls Together.

Part VII Access and the Web.

Tip 35 Building an Access Web Application.

Tip 36 Embedding a Web Control in a Form.

Tip 37 Building a Time Picker in a Web Form: An Introduction to Web Macros.

Tip 38 RSS Feeds.

Tip 39 Detecting Whether You've Got Internet Connectivity.

Part VIII Utilities.

Tip 40 Drilling Down to Data.

Tip 41 Utility for Renaming a Form's Controls.

Tip 42 Document Management Using Access.

Tip 43 Ultra-Fast Searching.

Index.

See More

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.

See More
Download TitleSizeDownload
ReadMe File 784 bytes Click to Download
9780470591680: Access Solutions Full Code Download 9.32 MB Click to Download
Tip 1: Creating Tables for Web Applications 20.63 KB Click to Download
Tip 2: Alternative to the Hyperlink Data Text 277.65 KB Click to Download
Tip 3: Fill a Table with Numbers 41.34 KB Click to Download
Tip 4: A Single Query to Do Both Updates and Insertions 76.64 KB Click to Download
Tip 5: Using a Cartesian Product to Generate a Calendar 65.88 KB Click to Download
Tip 6: Using a Multiselect List Box as a Query Parameter 1.17 MB Click to Download
Tip 7: Cascading Combo Boxes 81.56 KB Click to Download
Tip 8: Cascading Combo Boxes on Continuous Forms 78.02 KB Click to Download
Tip 9: Paired List Boxes 110.77 KB Click to Download
Tip 10: Marquees, Scrolling Messages, and Flashing Labels 56.19 KB Click to Download
Tip 11: Custom Tab Controls 447.97 KB Click to Download
Tip 12: Simulating Web-Style "Hover" Buttons 32.98 KB Click to Download
Tip 13: Custom Form Navigation Controls 80.87 KB Click to Download
Tip 14: Calendar Form 64.75 KB Click to Download
Tip 15: Simulating Drag-and-Drop in Access Forms 94.16 KB Click to Download
Tip 16: Providing Visual Feedback for Drag-and-Drop 110.41 KB Click to Download
Tip 17: Control List Boxes with Drag-and-Drop 125.88 KB Click to Download
Tip 18: Page 1 of N for Groups 82.42 KB Click to Download
Tip 19: Always Starting a Group on an Odd Page for Duplex Printing 97.90 KB Click to Download
Tip 20: Dynamically Changing the Sort Order of a Report 560.38 KB Click to Download
Tip 21: Week-at-a-Glance-Type Report 90.14 KB Click to Download
Tip 22: Day-at-a-Glance-Type Report 83.23 KB Click to Download
Tip 23: Useful String Functions 114.28 KB Click to Download
Tip 24: Useful Functions 112.37 KB Click to Download
Tip 25: Relinking Front-End Databases to Back-End Databases in the Same Folder 675.63 KB Click to Download
Tip 26: SaveAsText and LoadFromText: Undocumented Backup and Anti-Corruption Tricks 167.48 KB Click to Download
Tip 27: Reminders: Building Tickler Forms and Utilities 59.79 KB Click to Download
Tip 28: Using Disconnected Recordsets 109.82 KB Click to Download
Tip 29: Implementing Soundex 299.03 KB Click to Download
Tip 30: Charting Using Excel 116.61 KB Click to Download
Tip 31: Using the TreeView Control 90.81 KB Click to Download
Tip 32: Using the ListView Control 459.29 KB Click to Download
Tip 33: Adding Images to the TreeView Control 419.29 KB Click to Download
Tip 34: Using the TreeView and ListView Controls Together 447.12 KB Click to Download
Tip 35: Building an Access Web Application 1.07 MB Click to Download
Tip 36: Embedding a Web Control in a Form 31.13 KB Click to Download
Tip 37: Building a Time Picker in a Web Form: An Introduction to Web Macros 592.77 KB Click to Download
Tip 38: RSS Feeds 239.05 KB Click to Download
Tip 39: Detecting Whether You've Got Internet Connectivity 43.28 KB Click to Download
Tip 40: Drilling Down to Data 162.06 KB Click to Download
Tip 41: Utility for Renaming a Form's Controls 46.84 KB Click to Download
Tip 42: Document Management Using Access 96.39 KB Click to Download
Tip 43: Ultra-Fast Searching 278.43 KB Click to Download
See More
Buy Both and Save 25%!
+

Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs (US $49.99)

-and- Beginning Microsoft SQL Server 2012 Programming (US $39.99)

Total List Price: US $89.98
Discounted Price: US $67.48 (Save: US $22.50)

Buy Both
Cannot be combined with any other offers. Learn more.
Back to Top