Re: Learn Access

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 07/30/04

  • Next message: George: "Re: Query showing ID not text" 
    Date: Thu, 29 Jul 2004 18:19:12 -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.

    You *should* be able to find 'something' in here to help
    ;-)

    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

    Where to find information about designing a database in Microsoft Access:
    http://support.microsoft.com/?id=289533

    ACC2002: "Understanding Relational Database Design" Document Available in Download Center:
    http://support.microsoft.com/?id=283698

    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

    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

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

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

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

    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

    A massive list of other Access links:

    http://www.geocities.com/waddly/accory.html

    http://dmoz.org/Computers/Software/Databases/MS_Access/

    Add-Ins/Utilities:

    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/

    Live Access chats every Tuesday and Thursday with St. Vinson:

    http://go.compuserve.com/msdevapps?loc=us&access=public

    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

    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/

    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
*294 Days Left*
"Jean Larson" <anonymous@discussions.microsoft.com> wrote in message
news:6dbd01c475cd$c18c9d60$a301280a@phx.gbl...
> Hi,
> I'm wondering if anyone knows of a free tutorial on
> learning Access.  I think I have Access 2000 but a later
> version would probably be OK.  Thanks.
>
> Jean
  • Next message: George: "Re: Query showing ID not text"

    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: 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: Access 2002 Tutorial
      ... ACC: Database Normalization Basics ... "Understanding Relational Database Design" Document Available in Download Center: ... Security FAQ: ...
      (microsoft.public.access.gettingstarted)
    • Re: Form Programming Question...
      ... I'm NOT asking anyone to help me start my database from ... >Manny, ... >(See the last download titled "Understanding ... >Security FAQ: ...
      (microsoft.public.access.formscoding)
    • Workgroups multiple databases
      ... I have an Access 2002 application with a front end and back end database. ... the security on this database to prohibit changes to the data in the tables. ... That would mean Read Data and read Design permissions. ...
      (microsoft.public.access.security)