Reading List
[ Home ] [ Access - Start Here ] [ Excel In Depth ] [ MS Office ] [ Visio Info ] [ Creating Web Pages ] [ Technical References ] [ Viruses ] [ Points of View ] [ Gadgets ] [ Just Links ] [ Monash ]

   Search this site or the web       powered by FreeFind
 
  Site search Web search

Participate in Ananda's Discussions
Post a message

Monitor page
for changes
    
   it's private  

by ChangeDetection

Up

Paper Books (the stuff you pay money for at the bookstore)

Relational Database Design Clearly Explained Jan L. Harrington

August 1998
350 pages
ISBN 0-12326-425-1
Beginning Access 2000 VBA

Beginning Access 97 VBA Programming

Thorough and patient reference of Access/VBA with lots of code and descriptions of what the code means.
Access 2002 Desktop Developer's Handbook

Access 2002 Enterprise Developer's Handbook

Access 2000 Developer's Handbook Volume 1: Desktop Edition

Access 2000 Developer's Handbook, Volume 2: Enterprise Edition

 These are THE references for all professional Access developers. They assume that you already know core elements of VBA and know Access well. They dispense professional level tips and techniques, with source code included.

Visit DevelopersHandbook.com
Microsoft Access Developer's Guide to SQL Server

 

This book by Mary Chipman is well researched and thorough. It gives insights and lead ins to people who know Access and are trying to get into SQL Server or MSDE Development.
The Guru's Guide to Transact-SQL This book by Ken Henderson is insightful reading into SQL Server
Que's Special Edition Using SQL ISBN 0789719746 A well written SQL book by Rafe Colburn - gives you generic SQL syntax and approaches and also spotlights nuances in the different dialects.
The Data Model Resource Book: A Library of Universal Data Models for All Enterprises, Revised Edition, Volume 1

The Data Model Resource Book: A Library of Universal Data Models by Industry Types, Revised Edition, Volume 2

 These books stood in the bookshop near me and then were returned due to lack of interest. They are actually quite useful - if you want to see examples of normalisation for typical businesses and get a grip of the fields that people collect, they're good.
Fairly cerebral - there are a number of books that introduce you to SQL, Joe's books give you advanced Q & A approaches.
Susan Novalis wrote her original book on Access macros at a time when the community had decided that Access Basic was the only way to do many things. It surprised many of us that the Access Macro Language could be that powerful and flexible.

It appears that Susan has shifted focus to VBA in later versions of Access.
VBA Developer's Handbook By Ken Getz and Mike Gilbert This is similar in style to the Access 97 Developer's Handbook. There is little overlap and it concentrates on advanced techniques in VBA, not the host application.
VBA for Dummies  This is a fun introduction to VBA. Not a thick book.
Microsoft® Excel 97 Developer's Handbook The definitive Excel VBA series of books by Eric Wells and Steve Harshbarger.
Word 2000 Developer's Handbook Guy Hart Davis writes a good Word / VBA book.
asp.net for Developers  

Special Edition Using SQL

 By Rafe Colburn - pretty good guide to generic SQL with some examples on real database products

Websites (free resources)

Use FreeAnswers.Com Free Answers Use Google. Limit the domain to Microsoft.com Google Advanced Search Use MSKB Limit the domain to Microsoft.com MSKB thumbnail
Office 2000 Language Reference Definitive dictionary of Office 2000 VBA from the horse's mouth.
Access 2002 Object Model

Click here to see enlarged diagram

from MSDN
The DAO Object Model

Click here to see enlarged diagram

MSDN
The ADO Object Model

Click here to see enlarged diagram

MSDN



Terry Wickenden is the guru of the RunCommand constants.
MSDN articles
Microsoft Jet Database Engine Programmer's Guide This book was available in paper. Sample chapters are available Microsoft Technet.

If you want the syntax and optimisations that you can do to improve speed of your data retrievals, this is a good and insider's book.

Data Access Objects (DAO) 3.5 and ODBCDirect

 Older article on ODBC Direct
Access Security FAQ

Access 97 Security Manager

Access 2000 Security Manager

Access Security FAQ - Mary Chipman et. al.
SQL joins - multi-table queries by Ian Gilfillan for WDVL

Simple SQL : Getting Started With SQL by Ted Brockwood for WDVL

Web Developer's Virtual Library
Article by Grady Booch on UML relating to Office and Database Development
Access 2000: Building Applications with Forms and Reports MSDN. You can download the sample files here
When to use Data Access Pages, ASP and ASP.NET MSDN
Microsoft Jet Database Replication

