The Access Junkie's Reference List

      This list of references has been compiled by Jeff Conrad of Bend, Oregon. Jeff styles himself The Access Junkie but, whatever he calls himself, this is perhaps the most comprehensive list of websites you will find anywhere. My thanks to Jeff for letting me include it in my website. Come back often for updates.

Last Updated: Apr 1st, 2005
*** Added/Updated since last revision

Back To Code Page

Contents:
Starting Out
Database Design 101
Interface Design
Tutorial
Download Samples
Sensei
Advanced Topics
Misc: Downloads - Samples - Articles
Articles - Code Samples
RunCommand Constants
Other Access Links
Add-ins - Utilities
Access Chats
Access Security
Menu Bars - Tool Bars
Access Replication
Access Forums
Book Recommendations
Access Publications
Access User Groups - Special Interest Groups
Access MVP Sites
Database Recovery

Number One on your start list: 

http://www.mvps.org/access/

(A definite must!)

Microsoft Knowledge Base for searching:

http://search.support.microsoft.com/search/?adv=1

Getting Started: 

http://www.mvps.org/access/tencommandments.htm

http://www.accessmvp.com/djsteele/AccessTenCommandments.html

(Follow the wisdom and do not stray towards the Dark Side)

Netiquette:

http://www.mvps.org/access/netiquette.htm

ACC: Database Normalization Basics

http://support.microsoft.com/?id=100139

http://support.microsoft.com/?id=209534

http://support.microsoft.com/?id=283878

Glossary of database terms:

http://www.dhdursoassociates.com/database-glossary-3.html

Where to find information about designing a database in Microsoft Access:

http://support.microsoft.com/?id=289533

"Understanding Relational Database Design" Document Available in Download Center:

http://support.microsoft.com/?id=283698

http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"

http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:

http://support.microsoft.com/?id=129519

Database Design Principles:

http://msdn.microsoft.com/library/en-us/dndbdes/html/ch04DDP.asp

Naming Conventions:

http://www.xoc.net/standards/rvbanc.asp

http://www.mvps.org/access/general/gen0012.htm 

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_20naming.asp 

***http://infocom.cqu.edu.au/Courses/2001/T5/COIT13143/Resources/lrnamstd.rtf

http://www.eade.com/AccessSIG/downloads.htm

(See the last download titled "Understanding Normalization") 

http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html 

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

Database Normalization Tips by Luke Chung:

http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Support WebCast: Database Normalization Basics:

http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

Concepts Of Database Design And Management:

http://www.sitepoint.com/article/database-design-management

Database Design And Normalization (aimed at dBase, but still valid):

http://www.jpmartel.com/bu12_c.htm

Conceptual Database Design:

http://www.sbpa.csusb.edu/flin/info609/dbdesign/Default.htm

Database Normalization:

http://burks.bton.ac.uk/burks/foldoc/35/28.htm

Understanding Normalization:

***http://www.formeremortals.com/Downloads/UnderstandingNormalization.pdf

Introduction To Data Modeling:

http://www.utexas.edu/its/windows/database/datamodeling/index.html

5 Rules of Database Normalization:

http://www.datamodel.org/NormalizationRules.html

Special characters that you must avoid when you work with Access databases:

http://support.microsoft.com/?id=826763

Reserved Words in Microsoft Access:

http://support.microsoft.com/?id=109312

http://support.microsoft.com/?id=209187

http://support.microsoft.com/?id=286335

List of Reserved words in Jet 4.0:

http://support.microsoft.com/?id=321266

Access Data "Clean-up" Tips:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=182

Interface Design topics:

http://www.isii.com/ui_design.html

http://www.jstreettech.com/Downloads.asp

(User Interface Guidelines) 

Microsoft Database Templates:

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=database

Tutorial Style Links: 

http://www.microsoft.com/Accessdev/articles/bapp97/toc.htm

Microsoft Access 2000: Building Applications with Forms and Reports

