Advanced Access tutorials wanted

[Keith Robinson]

Hi Anyone know where I can find some free online Microsoft Advanced (ish)
tutorials or ideas?.
Cheers
Keith

 

[Jeff Conrad]

Hi,

How's this??

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

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



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

 

[Lynn Trapp]

Here's one or two links,

hahaha.... Jeff, you are the master of understatement... <g>

 

[Jeff Conrad]

Too brief you think?

Darn, I hate it when I'm not thorough.

 

[SirPoonga]

/me updates bookmarks

 

[Lynn Trapp]

Too brief you think?

Darn, I hate it when I'm not thorough.

Yeah, I just hate it when that happens too. I may have to "steal" your list
and post it on my website.

 

[Fred Boer]

Dear Lynn:

Well, I'd thank you if you did, Lynn. I have several times wished to refer
to this little list 'o links when answering a question and have had to go
ferreting around in Google groups to find it.

Cheers!
Fred Boer

P.S. And it would come in handy as an example when I talk to my students

 

[Jeff Conrad]

Yeah, I just hate it when that happens too.

Maybe I should have said one or two *hundred*.

I may have to "steal" your list and post it on my website.

You're more than welcome too Lynn.
I would be honored actually.
I do, however, update the list almost weekly.

 

[SirPoonga]

This is sorta funny. A coworker of mine just came up to me and asked
if there was an online way to store a central list of bookmarks. Most
of us use the same websites at home and here and it would be nice to
have one location for them. Thinking of doing a simple access db to
store the bookmarks and some online interface.

 

[Lynn Trapp]

Well, it looks like I have Jeff's permission, so I will probably do that
quite soon. I will just need to work out some way with him to get updates.

 

[Lynn Trapp]

Maybe I should have said one or two *hundred*.

<vbg>
ROFL

You're more than welcome too Lynn.
I would be honored actually.
I do, however, update the list almost weekly.

Well, if you will email me we can work out some details on how you can get
the updates to me. I may be able to just give you access to ftp updates to
the website whenever you make them.

 

[Jeff Conrad]

P.S. And it would come in handy as an example when I talk to my students
about how computer types can get.. uh.. obsessive. <g,d,&r>

Who are you calling obsessive?
Surely not me.
;-)

I *collect* things Fred; I'm a collector see.
Yeah...that's the ticket....

 

[Jeff Conrad]

Well, if you will email me we can work out some details on how you can get
the updates to me. I may be able to just give you access to ftp updates to
the website whenever you make them.

Sure Lynn, I'll send you an off-line message shortly.

 

[Lynn Trapp]

Well, the first installment of Jeff's list is now available on my website.

www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

Cool!
Looks great Lynn!

Thanks for posting the list.

 

[g]

http://books4free.tk/
probably you will find something