Question Crash Course on Access?

[accessuhoh]

Heya,

I recently got a position that involves building in-house access applications. I mostly got this position because I am overall pretty computer savvy and because I know someone who works there.

However, here's the problem: I have very, very little experience in Access as far as building applications via macros/VBA. I have experience in other programming languages, so I understand the concept and thought process behind programming(or scripting in this case, I guess).

So, basically, what I'm asking for and really, really need is an online tutorial series (preferably written, I'm far and away my best teacher) that covers macros/VBA for Access.

I know, I know, it's ridiculous that I managed to land a job without actually knowing how to do it fully, but I am fully capable of and willing to spend the next month studying 6-8 hours a day.

Thanks!

 

[Severin]

Do you know about designing a relationsdiagram on a piece of paper?

 

[Steve R.]

A good place to start, the bookstore.
Amazon books on Access

I liked the book below, it was especially helpful. However, note that it was published in 2002.
Access Database Design & Programming (3rd Edition)

 

[jdraw]

The first few topics here will give you some basics on database design. And that is key to your use of Access applications. The coding/scripting is important to manipulation and editing/validating data, but relational database design is a whole new ball game to a programmer.

Normalization, ER Diagramming and the 12 steps to Better databases are critical
http://www.rogersaccesslibrary.com/forum/topic238.html

Also on the Roger's site are many useful examples.

Lot's of practical free video tutorials at
http://www.datapigtechnologies.com/AccessMain.htm

Best Access Tips and other key info at
http://allenbrowne.com/tips.html

 

[Pat Hartman]

My favorite is the Access Cookbook.
http://www.amazon.com/Access-Cookbo...id=1351879406&sr=1-1&keywords=access+cookbook

I'm hoping that someday Ken updates the book again for A2010 or possibly A2013 since that is almost here. In any event, VBA has changed little so the majority of the code is useful today. Just ignore the Security, ADP and DAP areas since they are deprecated and no longer avalable.

 

[KenHigg]

My favorite is the Access Cookbook.
http://www.amazon.com/Access-Cookbo...id=1351879406&sr=1-1&keywords=access+cookbook

I'm hoping that someday Ken updates the book again for A2010 or possibly A2013 since that is almost here. In any event, VBA has changed little so the majority of the code is useful today. Just ignore the Security, ADP and DAP areas since they are deprecated and no longer avalable.

I like that book as well Pat - and I met Ken in Phoenix in '08, nice guy!

 

[accessuhoh]

Awesome guys, I really appreciate it. I'm gonna go ahead and order one or two of the books linked here and start reading through the online material. I also found some CBTs on Access that look pretty promising.

I know how access works outside of the programming section; I've used, built, and updated databases, I've just never dealt with the data manipulation/macro side of access.

 

[Lightwave]

There are a significant number of people who tend to avoid the macros...

But they can be useful for specific tasks and I believe MS increased their focus on them in 2007 and 2010

 

[boblarson]

For more online tutorials for others who may be looking,

http://www.functionx.com/

they have both Access and Access VBA tutorials and they are quite thorough in all of their tutorials. They also have SQL Server, Word, Excel, .NET, XML, Java, and much more.