http://tinyurl.com/2szmm  

http://www.geekgirls.com/databasics_01.htm 

http://www.microsoft.com/office/previous/xp/columns/column06.asp 

http://www.functionx.com/access/ 

http://www.bcschools.net/staff/AccessHelp.htm#Top 

http://www.fontstuff.com/access/index.htm 

http://www.fgcu.edu/support/office2000/access/ 

http://www.oit.duke.edu/ats/training/docs/access1/ 

http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html#sec_intro

https://secure.vtc.com/cd/access2003.htm 

***http://simply-access.com/index.php?module=Website&action=Text&content=1103189759765-9716 

http://www.rogersaccesslibrary.com/Tutorials.html 

http://www.datapigtechnologies.com/AccessMain.htm 

SQL Tutorial:

http://www.w3schools.com/sql/default.asp 

Tutorial: Analyzing Data Using Access

http://www.microsoft.com/education/AccessTutorial.aspx  

***http://www.accessmonster.com/Uwe/DirCat.aspx/Access-Directory/Tutorials 

Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm 

http://tutorials.freeskills.com/index/category/104

Download Samples Links: 

http://rogersaccesslibrary.com/TableOfContents3.asp 

http://www.invisibleinc.com/divFiles.cfm?divDivID=4 

http://www.candace-tripp.com/access_downloads.htm 

http://www.datastrat.com/DataStrat2.html 

http://members.shaw.ca/glenk/index.html 

http://www.pointltd.com/Downloads/?p=Access 

http://www.freeaccess.de/downloads.asp

(In German) 

http://www.weascend.com/Downloads/downloadpage.htm

The mighty Sensei Leban's site for all things magical:

(Please bow in reverence on your way in.) 

http://www.lebans.com/

Advanced Topics: 

http://www.trigeminal.com/utility.asp 

http://www.mentalis.org/index2.shtml

Misc: Downloads/Samples/Helpful Articles Links: 

http://www.granite.ab.ca/accsmstr.htm 

http://allenbrowne.com.au/tips.html 

http://www.viescas.com 

http://www.daiglenet.com/msaccess.htm 

http://www.users.bigpond.com/papwalker/ 

http://www.applecore99.com/index.asp 

http://www.helenfeddema.com/access.htm 

http://www.dbases.net/knowledge_base/ 

http://ourworld.compuserve.com/homepages/attac-cg/ 

http://www.aadconsulting.com/index.html 

http://accdevel.tripod.com/ 

http://www.scobiz.com/Presentations.asp 

http://dnn.scobiz.com/ 

http://ffdba.com/downloads.htm 

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html 

http://www.mvps.org/btmtz/ 

http://www.jstreettech.com/Downloads.asp 

http://www.liquorman.net/Tips.html 

http://propertychampion.com/Developer_Tools/Addins/Addins.html 

http://wolfwares.com/Access/microsoft_access.htm

Helpful Articles/Code Samples Links: 

http://www.pacificdb.com.au/MVP/MVPCode.htm 

http://www.accessmvp.com/djsteele/AccessIndex.html 

http://www.winsoft.sk/daofaq.htm 

http://www.calvinsmithsoftware.com/HardToFindTips.htm 

http://www.mvps.org/vbnet/ 

http://www.master-office.com/developers.htm 

http://www.trevor.easynet.co.uk/AccFAQ/ 

http://www.theofficeexperts.com/access.htm 

http://www.access.qbuilt.com/ 

http://brenreyn.brinkster.net 

http://www.microsoft-accesssolutions.co.uk/ 

http://www.blueclaw-db.com/ms_access_examples/index.htm 

http://www.jamiessoftware.tk/ 

http://www.pdtech.co.uk/prod01.htm 

http://easyweb.easynet.co.uk/~trevor/AccFAQ/

(A little dated, but still some helpful things) 

http://www.vbexplorer.com/VBExplorer/VBExplorer.asp 

