Need suggestions for practice material

[watrout]

I've been very frustrated with working with VBA in Access. I've used it with some success but it always seems I'm just stumbling through. Recently I purchased the online courses from VTC and have been fairly happy with the courses. However, I think I need some examples that I have to work through on my own in order to get more comfortable with VBA. So the question is: does anyone know of a good textbook or problem solving resource that gives problems, gives you the opportunity to work through it on your own and then shows you the answers? I have several problems in my own database that need work but many of them are still over my head. I would like to start out with easy problems just to get myself comfortable with VBA.

Thanks

 

[Navyguy]

Hi watrout

I am very much in the same boat (excuse the habit). What I have been doing is just taking some simple instances where I start trying to do something then build on it. I get both allot of ideas and help from this forum. It is an excellent resource and so far everybody is more then helpful.

A couple of ideas that got me going are:

If you work with any community groups, see something that may be useful for them, contact list, item loan out system, training schedule, etc. Take what they are doing and try to make a project out of it and then try to improve it. The benefit is that there is no pressure to "get it perfectly right" and the group is usually more then thankful for your efforts.

As much as some people may disagree, try something for work or school or a friend’s work or school. Again maybe some type of scheduling, preventive maintenance, ordering, etc.

These are the types of things that I am doing to practice my skills, and then when I get an idea, I try to research it as much as possible, (which I need more training on too) and then try to incorporate it into one of my little self made projects.

Food for thought

Navyguy

 

[billyr]

The Northwind application in MS's samples is a good place to start. Lots of forms, queries, forms, etc. I too am a VB "student". I also downloaded many linked DBs from this site, regardless of my interest in the particular problem, just to see and (hopefully) understand the code. This site has made me a hero more than once! Age and experience have taught me that good engineering is not in what you memorize but in what you know how to find.

 

[Mile-O]

It's getting to that time of year when all the lazy students decide that 2 days is enough time to design and build their database project for university before the impending deadline.

Maybe you could build the (by now obligatory) Video Shop database for them; save them the work - they have drinking to do.