VBA ressource information ( tutorials, documentation, etc... )

[Guest]

Dear readers,

I would like to have more ease to understand and to use the VBA code in MS
Access.

In other word, could you advise me some tutorial, documentation or learninng
stuff.

Thank you in advance.


PS: May this be useful as a good collection of references.

 

[Jeff Conrad]

Hi,

My pager just went off. <g>

Hold on to your seats for this latest list!!
He....he.....he....

Here's one or two links, grouped by category, to help in your Access qwest.
Please watch out for any possible line wrapping on these links.

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://members.rogers.com/douglas.j.steele/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://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 Deisgn 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

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


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



Tutorial Style:

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

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/select/?selectCourse=IT47&campus=durham
(Sample practice file for download as well)

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

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

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

http://ddmara.tripod.com/access/index.html

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

http://www.simply-access.com/Start_ms_access_tutorials.html

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/Access-Directory/Tutorials/Access-Resources.aspx

Sample Database Models/Table Designs:
http://www.databaseanswers.com/data_models/index.htm

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



Download Samples:

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

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

http://allenbrowne.com/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:

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

http://members.rogers.com/douglas.j.steele/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)


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/



Add-Ins/Utilities:

My five personal favorites (all free):
;-)

"Doug Steele Object Documentor"
http://members.rogers.com/douglas.j.steele/Documentor.html

"John Viescas Table Documentor"
<Awaiting word back from John on the possibility of posting>
<Ask if you would like a copy>

"Albert Kallal Database Statistics"
<Awaiting word back from Albert on the possibility of posting>
<Ask if you would like a copy>

"Advanced Swithboard Manager"
<Coming Soon>

"Another surprise MVP Add-In"
<Coming Soon>

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 Ins

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



Live Access chats every Tuesday and Thursday:
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps



Access User-Level Security:

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 2000 security:
http://support.microsoft.com/?id=305541


Creating menu bars and tool bars:

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



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

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



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


Access Publications:

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

http://accessvbsqladvisor.com/

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



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



Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2


That should keep you busy for a while! ;-)