http://www.heuveltop.nl/BasCB/msac_index.html 

http://www.vb123.com/search/toc.htm 

http://www.able-consulting.com/ADO_Faq.htm 

http://www.logicielappui.com/tips/

(In French) 

http://c85.cemi.rssi.ru/Access/ListTips.idc?AccessID=3

(In Russian) 

http://www.donkarl.com/

(In German) 

http://www.sitocomune.com/

(In Italian) 

http://www.access.online.pt/

(In Portuguese) 

http://www.mvp-access.com/buho/index.htm

(In Spanish) 

http://www.mvp-access.com/juanmafan/

(In Spanish) 

http://usuarios.lycos.es/jbchea/RptCp.htm

(In Spanish) 

http://www.mcpegasus.net/content/faqs.htm

(In Spanish)

http://archive.baarns.com/software/

(Click Developer's FAQ Page)

http://www.comriesoftware.net/codewidgets/browse.aspx?cat=1

http://www.tek-tips.com/faq.cfm?pid=702

Run Command Constants: 

http://www.tkwickenden.clara.net/

A massive list of other Access links:

http://www.geocities.com/waddly/accory.html 

http://dmoz.org/Computers/Software/Databases/MS_Access/ 

http://www.directory-base.com/access/

***http://www.cbel.com/ms_access/

Add-Ins/Utilities Links: 

My five personal favorites (all free):

;-) 

1. "Doug Steele Object Documentor"

http://www.accessmvp.com/djsteele/Documentor.html 

2. "John Viescas Table Documentor"

<Awaiting word back from John on the possibility of posting>

<Ask if you would like a copy> 

3. "Albert Kallal Database Statistics"

<Awaiting word back from Albert on the possibility of posting>

<Ask if you would like a copy> 

4. "Advanced Switchboard Manager"

<Coming Soon> 

5. "Sandra Daigle Permissions Wizard"

http://www.daiglenet.com/msaccess.htm 

http://mphillipson.users.btopenworld.com/ 

http://www.fmsinc.com/ 

http://www.moshannon.com/ 

http://www.rickworld.com 

http://www3.bc.sympatico.ca/starthere/findandreplace 

http://www.peterssoftware.com/index.htm 

http://www.dbi-tech.com/default.asp 

http://www.zada.com.au/accessaddins.htm 

http://www.mztools.com 

http://www.logico-solutions.com/ 

http://accesstools.narod.ru/ 

http://www.directory-base.com/access/index.php?inc=20&title=Add%20Ins 

http://www.skrol29.com/index.php?lang=us 

http://www.infoplan.com.au 

http://www.appsplus.com/ 

http://www.devexpress.com/?section=/products/ActiveX/XSideBar 

http://www.accessmonster.com/Access-Directory/Tools/Access-Resources.aspx 

http://www.databasecreations.com/devtools.htm 

http://www.fabalou.com/fullprograms/dbutilities.asp 

http://www.oaltd.co.uk/VBETools/Default.htm

 (Enhances References Dialog box) 

http://www.ammara.com/ 

http://www.exontrol.com/sg.jsp?content=products/excalendar 

http://www.ssw.com.au/SSW/Download/Download.aspx 

http://www.aylott.com.au/accver.htm

http://www.osagecomputing.com/

http://www.prestosoft.com/ps.asp?page=edp_examdiff

http://www.softwareaddins.com/

http://www.microsoft.com/india/msdn/articles/DatabaseUtility.asp

http://atroplan.com/AccMemReporter.htm

http://www.compros.com.au/AS/ReadMe.html

http://archive.baarns.com/software/

 (Click On-Line Catalog then Access Software)

http://www.granite.ab.ca/access/thirdparty.htm

 (Big list here)

http://www.submain.com/?nav=products.pcp

***http://www.bway.net/~dfassoc/download/Access/Reconnect.html

Live Access chats every Tuesday and Thursday:

