|
A very good example, Northwind.MDB, comes packaged with Access and will have
been installed in the folder hierarchy where you installed Office, unless
you opted for a custom install and omitted it. There is a very useful Orders
and Solutions sample database, temporarily housed at
http://www.mvps.org/access/downloads/bapp2000.exe. Many of the samples in
that database refer to Northwind.
If you are using Access 2003, follow the link in Help to Office Online |
Training, and follow the links there to specific topics. You'll find a
number of useful, thankfully brief online training courses. If you are not
using Access 2003, most of the material will still apply, and you can go
directly to http://office.microsoft.com/en-us/training/default.aspx.
Larry Linson
Microsoft Access MVP
P.S. Here's the body of a post from late last year in the
microsoft.public.access.gettingstarted newsgroup, by Jeff Conrad, a
self-confessed Access Junkie, who did us all a great favor by collecting and
posting these links:
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 definitely find one or two
things in here to help
you. |g|
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/standardsvbanc.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/w
cblurb060600.asp
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_i
ntro
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
Tutorial: Analyzing Data Using Access
http://www.microsoft.com/education/AccessTutorial.aspx
Sample Database Models/Table Designs:
http |
|