Advanced Access tutorials wanted

K

Keith Robinson

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

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

Lynn Trapp

Here's one or two links,

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

Lynn Trapp

Too brief you think?
Darn, I hate it when I'm not thorough.
Click to expand...

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

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
 
J

Jeff Conrad

Yeah, I just hate it when that happens too.
Click to expand...

Maybe I should have said one or two *hundred*.
I may have to "steal" your list and post it on my website.
Click to expand...

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

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.
 
L

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.
 
L

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.
Click to expand...

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.
 
J

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>
Click to expand...

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

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

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.
Click to expand...

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