Publications
- Smart Access
Articles and sample files for the intermediate / advanced user - Data Based Advisor
The successor to Access / VBA / SQL Advisor – some good articles on Access for sale
Links
Tools and Utilities
- FMS, Inc.
World-class Access add-ins and utilities - Black Moshannon Systems
Speed Ferret search-and-replace utility - Code-VB Help Generator
Neat tool to give you a jump start on building HTML help files for your Access Application. - SnagIt
The best screen-capture and editing software.
Forums & Newsgroups
- Support Groups on Yahoo:
MS Access Professionals
Access Dev
MS Access - Microsoft Newsgroups
Check out the Access and SQL Server newsgroups organized by topics. Answers by MVP designates (including me!) and other experts. Find Access under Desktop Applications and SQL Server under Servers. - Utter Access forum
Microsoft® Access, Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online help discussion forums. - CompuServe MSDevApps forum
Expert advice from Team Access. You don’t have to be a member of CompuServe to post questions and browse answers as a “guest.”
White Papers & KB Articles
- http://www.fmsinc.com/tpapers/math/index.html
Math calculation – a detailed white paper on math calculation problems in Access. - http://support.microsoft.com?kbid=279334
Is your database hopelessly corrupted? Get help here (Access 97 version with links to 2000 and XP). - http://support.microsoft.com?kbid=194374
Common functions not working (Format, Date, etc)? Get help here. - http://support.microsoft.com?kbid=174217
DLLs not registering during a Runtime install? Get help here. - http://support.microsoft.com?kbid=254372
Confused about Access Security? Get help here.
Other Resources
- Access Team Blog
All the latest news from the Microsoft Office Access development team. - The Access Junkie
Great tips from Jeff Conrad – the “Access Junkie.” - FMS Home Page
Lots of other goodies besides the white papers and utilities listed here in the links section. - For Mere Mortals
Check out other books in the Mere Mortals series here. - MCW Technologies
You’ll find the authors of the Sybex “Developers Handbook” series here! - The Access Web
Chock full of goodies contributed by Access MVPs. You’ll find a ton of hot tips gleaned from the newsgroups here. - ACG Soft
Tips, Freeware, and cool Access add-ins here. - MVP Web Sites
Links to the web sites of other Microsoft MVPs. - Steven Leban’s Home Page
Cool code from another Access MVP. - Allen Browne’s Access tips
Good info for beginners and advanced developers. - Tips from Tony Toews
Another great resource from an Access MVP.
Downloads
- HousingCmbUserIDNotInList.txt
Corrected code for the NotInList event procedure for the cmbUserID combo box on frmSignon in the Housing sample database for both Microsoft Office Access 2003 Inside Out and Microsoft Office Access 2007 Inside Out: - UnderstandingSQL.doc
Confused about SQL in Microsoft Access? Download this Appendix from Microsoft Office Access 2003 Inside Out to get all the details. - ACC97hlp.zip
Longing for the wonderful help files that were available with Access 97? Download the file below, unzip it into a folder, and set a link on your desktop to acMain80.hlp. - AppendixDDoc.zip
Additional info for SQL Queries for Mere Mortals: We added specific instructions for working with SQL Server to the second printing of the book. To download the new Appendix D, click the link above. - Sample files for Microsoft Office Access 2003 Inside Out in Access 2000 format:
- GolfTournament.zip
Golf Tournament sample database from Running Microsoft Access 2000 (133K) - DBContainer2000.zip
Form that emulates the Database window (Access 2000 format – 25K) - Calendar.zip
Calendar sample database Access 97 format (92K)
This database demonstrates how to construct a common Calendar form that you can call from anywhere in your application. NOTE: All Access 97 databases can be converted to Access 2000 format. - Books.zip
Books sample database from Running Microsoft Access 97 (1,014K) - EntertainWCalendars.zip
Entertain sample database from Running Microsoft Access 2000 (738K)
This is an updated version that shows how to build a “booking” calendar to make it easy to see what dates are booked or available for a given group or club. See frmClubCalendar and frmGroupCalendar. - Entertain.zip
Entertain sample database from Running Microsoft Access 97 (558K) - College.zip
College sample database from Running Microsoft Access 97 (499K) - Wedding.zip
Wedding sample database from Running Microsoft Access 97 (64K)