Tutorial VBA/Access

[Guest]

I'm looking for a Visual Basic (VBA) tutorial on the internet that teaches me
how to use VBA with Access. I'm a frequent Access user and I would like to
have more knowledge about opening an database in VBA, accessing/updating
records, etc.

Does somebody know a good (free) tutorial?

JeroenM

 

[Guest]

http://www.mvps.org/access/toc.htm
http://www.lebans.com
http://allenbrowne.com/tips.html
http://www.Access.QBuilt.com
http://www.accessmonster.com
http://www.mvps.org/access
http://www.pacificdb.com.au/MVP/MVPCode.htm

 

[Jeff Conrad]

Hi,

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.

(A bunch more links just added)


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

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 Deisgn 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://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=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



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



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



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://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



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://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



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



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/



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



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



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! ;-)

 

[Guest]

Thanks, sure I wil be busy for a while.

JeroenM.

 

[Jeff Conrad]

You're welcome.