Queries website?

[C Tate]

I would like to learn more about queries by seeing specific examples. I
wondered if anybody knows of a website with good examples? The books I have
at home don't seem to go into much detail!

 

[Tom Ellison]

Dear C. Tate:

So your theory is, if nobody put enough effort into a book from which
they hope to make money, then probably someone will have done a much
better job on a web site for free. I'm suggesting your premise may
turn out to be disappointing.

May I suggest going to a large bookstore with an excellent technical
section and spend a number of hours browsing. I usually end up doing
this myself at regular intervals. Anyway, that's my best suggestion.
Spend the time and money to find a book that really fits your existing
expertise and your need. For my needs, there's no substitute for
taking the time, effort, and expense to do this right.

On the other hand, my advice is free, and you get what you pay for.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[C Tate]

Hmm ... interesting speculation! The sad reality is that I am someone on a
low income doing my best to learn Access through the resources which are out
there. Unfortunately I cannot afford to buy many books and the one that I do
have just doesn't happen to cover queries very well. It's as simple as that.

I am slightly disappointed in the tone of your reply, particularly coming
from an MVP. I have not posted much to Access newsgroups in the past.
However, I do have quite a lot of experience of Word newsgroups. I have
always had first class help and advice there. Contrary to what you seem to
be suggesting many people, MVPs included, have built their own websites
which often seem to offer similar (or better) advice than can be be found in
general books on the subject. Just to give you one example, have a look at
http://www.shaunakelly.com/word. Shauna covers Word styles in more detail
than most books I have seen and it all appears to be free!

Clearly not everybody is motivated by money.

 

[Kelvin]

C. There is a very good site that has many examples. I'm surprised Tom
didn't suggest it considering he is an MVP and it is the MVP website.
www.mvps.org Then click on the AccessWeb. You will find many examples of
queries, forms, VBA, and other goodies.

Kelvin

 

[Tom Ellison]

Dear C. Tate:

I can only respond to you regarding my own experience. I have seen
some web sites, quite a few. I have bought books. I have taught
myself a bit about queries. In fact, in my business, the main thing I
do is write the queries. I have others who create the forms and
reports, while I create tables and queries.

I'm not sure what "tone" I used except to answer your question
honestly and directly with all the information I have. I suppose
that, after having reveiwed both many web sites and many books, I have
come to a tentative conclusion that it is a better use of my time to
look through some books to find the training materials I will need
than to spend the time looking through some web sites. Web sites seem
to me to be good at giving tips and tricks, and newsgroups to getting
specific question answered. Neither web sites nor newsgroups are, for
me, an appropriate place to get comprehensive training. I would take
a class, or just get a book that could be described as an appropriate
text for such a class, and learn it there.

I am really saddened that your income does not permit this route for
you, a route that I have found to be most beneficial myself. Perhaps
you would have access to a good library and could still avail yourself
of the facilities I recommend. However, in my situation "time is
money" and I find that a bookstore is a better place to do research
because it takes much less time.

The learning process is very individual. I have tried to tell you
what works for me. Some people are classroom people, some are
book-worms (me) and some learn best from open discussion (like in a
newsgroup). You should customize your learning route to your own
preferences and needs, of course.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[C Tate]

Thanks for your comments Tom. You are probably right - guess I better get
down to the library!