Arvin Meyer, Douglas J. Steele

Access Solutions (eBook, ePUB)

Tips, Tricks, and Secrets from Microsoft Access MVPs

• Format: ePub

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 576
• Erscheinungstermin: 24. September 2010
• Englisch
• ISBN-13: 9780470947548
• Artikelnr.: 37300924

Autorenporträt

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.

Inhaltsangabe

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.