Looking for ACCESS course/instruction 2

[TeresePamela]

I'm interested in taking or buying a good "self-teach" course that will cover forms and macros to the advanced level and also ACCESS SQL, a little vba coding wouldn't hurt either.
Can anyone give me the name of some good courses/web sites to check out etc.

Thanks in advance,
Pam

 

[grtammi]

Pam:

You might want to check out

http://www.mindleaders.com

... I don't know if they have any Access stuff there, but it's worth a look.

HTH

Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[MichaelRed]

Visit your local bookstore. There are NUMEROUS text/tutorials re Ms. A. Many/most are accompained by a CD which includes the "Source Code" (and some "complete" database field (.MDB) for their Procedures, as well as reasonably specific instructions for the building of tables, formd, reports, etc. Many will either not cover Macros or treat them as 'orphans' as 'professionals' consider them inappropiate for commercial applications / use.

If you are REALLY uncomfortable with this approach, you could start with the "XX for Dummies" (XX = ACCESS). I ave recommended this to several individuals who were not -and clearly never going to be proficient in any programming environment- and they have at least been able to make (small?) changes to Ms. A. Apps.

Failing even the fall back (Dummies series), check with your local community college. Many / most offer non=credit introductory courses, which are both cheaper and lower level than the commercial courses from the IT (educational) pros.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[BobJacksonNCI]

Pam,

One recommended book is:
Access 2002 Desktop Developer's Handbook
by Paul Litwin, Ken Getz and Mike Gunderloy
publisher os Sybex.

My background is slightly fewer than 1,000 years on mainframes and I was disappointed in the community college Access course that I took. They were mostly into running the wizards and how to exchange Access data with Excel.

HTH,
Bob

 

[TeresePamela]

For BobJacksonNCI:
Thanks Bob, this is what I was looking for - I usually find courses too superficial for what I'm looking for. I have a COBOL (aging myself), RPG, BASIC, dBase, Foxprow background and the company is switching almost everything over to ACCESS. I'm not a full-time programmer and have self-taught the basics, but now need to get a bit more professional. I will definately check out the book and I hope this is not an inappropriate way to reply - I am very uneducated in the use of Forums I'm afraid.

Thanks again,
Pam

 

[grnzbra]

I would recommend

Access 2000 Programming Weekend Crash Course

They also seem to have a 2003 version.

The "weekend" timeframe is just a little optimistic but there are, I believe, 21 lessons geared for 1 hour each.

One of the things I liked about it was their coverage of unbound forms. They have code there for unbound forms that will work, unmodified, with any unbound form.

 

[psemianonymous]

If you're looking for the advanced Access/VBA topics, I'd second the recommendation for "Access [version_number] Developer's Handbook" by Getz, Litwin, et al. Very good, detailed coverage. Includes lots of useful code, too.

 

[Hap007]

Hey Pam,

Here is a link to a 'free' online tutorial for access:

http://www.functionx.com/access/index.htm

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[Terpsfan]

Another good resource is the Access 2000 Bible or Access 2002 Bible...the book takes you through a project from beginning to end. That's really the best way to learn, to build a real project from the ground up. This book also covers unbound forms.

 

[TeresePamela]

Thanks to everyone for the input. I'll certainly be shopping and checking websites this weekend. Hopefully I'll be able to contribute to the site someday soon

Thanks again to all
Pam

 

[Apollo13a]

Pam,
Here's an online tutorial.

http://www.vtc.com/usa.php

It's the virtual Training Company
You have to pay but I believe it is worth it. You can buy just one tutorial or pay $25/month and have access(no pun intended) to all the tutorials covering alot of stuff.
Jim