I want to learn access

[Guest]

This is my second post. Thanks all of you for taking the time to teach me.
Basically I am a doctor, an Intensivist (Critical care specialist). I have
been tinkering with filemaker Pro 7.0, Alpha five v 6.0 and access, and so
far with some knowledge of databases, that I have, I realize what I lack
towards making a successful database application with no fromal trainnig in
computers is that I do not have practical guidance. I know how to play with
the software, minus VB, since I have read these wonderful books, (bible in
access 2003 , bible in Filemaker etc ), but I was looking for some books or
CDs that assume that you know how to design forms, tables, etc, which I know,
and they have some 10 projects or so, which I can design on my own and
compare with the author's development and learn where I am going wrong in my
planning the database/
Can anybody guide me here, does anyboy know and such books/ Like I said I
already have the bible for access 2003. All the books that I have seen on the
market only teach you how to work with the innards of access, but none teach
you how to develop real time appliactions ( I need to practice some 5
applications or so ). I am even ready to preapre applications for people out
here for FREE (whatever level I can ) so I can learn access. And I am
desperate to learn access. I am based in India.

Thanks in advance ,
Dr Alok Modi MD

 

[Wayne Morgan]

Try the "Access -year- Developer's Handbook".
www.developershandbook.com

Also, "Microsoft Access 2003 Inside Out". This will have some information on
creating forms and reports, but also has a lot of information on how to set
up the database properly.
http://www.viescas.com/Info/books.htm

 

[tina]

you've learned a lot of the basics of using the Access software effectively,
which is a good skill foundation for you. here's one good book for learning
"data modeling", which is the foundation of any relational database
regardless of what software you use: Database Design for Mere Mortals by
Michael Hernandez. the book teaches you how to analyze your process, break
it down into data elements, and create normalized tables with appropriate
relationships. you can also google "table normalization" to find a number of
websites addressing these issues. having learned to correctly structure the
foundation of a database, you'll be well-positioned to learn more advanced
development techniques using the Access tool.

hth

 

[PC Datasheet]

Doctor,

I am in business to provide customers with a resource for help with
Microsoft Access, Excel and Word applications. You can view my website at
www.pcdatasheet.com. If you are interested in one-on-one tutoting, please
contact me at my email address below.

 

[Larry Linson]

This is my second post. Thanks all of
you for taking the time to teach me.
... so I can learn access. And I am
desperate to learn access.

Some of the highest quality Access code I've ever seen was written by a
specialty surgeon who just could not find appropriate software for the
purposes needed.

Not long ago, Jeff Conrad posted the following. It is as extensive a list of
Access resources, many of them free, as I have seen. He kindly gave me
permission to quote it.

Hi Julius,

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/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

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/wcblurb060600.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_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

http://www.rogersaccesslibrary.com/Tutorials.html

Tutorial: Analyzing Data Using Access
http://www.microsoft.com/education/AccessTutorial.aspx

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 Ins

http://www.skrol29.com/index.php?lang=us


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/AJMAccessSecurity.pdf

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 signs himself as Jeff Conrad, Access Junkie, Bend, Oregon (USA)

Larry Linson
Microsoft Access MVP

 

[Cam Edge]

Hello
I am from Canada (Ontario) and I am very willing to help
you learn what Access I know - I love designing
applications for different needs. If at all possible,
could you zip the file you are are working on and give me
an explanation of what you wish to do in Access and send
it to me - I can then look at what you are trying to do
and I will make recommendations for you and show you how
to do them - email address is as follows (e-mail address removed) -
I will help you.

Regards

Cam Edge

 

[Jeff Conrad]

Some of the highest quality Access code I've ever seen was written by a
specialty surgeon who just could not find appropriate software for the
purposes needed.

Not long ago, Jeff Conrad posted the following. It is as extensive a list of
Access resources, many of them free, as I have seen. He kindly gave me
permission to quote it.

<<Resource List Snipped>>

Hi Larry,

Thanks for the assist; I have been out of town.
FYI, I add to the list almost weekly.
To have the most *updated* posted list, just Google
on my name in the Access NGs and include the word
qwest. After the search is complete, switch to sort
by date to have the most recent post at the top.
Then you'll know which list is the most up to date.