Replication FAQ

 MSDN
MSDN
Older MS website
Helen writes WAW - Woody's Access Watch, a free weekly email newsletter.
MS SQL Server (7) Introduction Technet
MS SQL Server (7) Administrator's Companion Technet
MS SQL Server Transact-SQL and Utilities Reference, Volume 1

MS SQL Server Transact-SQL and Utilities Reference, Volume 2

Technet
Optimising Database Performance (SQL Server 7)

Troubleshooting

Error Messages

Technet
Dev Ashish's The access Web Mandatory visiting
Micheal Kaplan's Trigeminal website Chockful of utilities from the guru of Internationalisation and Replication.
FMS Technical Papers - Database Normalization Tips

FMS Technical Papers - Making Access Faster - 168 Tips to Improve the Performance of Your Apps

FMS Technical Papers - Data Normalization Fundamentals

FMS Technical Papers - 17 Steps to Better VBA Code

From the folks at fmsinc.com, the makers of Total Access Analyser, Sourcebook.
Trevor's Access FAQ Circa Access 2.0 but contains early Leszynski-Reddick Naming Convention
Alan Browne's Tips for Access Users Circa Access 2.0
Access to Movies: Adding Multimedia with Access and Visual Basic Older MS article
Q218621 - ACC2000 How to Have List Box Respond to Entire String You Type

Q210343 - ACC2000 How to Replace the Default Input Mask Error Message

Q210334 - ACC2000 How to Automatically Detect If a Form Is Being Edited

Q210326 - ACC2000 How to Create an AfterUndo Form Event

Q210276 - ACC2000 Storing, Calculating, and Comparing Date-Time Data

Q210604 - ACC2000 Functions for Calculating and Displaying Date-Time Values

Q210261 - ACC2000 How to Sum a Column of Numbers in a Report by Page

Q209849 - ACC2000- How to Loop Through References to View Their Properties

Q209874 - ACC2000- How to Recover a Table Deleted from a Database

Q200880 - ACC2000- Controlling Bound Form Transactions in Access Projects

Q202176 - ACC2000- How to Transpose Data in a Table or Query

Q202056 - ACC2000- Creating an Updatable Unbound Word Object on a Report

Q202147 - ACC2000- How to Use Automation to Modify MS Graph Object

Q203992 - ACC2000- How to Generate and Print a Report Without Saving It

ACC- How to Pass an Array as an Argument to a Procedure

ACC How to Move from Subform to Main Form by Using TAB or ENTER

ACC How to Use the Seek Method on Linked Tables

Access Frequently Asked Questions - Security FAQ

Use Data Link Files with ADO 2

Various MSKB articles
Bug Proofing - Error Handling Fundamentals From the VB-Helper website
ACC Imported MS Excel Carriage Returns Become Vertical Bars ACC How to Call Excel Functions from Within Microsoft Access Imported Excel and Word tables (via Excel)
ACC- How to Use Automation to Find Bookmark in Word 97 Document

ACC- Sending the Current Record to Word 97 with Automation

Q159328 ACC: Using Automation to Run Word 97 Mail Merge from MS Access

wordmacros.com-macro_faqs

wordmacros.com-word_faqs

Using Word as an output device from Access
Visually Model Software Applications (UML)

ADO.NET for the ADO programmer

Upgrading to dot Net

MSDN
Visio for Developers MSDN
Arvin Meyer's Downloads
Automating Outlook using ADO From Freevbcode
Excel-VBA-Access tips - Ethics
The Leszynski-Reddick Naming Convention
Access 97 Menu Builder Wizard

Access 97 Balloon Builder Wizard

Access 97 Wizard Building Wizard

Access 97 Command Bar Wizard

These are downloadable Wizards for Access 97.
Creating Windows Help Files
Office 97 Eraser

Office 2000 CD1 Eraser

Office 2000 CD2 Eraser

If you have Access or MS Office consistently crashing after it has been performing ok, it may mean that somehow the installation has been damaged. You should first use Control Panel -> Add/Remove Programs and try Repair (Office 2000) or Uninstall (Office 97). An uninstall often does not restore you machine - there will be some Office .dlls and registry settings still remaining. These erases ensure that the .dlls are removed, as also relevant registry entries.

Be careful - sometimes standard Windows fonts are removed as well - Arial, Times New Roman etc.. Have copy of these fonts on you so that you can restore them if the erasers have been too aggressive.