Re: newbie need samples --( with tip of hat to Jeff Conrad )

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 08/28/04


Date: Sat, 28 Aug 2004 13:59:43 -0400

A quick google search would display tons of sites.

Jeff Conrad, a frequent poster/replier in these newsgroups, has posted a
long list of sites:

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
-- 
        Ken Snell
<MS ACCESS MVP>
<arch> wrote in message news:4130453a$1@funnel.arach.net.au...
> Does anyone know where I can find some good data access pages
examples/code?
>
>


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 Tutorial
    ... The following link will get you started, as will any good Access reference ... ACC: Database Normalization Basics ... "Understanding Relational Database Design" Document Available in Download ...
    (microsoft.public.access.forms)