Re: Access 2002 Tutorial

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 17:08:55 -0700

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.

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto

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

Naming Conventions:
http://www.xoc.net/standards/rvbanc.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

5 Rules of Database Normalization:
http://www.datamodel.org/NormalizationRules.html

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

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

Fred Boer's fully functioning library application.
Lots of different topics for study included:
http://www3.sympatico.ca/lornarourke/fred.zip

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.attcanada.net/~kallal.msn/msaccess/msaccess.html

http://www.mvps.org/btmtz/

http://www.jstreettech.com/Downloads.asp

http://www.liquorman.net/Tips.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

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 personal favorite on Doug Steele's site:
http://members.rogers.com/douglas.j.steele/Documentor.html
;-)

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%20Ins

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/AccessSecurity.html

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm

Creating menu bars and tool bars:

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

Additional Access Forums:

http://www.accessvba.com/

http://www.utteraccess.com

http://www.access-programmers.co.uk/forums/

Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm

Some of the MVP web sites:

http://www.mvps.org/links.html

Database Recovery:

http://www.pksolutions.com/

http://www.atroplan.com/

Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2

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

-- 
Jeff Conrad
Access Junkie
Bend, Oregon
"Roberta" <Roberta@discussions.microsoft.com> wrote in message
news:DA861D81-D93B-40A0-893B-7F8C1B699033@microsoft.com...
> I'm new to Access.  Where can I find a online Tutorial to help learn to use access?

Relevant Pages

  • Re: newbie need samples --( with tip of hat to Jeff Conrad )
    ... > Where to find information about designing a database in Microsoft Access: ... > ACC2000: "Understanding Relational Database Design" ... > (See the last download titled "Understanding Normalization") ... > Security FAQ: ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Learn Access
    ... Where to find information about designing a database in Microsoft Access: ... ACC2000: "Understanding Relational Database Design" ... (See the last download titled "Understanding Normalization") ... Security FAQ: ...
    (microsoft.public.access.gettingstarted)
  • Re: newbie need samples --( with tip of hat to Jeff Conrad )
    ... ACC2000: "Understanding Relational Database Design" ... (See the last download titled "Understanding Normalization") ... Security FAQ: ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Installed Microsoft Office...No book, no tutorial, HOW DO I LEARN.
    ... ACC: Database Normalization Basics ... "Understanding Relational Database Design" Document Available in Download Center: ... Security FAQ: ...
    (microsoft.public.access.gettingstarted)
  • Re: I want to learn access
    ... ACC: Database Normalization Basics ... "Understanding Relational Database Design" Document Available in Download ... Database Normalization Tips by Luke Chung ... Security FAQ: ...
    (microsoft.public.access.gettingstarted)
Loading