Thread: Newbee needs a good book recommendation

I am somewhat familiar with many aspects of access now but am having trouble pulling them all together. Do you know of perhaps a good textbook where it gives someone assignments to just make a sample database tables queries and forms etc. I think that all my books are exhaustive on the sujects and reference oriented, making them dry and leave little room for experience by actually building a database. Necessary as they may be, I was hoping for a good compliment that would give me exercises and actually build some databases.

Have you also checked out the tutorials at

Tutorials From FunctionX

There are a couple of really good in-depth tutorials on Access 2003 and Access 2007 there.

Also,
Access 2007 Inside Out is a good book.

Bob Larson
Access MVP

I was using the 2003 of inside out and out of all of them I liked that the best. By that point I had been through so many others that I skipped around to be true in inside out and I just cant comb through another one of these books. Like I said I was hoping that there might be an exercise book taylored toward just letting the person make one of a few databases. Thanks though for the recommendation.

Microsoft Access 2003 Step By Step was an ok book.... still a little on the dry side....

On a side note; why don't you figure out a couple of databases you would like to build, and we could help you along the way, or at least point you in the right direction.

that sounds like a good idea. Allow me to expound on it a lil. I think we should start a new thread and then you and I can go through steps - this way any subsequent newbee that happens along can reference this. What I am hoping to do is something that will have a many to many relationship. Show that on a form and maybe any common vba stuff that might go along with it. lastly I want to be able to gather info from a child table and update the parent table's info. For right now those are my needs.

As a side, I think there are alot of people who are excel graduates like me. Access takes so much preparation and instruction just to get the whole picture. In excel one can have delivery of the information that they seek almost immediately. Access (though I am getting how this structure is superior) requires many different steps before delivery. and having to learn all those steps has gotten very boring after 400 pages of every little detail.

Lets make a Grocery list database. Items table, Store table, shopping centers. This could get a lil complicated because one item could be bought in many kinds of stores and then if the store is a chain it can be bought in many different shopping centers. So when you leave the office one can decide to leave in a different direction, query the database and since they will be in a particular shopping center that may have other things then one can multitask. Good idea? Too complicated?

Let me know what you think?

Well, I'm all for helping out..... the first thing you need to do, is figure out what kind of data is going to be collected, and how you want that data manipulated. I call this the pen and paper stage. If you're going to make a complicated db, it's best to put it all down on paper first. Making sure that you're not missing anything

Ok and Ill just start it in a new post thanks.