Starting Out with Access:
Number One on your start list for comprehensive Access help:
http://www.mvps.org/access/
Top Top
Access Ten Commandments:
Follow the wisdom and do not stray towards the Dark Side.
"...fear leads to anger, anger leads to hate, hate leads to Lookup Fields."
http://www.mvps.org/access/tencommandments.htm
http://www.accessmvp.com/djsteele/AccessTenCommandments.html
http://www.3nf-inc.com/Access10.htm
Top Top
Microsoft Knowledge Base Articles:
Main Page for searching:
http://search.support.microsoft.com/search/?adv=1
How to use the Knowledge Base:
List of Access KB Articles:
http://www.aadconsulting.com/kb/kbarticles.htm
Top Top
Netiquette for newsgroup postings:
Netiquette:
http://www.mvps.org/access/netiquette.htm
How to ask a question:
http://support.microsoft.com/kb/555375
mvp.jpg (771 bytes) Making Good Newsgroup Posts:
http://dts-l.org/goodpost.htm
How to ask in a newsgroup:
http://www.michna.com/kb/Newsgroups.htm
The Lost Art of Etiquette:
http://www.clintonfitch.com/editorials/102005/lostart.asp
Why and How to Crosspost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
Using the Newsgroups Effectively:
http://tc2.atspace.com/0012-UsingUsenet.htm'>http://tc2.atspace.com/0012-UsingUsenet.htm
Top Top
Database Design 101:
Understanding Normalization by Michael Hernandez:
http://www.formeremortals.com/Downloads/UnderstandingNormalization.pdf
Database Design Tips by Michael Hernandez:
Database Design Tips.zip
ACC: Database Normalization Basics
Glossary of database terms:
http://www.dhdursoassociates.com/database-glossary-3.html
Where to find information about designing a database in Microsoft Access:
"Understanding Relational Database Design" Document Available in
Download Center:
ACC2000: "Understanding Relational Database Design"
Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519
http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html
Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html'>http://www.fmsinc.com/tpapers/genaccess/databasenorm.html
Data Normalization Fundamentals by Luke Chung:
http://www.fmsinc.com/tpapers/datanorm/index.html'>http://www.fmsinc.com/tpapers/datanorm/index.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
Database Normalization:
http://burks.bton.ac.uk/burks/foldoc/35/28.htm
Introduction To Data Modeling:
http://www.utexas.edu/its/windows/database/datamodeling/index.html
Access Data "Clean-up" Tips:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=182
Defining relationships between tables in a Microsoft Access database:
http://support.microsoft.com/?id=304466
http://support.microsoft.com/kb/304467/
http://support.microsoft.com/kb/304468/
Database Normalization Techniques:
http://databases.about.com/od/specificproducts/a/normalization.htm
Introduction to Database Normalization:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
Database Normalization:
http://en.wikipedia.org/wiki/Database_normalization
MVP Crystal Long's Access Basics document:
http://www.allenbrowne.com/casu-22.html
Data Modeling 101 by George Hepworth:
http://www.gpcdata.com/downloads/normalizationgpgonaccess.pdf
A Little Treatise on Normalization by Access MVP Jerry Dennison:
http://tinyurl.com/hczcd
Fully Qualified Naming - The First Step To Normalization by Access
MVP Jerry Dennison:
http://tinyurl.com/frgb3
Glossary of Terms and Definitions by Access MVP Jerry Dennison:
http://tinyurl.com/jow3q
General Database Design Topics and Articles:
http://www.databasedev.co.uk/general.html'>http://www.databasedev.co.uk/general.html
Rules of Data Normalization:
http://www.datamodel.org/NormalizationRules.html
Normalization Rules - Beyond The Third Normal Form
http://www.curlingstone.com/Normalization2.html
Normalization:
http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/normalisation/contents.html
Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html
Advanced Normalization:
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html
Overview of Normalization:
http://www.gslis.utexas.edu/~wyllys/DMPAMaterials/normover.html
Normalization:
http://db.grussell.org/section008.html
Normalization – BCNF:
http://db.grussell.org/section009.html
A Simple Guide to Five Normal Forms in Relational Database Theory:
http://www.bkent.net/Doc/simple5.htm
Introduction to Relational Databases - Part 1: Theoretical Foundation:
http://www.15seconds.com/issue/020522.htm
On DK/NF Normal Form:
http://www.dbdebunk.com/page/page/621935.htm
Database eLearning:
http://db.grussell.org/index.html
ACC: General Initial Planning Phase For A New Database Part I:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=290041
ACC: General Planning a database – Part 2:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=309586
Database Design Strategies:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=130932
Normalizing a Database:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=343208
Indexes - Info and Links:
http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994'>http://www.utteraccess.com/forums/showflat.php?Board=8&Number=1211994
SQL Tutorial:
http://www.1keydata.com/sql/sql.html
Data Warehousing and Business Intelligence:
http://www.1keydata.com/datawarehousing/datawarehouse.html
Top Top
Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp
mvp.jpg (771 bytes) 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.granite.ab.ca/access/tablefieldnaming.htm
Object Hungarian Notation Naming Conventions for VB:
http://support.microsoft.com/kb/q173738/
Top Top
Reserved Words:
Problem names and reserved words in Access:
http://allenbrowne.com/AppIssueBadWord.html
Validate Names to Make Sure They Aren't VBA Keywords:
http://www.trigeminal.com/codes.asp?ItemID=18#18
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
http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Reserved Words”)
http://tinyurl.com/ze6q8
Top Top
Interface Design Topics:
http://www.isii.com/ui_design.html
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(User Interface Guidelines)
Official Guidelines for User Interface Developers and Designers:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwue/html/welcome.asp'>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwue/html/welcome.asp
http://www.databasedev.co.uk/user_interface_design.html'>http://www.databasedev.co.uk/user_interface_design.html
Top Top
Microsoft Database Templates:
http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=database
Top Top
Tutorial Style:
http://www.rogersaccesslibrary.com/Tutorials.html
http://allenbrowne.com/casu-01.html
Solutions and Orders Sample Databases:
http://www.mvps.org/access/downloads/bapp2000.exe
Building Microsoft Access Applications by MVP John Viescas:
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/dndbdes/html/
OfficeAccessBuildingApplicationsCh4_Book.asp
Bob Larson's Tutorials and samples:
http://www.btabdevelopment.com
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.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
http://tutorials.freeskills.com/index/category/104
List of resources that are available to help you learn Visual Basic
for Applications programming:
http://support.microsoft.com/?id=226118
http://www.profsr.com/home3.html
Intermediate Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/
en-us/dnacc2k/html/acintsql.asp
http://www.majorsoftware.com.au/Orderform.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
bapp2000/html/mdbdownload.asp
http://www.microsoft.com/resources/documentation/sql/7/
all/proddocs/en-us/msjet/jetch02.mspx
http://databases.about.com/cs/tutorials/
http://office.microsoft.com/en-us/officeupdate/CD011124301033.aspx
http://c85.cemi.rssi.ru/access/Books/A97ExSol/contents.htm
Tutorial in Spanish:
http://www.aulafacil.com/Access/CursoAccess/CursoAccess.htm
http://office.microsoft.com/training/training.aspx?AssetID=RC061181381033&CTT
=6&Origin=RP061182801033
http://www.ehow.com/how_13626_define-many-many.html
Interactive Online SQL Training:
http://www.sqlcourse.com/
Fundamental Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp
Intermediate Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp
Advanced Microsoft Jet SQL for Access 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp
Microsoft Access 2000 CD-ROM Training from AppDev:
http://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=AC00Product
http://www.database-design-2000.com/lesson1.htm
http://customguide.com/certification/access_training_2002/mos.htm
Access 2003 Courses:
http://office.microsoft.com/en-us/training/CR061829401033.aspx
Autonumbers - what they Are and Are Not...
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604'>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=443604
https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=73976
Access 2003 VBA Course:
http://www.learnaccessvba.com
Learn Access Now
http://www.learnaccessnow.com
Overview of Access:
http://www.hitechcoach.com/resources.htm
http://www.myaccessprogram.com/
Top Top
Sample Database Models/Table Designs:
http://www.databaseanswers.com/data_models/index.htm
Top Top
Download Samples:
http://rogersaccesslibrary.com/TableOfContents3.asp
http://www.datastrat.com/DataStrat2.html
http://www.pointltd.com/Downloads/?p=Access
http://www.accessmvp.com/KDSnell/SampleDBs.htm
http://www.candace-tripp.com/pages/access_downloads.aspx
http://members.shaw.ca/glenk/index.html
http://www.freeaccess.de/downloads.asp
(In German)
http://www.weascend.com/Downloads/downloadpage.htm
http://www.aleksoft.net/samples/
http://www.worksrite.com/
(Click on the News button)
http://www.amazecreations.com/datafast/Download.aspx
http://www.endprod.com/db.htm
Newsgroup regular Fred Boer has graciously provided a
fully-functioning library database that can be downloaded:
http://www3.sympatico.ca/lornarourke/fred.html
http://www.asken.com.au/downloads/accessdbs1.php
http://www.enflow.com/Cases/SampleSoftware.htm
http://www.databasedevelopment.co.uk/examples.htm
Top Top
MVP Stephen Leban's site:
http://www.lebans.com/
Yes, Stephen's site deserves a category of its own.
A couple of things I have learned from Stephen:
1. If you think something cannot be done with Access, check his site first.
2. If Stephen says it cannot be done, trust me, it cannot be done!
Top Top
Advanced Topics:
http://www.trigeminal.com/utility.asp
(Once an MVP, always an MVP in my book)
http://www.mentalis.org/index2.shtml
Top Top
Misc: Downloads/Samples/Helpful Articles
http://www.granite.ab.ca/accsmstr.htm
http://allenbrowne.com.au/tips.html
http://www.viescas.com
http://www.accessmvp.com/SDaigle/index.htm
http://www.users.bigpond.com/papwalker/
http://www.groupacg.com/
mvp.jpg (771 bytes) http://accdevel.tripod.com/
http://www.scobiz.com/Presentations.asp
http://dnn.scobiz.com/
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
http://btmtz.mvps.org/
http://tc2.atspace.com/
http://www.access.hookom.net/
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
http://home.comcast.net/~cccsolutions/accesstips.html
http://www.applecore99.com/index.asp
http://www.helenfeddema.com/access.htm
http://www.aadconsulting.com/index.html
http://ffdba.com/#downloads
http://www.liquorman.net/Tips.html
http://propertychampion.com/Developer_Tools/Addins/Addins.html
25 SQL Commandments:
http://www.dbpd.com/vault/9801xtra.htm
http://www.resources.intuidev.com/
http://www.knowhowtwo.com/Tips/access_tips.htm#Caps%20Lock%20Feature
Top Top
Helpful Articles/Code Samples:
http://www.pacificdb.com.au/MVP/MVPCode.htm
http://www.accessmvp.com/djsteele/AccessIndex.html
http://www.ltcomputerdesigns.com
http://accesstips.datamanagementsolutions.biz/index.htm
http://vbnet.mvps.org
http://brenreyn.brinkster.net
mvp.jpg (771 bytes) http://www.mvp-access.com/buho/index.htm
(In Spanish)
mvp.jpg (771 bytes) http://www.mvp-access.com/juanmafan/
(In Spanish)
http://accessvbafaq.mvps.org/
http://usuarios.lycos.es/jbchea/RptCp.htm
(In Spanish)
http://www.j.nurick.dial.pipex.com/Code/index.htm
http://www.access.vis.pl/
(In Polish)
http://www.access.qbuilt.com/
http://www.winsoft.sk/daofaq.htm
http://www.calvinsmithsoftware.com/HardToFindTips.htm
http://www.trevor.easynet.co.uk/AccFAQ/
http://www.theofficeexperts.com/access.htm
http://www.databasedev.co.uk/
http://www.blueclaw-db.com/ms_access_examples/index.htm
http://www.jamiessoftware.tk/
http://www.pdtech.co.uk/prod01.htm
http://www.vbexplorer.com/VBExplorer/VBExplorer.asp
http://www.heuveltop.nl/BasCB/msac_index.html
http://www.vb123.com/search/toc.htm
http://www.carlprothman.net/Default.aspx?tabid=100
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.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
http://www.hcts.net.au/tipsandtricks.htm
http://www.accessfreak.net/
http://www.mantuanet.it/alessandro.baraldi/
(In Italian)
http://members.cox.net/tulsaalstons/Documents/Microsoft%20Access%
20Developer%20Transition%20to%20Internet.htm.
http://www.accessdatabasetips.com/
http://www.microsoft.com/accessdev/a-a&sa.htm
http://custom-software.biz/Ezine.htm
http://www.mile50.com/access/
http://cpcug.org/user/clemenzi/technical/Databases/MSAccess/
http://www.fabalou.com/access/access.asp
http://www.amazecreations.com/datafast/article.aspx
http://www.techonthenet.com/access/index.php
http://www.columbia.edu/~jl2402/AccessTips.html
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndbdes/html/
CHAPTER2AccessProtectionSecurity.asp
http://www.databasejournal.com/features/msaccess/article.php/3437731
http://www.databasejournal.com/features/msaccess/article.php/3298161
http://www.nwarwick.co.uk/Access.htm
Using MapPoint from Word, Access and Excel:
http://www.mp2kmag.com/a39--word.access.excel.mappoint.html
Tina’s Tips to Get You Going-
Basic information that applies to all databases...
http://home.att.net/~california.db/tips.html
http://vb-helper.com/index_multimedia.html
Top Top
Run Command Constants:
http://www.tkwickenden.clara.net/
Top Top
A massive list of other Access links:
http://groups.yahoo.com/group/MS_Access_Professionals/links'>http://groups.yahoo.com/group/MS_Access_Professionals/links
(Have to be a member)
http://www.datacomptech.com/links.html#acc
http://www.access.qbuilt.com/html/links.html
http://www22.brinkster.com/accessory/links.asp
http://dmoz.org/Computers/Software/Databases/MS_Access/
http://www.directory-base.com/access/
http://www.cbel.com/ms_access/
http://www.aadconsulting.com/accessres.html
http://www.utteraccess.com/links/'>http://www.utteraccess.com/links/
http://www.candace-tripp.com/pages/mainf.aspx#
http://www.vbaexpress.com/resources.php#Access
http://www.enflow.com/links.htm
http://www.yaccess.com/alph.shtm
Top Top
Add-Ins/Utilities:
"CSD Tools Database Documentation"
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html
"Doug Steele Object Documenter"
http://www.accessmvp.com/djsteele/Documentor.html
"Sandra Daigle Permissions Wizard"
This is a re-write of MVP Sandra Daigle's DbUtilities which, as an
Add-in, makes it easier to transfer the object permissions from a
secured database to a new database container.
The Zip file also includes a complete user guide which covers
installation, usage and walk-through guides.
Select the appropriate Zip file for whichever version of Access you are using.
DBUtilitiesAddin97.zip
DBUtilitiesAddin2000.zip
(255 KB)
(207 KB)
http://www.fmsinc.com/
http://www.granite.ab.ca/access/thirdparty.htm
(Big list here)
http://www.appspro.com/Utilities/CodeCleaner.htm
http://www.grahamwideman.com/gw/tech/access/permexpl/index.htm
The ToolShed Access eBook:
www.vb123.com/toolshed/
The WorkBench for Microsoft Access:
www.vb123.com/workbench/
The ToolBox:
http://www.vb123.com/toolbox/
http://groups.yahoo.com/group/MS_Access_Professionals/files/0_Utilities%20and%20Add-ins/'>http://groups.yahoo.com/group/MS_Access_Professionals/files/0_Utilities%20and%20Add-ins/
(Have to be a member)
http://mphillipson.users.btopenworld.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/us/vaccess2.php
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?
GroupCategoryID=2ACCESS
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://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.submain.com/?nav=products.pcp
http://www.bway.net/~dfassoc/download/Access/Reconnect.html
http://www.jstarsoftware.com/index_files/ProductList.htm
http://www.troisj.com/
http://www.winsite.com/bin/Info?1000000034270
http://www.cleandatasystems.com/
http://www.kliksoft.com/
http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm
http://www.accessui.com/
http://www.aislebyaisle.com/access/tools.htm
http://www.mindwarp-consultancy-software.com/mdbsecure-free-trial-download.html
http://www.dqwest.com/mdbartisan.htm
Office Automation - Smart Indenter
http://www.oaltd.co.uk/Indenter/Default.htm
BMS Smart Indenter:
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=424894&Main=424894'>http://www.utteraccess.com/forums/showflat.php?Cat=&Number=424894&Main=424894
http://www.zexersoft.com/products.html
http://www.vbaccelerator.com/home/Resources/Graphics_Library/Icons/Toolbar/Office/Access/article.asp
http://www.oscorp.com/downloads.asp
http://www.microtools.us/_product.aspx
http://www.users.cloud9.net/~dfurman/code.htm
http://www.devexpress.com/Downloads/ActiveX/XFreeLib/
Gnatt Chart Builder System:
http://www.bandwood.com/gbs.htm
Compare'EM Utility:
http://home.gci.net/~mike-noel/CompareEM
Access Auto Pilot:
http://www.access-autopilot.com/
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm
http://www.vbaexpress.com/cooltools.php
Caller ID Software, Ms Access:
http://www.yes-tele.com/access.html
http://www.acc-technology.com/
http://www.kellermansoftware.com/
MDE Source Code Protector v1.02 for Microsoft® Access:
http://www.everythingaccess.com/mdeprotector.htm
SQL Formatter:
http://www.sqlinform.com/
UI Builder for Microsoft Access
http://opengatesw.com/uidownloads.aspx
Headway Shortcut Builder
http://www.headwaysystems.com:80/ShortcutBuilder.htm
Top Top
Access Chats:
Live Access chats every Tuesday and Thursday:
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Top Top
Access User-Level Security:
Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793
Security FAQ On-line edition:
http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp
Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm
Joan Wild's Tips:
http://www.jmwild.com/security02.htm
The Microsoft Access Security Apparatus:
http://www.grahamwideman.com/gw/tech/access/accesssec/index.htm
Real World Microsoft Access Protection And Security:
http://www.vb123.com/toolshed/00_accvb/accesssecurity.htm
Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf
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
Steps to Securing an Access Database by Using User-level Security:
http://www.databasedev.co.uk/access_security.htm
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:
ACC97: http://support.microsoft.com/?id=303941
ACC2000: http://support.microsoft.com/?id=305541
ACC2002/2003: 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
http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Access Security”)
http://abcdataworks.com/security.htm
http://www.moretools.com:80/lessons/access_security.htm
Top Top
Creating menu bars and tool bars:
http://msdn.microsoft.com/library/default.asp?url=/archive/
en-us/dnaro97ta/html/ofcmdbar.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us
/dno2k3ta/html/odc_ofcmdbarbest.asp
http://www.access.qbuilt.com/html/forms.html#CustomCmdBar
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/achowCreateCustomMenuBarForCurrentDatabase.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofdccCreateCustomMenu.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofdccAddOrDeleteMenu.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
off2000/html/ofhowAddCommandToMenu.asp
Programming Microsoft Office Command Bars:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/
dnofftalk/html/office04042002.asp
http://www.jamiessoftware.tk/articles/menubars.html
Top Top
Access Replication:
http://www.trigeminal.com/resources.asp?1033
http://www.trigeminal.com/replication/splitrep.asp?1033
How to un-replicate a database:
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm
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
Jet 4.0 Replication:
http://www.mvps.org/access/general/gen0033.htm
TSI Synchronizer:
http://www.mvps.org/access/modules/mdl0033.htm
Synchronization without Replication:
http://www.mvps.org/access/tables/tbl0015.htm
Database Replication in Microsoft JET 4.0:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/dbrepjet.asp
http://geocities.com/jholimpo/
(Click on PDFs on the left side and select “Replication FAQ” and “Replication”)
Sample files available here for study:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number='>http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=
723926&page=9&view=collapsed&sb=5&o=&fpart=1
David Fenton's Jet Replication Wiki:
http://dfenton.com/DFA/Replication
Top Top
Additional Access Forums:
http://www.mdbmakers.com/forums/
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/
http://www.accessgroup.it/
(In Italian)
http://www.officehelp.in/index/index.php/
http://groups.google.com/group/pl.comp.bazy-danych.msaccess?hl=en
(In Polish)
http://forums.devarticles.com/microsoft-access-development-49/
http://forums.microsoft.com/Technet/default.aspx?ForumGroupID=155&SiteID=17
Top Top
Book Recommendations:
http://www.developershandbook.com/
(A VERY good book to have)
http://www.viescas.com/Info/books.htm
(Anything written by MVP John Viescas is a keeper)
http://www.fmsinc.com/toplevel/books.htm
http://www.mvps.org/access/resources/books.htm
Real World Microsoft Access Database Protection and Security
by MVP Garry Robinson:
http://www.vb123.com/map/
http://tinyurl.com/eyvr8
MVP Roger Carlson's list of recommended reading:
http://www.rogersaccesslibrary.com/linksRecommededreading.html
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.oreilly.com/catalog/accessannoy/index.html
http://www.awprofessional.com/title/0321245458
http://www.datapigtechnologies.com/AccessBook.htm
http://safari.oreilly.com/?XmlId=1-56592-358-8&g=paidora05
http://www.mcwtech.com/Books.aspx
http://www.databasedev.co.uk/reading.html
Grover Park George on Access: Access 2000, Access 2002, Access 2003:
http://www.amazon.com/gp/offer-listing/0972425896/ref=dp_olp_
1/104-4187736-4625504?%5Fencoding=UTF8&condition=all
http://www.programmingmsaccess.com/
Microsoft Access 2003 Forms, Reports, and Queries:
http://tinyurl.com/qtur2
Automating Microsoft Access with VBA:
http://www.amazon.com/gp/product/0789732440/ref=pd_rhf_f_2/104-4187736-4625504?%5Fencoding=UTF8
Programming Microsoft Office Access 2003:
http://www.amazon.com/gp/product/0735619425/ref=pd_sim_b_5/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155
Access 2003 Programming by Example with VBA, XML, and ASP:
http://www.amazon.com/gp/product/1556222238/ref=pd_sim_b_3/104-4187736-4625504?%5Fencoding=UTF8&v=glance&n=283155
Microsoft Access 2000/Visual Basic for Applications Fundamentals (Paperback):
http://www.amazon.com/gp/product/0735605920/sr=8-1/qid=1151364032/
ref=pd_bbs_1/002-6087452-1377636?redirect=true&ie=UTF8
Access 2002 VBA Handbook (Paperback):
http://www.amazon.com/gp/product/0782140130/ref=pd_bxgy_img_b/
002-6087452-1377636?redirect=true&ie=UTF8
Sams Teach Yourself Microsoft Access 2002 Programming in 24 Hours (Paperback):
http://www.amazon.com/gp/product/0672320983/sr=8-1/qid=1151363892/
ref=sr_1_1/002-6087452-1377636?redirect=true&ie=UTF8
Top Top
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
Top Top
Access BLOGS:
http://alexdyb.blogspot.com/
http://vb123.blogspot.com/
http://msmvps.com/blogs/access/
http://blog.datamanagementsolutions.biz/dms.html
http://pschmid.net/blog/index.php
http://accessextra.blogspot.com/index.html
http://blogs.msdn.com/access/
http://oakleafblog.blogspot.com/
http://blogs.msdn.com/thirdoffive/default.aspx
http://blogs.msdn.com/clintcovington/
http://blogs.msdn.com/jensenh/default.aspx
http://blogs.msdn.com/frice/
http://accesspro.blogspot.com/
Top Top
Access User Groups/Special Interest Groups:
http://www.paug.com
http://www.pnwadg.org/
http://www.datadynamicsnw.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/
http://www.bostonaccessday.com/
Wellington Office User Group:
http://www.woug.info/
Top Top
Some of the MVP web sites:
http://www.mvps.org/links.html
Top Top
Database Recovery:
Fix Your Corrupt Access Database In 30 Minutes:
http://www.vb123.com/fixaccess/
http://www.pksolutions.com/
http://www.atroplan.com/
AccessFix Software
http://www.cimaware.com/accessfix.html
http://www.accessdatabaserecovery.com/
http://www.msaccessrepair.com/