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: Security bug report?
      ... It is normal that Access needs ... but Access can read the metadata of all table in the database!!! ... it was a possible whole of security and I decide to make ... I open the view in design mode ... ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Security bug report?
      ... permissions that you have revoked or denied; If Access can see schema ... but Access can read the metadata of all table in the database!!! ... it was a possible whole of security and I decide to make ... I open the view in design mode ... ...
      (microsoft.public.access.adp.sqlserver)
    • 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)