Any Third party software for access?

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi,

Do you know of any third party party software that can be brought or
downloaded that would make life easy for creating queries or writing sql in
the MS access and other new stuff that I dont know about? This would work
along side access.

many thanks
Bruce
 
There are many utilities for Access, although the Query window in Access has
always been adequate to write and manipulate queries. Try www.fmsinc.com to
start with.
 
Bruce said:
Hi,

Do you know of any third party party software that can be brought or
downloaded that would make life easy for creating queries or writing sql in
the MS access and other new stuff that I dont know about? This would work
along side access.

many thanks
Bruce
Click to expand...

They come and go. I think E.L.F (?) has a natural language interface but
it's mostly for end users.

I always start with the SQL window. In the rare event I can't get what I
want there or need to use it someplace else I just cut the code, paste it in
a module and fiddle with it.

But I've built some powerful and weird stuff with it. (One starts with a
Cartesian set...)
 
I always kept the sql interface hidden to my users.

I am not suggesting that you also do this. In fact, I not sure even if you
are suggesting to hide the sql interface anyway?

I do find that most reports only need a few options. After all, a sales
report generally only needs a few options. Thus, I create a form, and
present the user those options.

Thus, the users never need to know, or even see any kind of sql.

However, you might actually be asking for a sql builder for "you" and not
your users?

Anyway, here is some screen shots of what I do in ms-access in place of
exposing sql to the users, it might give you some ideas:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
 
Back
Top