Tuesday 11am EDT - Thursday 3:30pm EDT

http://community.compuserve.com/msdevapps

Access User-Level Security Links: 

Security FAQ (the Security Bible):

http://support.microsoft.com/?kbid=207793 

Jack Macdonald's Security Document:

http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf 

Lynn Trapp's Ten Security Steps:

http://www.ltcomputerdesigns.com/Security.htm 

Joan Wild's Tips:

http://www.jmwild.com/security02.htm 

The Security Whitepaper is also worth reading:

http://support.microsoft.com/?id=148555 

Keith Wilby's Instructions (See step-by-step link)

http://www.keithwilby.com/ 

Other Good Information: 

http://www.access-experts.com/default.aspx?selection=TutorialSecurity&sm=18

Other Microsoft KB articles of interest: 

Description of how to help protect a Access 2000 database:

http://support.microsoft.com/?id=254372 

Description of the role of workgroup information files in Access Security:

http://support.microsoft.com/?id=303941

http://support.microsoft.com/?id=305541

http://support.microsoft.com/?id=305542

Exploring Microsoft Access Security:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_AcSecurity.asp?frame=true 

Creating menu bars and tool bars:  

http://www.microsoft.com/Accessdev/articles/bapp97/chapters/ba01_6.htm

http://msdn.microsoft.com/library/techart/ofcmdbar.htm

http://www.access.qbuilt.com/html/forms.html#CustomCmdBar

Access Replication: 

http://www.trigeminal.com/resources.asp?1033 

http://www.trigeminal.com/replication/splitrep.asp?1033 

Replication FAQ:

http://support.microsoft.com/?id=282977 

Replication White Paper:

***http://support.microsoft.com/?id=190766 

http://www.access-experts.com/default.aspx?selection=TutorialReplication&sm=18

Additional Access Forums: 

http://www.accessvba.com/ 

http://www.utteraccess.com 

http://www.access-programmers.co.uk/forums/ 

http://www.accessmonster.com/Uwe/ForumList.aspx 

http://groups.yahoo.com/group/MS_Access_Professionals/ 

http://www.tek-tips.com/threadminder.cfm?pid=702 

http://www.everythingaccess.com/forums/ 

Book Recommendations: 

http://www.developershandbook.com/

(A VERY good book to have) 

http://www.viescas.com/Info/books.htm

(Anything written by John Viescas is a keeper) 

http://www.fmsinc.com/toplevel/books.htm 

http://www.ForMereMortals.com 

http://www.wrox.com/WileyCDA/Section/id-105060.html 

http://www.bookpool.com/.x/RRRRRR/sm/1558609202 

http://tinyurl.com/6j7xl 

http://www.mvps.org/access/resources/books.htm

http://www.rogersaccesslibrary.com/linksRecommededreading.html

http://www.oreilly.com/catalog/accessannoy/index.html

Access Publications: 

http://www.smartaccessnewsletter.com/ME2/Audiences/default.asp 

http://accessvbsqladvisor.com/ 

http://www.intelligententerprise.com/info_centers/database/

***http://www.dbmsmag.com/artindx.shtml

Access User Groups/Special Interest Groups: 

http://www.paug.com 

http://www.pnwadg.org/ 

http://www.eade.com/AccessSIG/ 

http://www.DAAUG.org 

http://68.149.211.56:29994/ 

http://www.ravey.net/aug/ 

http://cpcug.org/user/access/ 

http://www.ukaug.co.uk/ 

http://members.tripod.com/ntaccess/ 

http://www.hal-pc.org/~SIG/ 

http://www.ssw.com.au/ssw/ 

http://www.arimsoft.ru/msaccess/

Some of the MVP web sites: 

http://www.mvps.org/links.html

Database Recovery: 

http://www.pksolutions.com/ 

http://www.atroplan.com/ 

AccessFix Software:

http://www.cimaware.com/accessfix.html