Tutorials on Access Programming

[mnmagri]

Hello everyone,

Could you guys please point me towards resources on access programming?
I'm very interested in it, and would like to know if it is possible to
achieve connectivity with SQL Server. Anyway, I'd still need the most basic
tutorials.

Thanks for your help,

Marcelo

 

[Dorian]

You can find Access tutorials in Access itself or by using an internat search
engine.
Yes, Access can connect natively to SQl Server or also to virtually any
other database system via ODBC.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[PieterLinden via AccessMonster.com]

Hello everyone,

Could you guys please point me towards resources on access programming?
I'm very interested in it, and would like to know if it is possible to
achieve connectivity with SQL Server. Anyway, I'd still need the most basic
tutorials.

Thanks for your help,

Marcelo

Mary Chipman & Andy Baron wrote a whole book on using Access as a front end
to SQL Server... it's old now, but the information still applies.

http://www.amazon.com/Microsoft-Acc...=sr_1_1?ie=UTF8&s=books&qid=1273078764&sr=8-1


I don't think using Access effectively as a front end to SQL Server is a
simple question... and the book is over 800 pages, so there are a LOT of
things to know/consider... don't take my word for it, though... read the
reviews for yourself. The really interesting one is Michael Kaplan's (MichKa)
, who is a former Access MVP, who wrote a book on Access too.

 

[mnmagri]

Thanks a lot for your reply. I'll take a look at this book. Actually, I won't
be doing miracles with access, it's just something I need to learn to work
with to teach my parents using more resources in their office.

 

[mnmagri]

Dorian,

Thanks for your reply. What I was trying to ask here is for some sort of
directions on better resources for working with access than trying to find
among loads of results from search engines, what I'd expect that people more
experienced than me would be able to say.

 

[ryguy7272]

The best way to start is just start. You’ll make lots of mistakes, learn
from those mistakes, make more mistakes, learn from those, and so on and so
forth.
I think these links age excellent:

http://datapigtechnologies.com/AccessMain.htm
http://www.databasedev.co.uk/
http://www.mvps.org/access/toc.htm
http://www.accessmvp.com/KDSnell/
http://www.fontstuff.com/access/
http://www.techonthenet.com/access/
http://www.rogersaccesslibrary.com/forum/forum1_page1.html

Get a good Access VBA book too. Finally, read old posts here. Recreate the
problem, apply the solution (the posts with little green check marks). I
learned quite a lot doing this!!!

Ryan--

 

[mnmagri]

Ryan,
Thanks a lot for your reply. I'll give a try on those links