Discussion in 'OT Technology' started by ZoRphic, Nov 4, 2003.
How would you go about writing a query in Microsoft Access?
You definately need to try the tutorials - there's enought out there to get you familiar on how to set up the database and write a simple query. If you have a specific problem, that's something I'm willing to help you out on.
rememeber ms access has its own modified version of sql... so if u look for sql help, it may be slightly different....
Like 5Gen said, the sample programs included with Access are very helpful.
also, use the visual query designer. it's a great learning tool.
no. learn sql. its 1000x more stronger and quicker.
MS Access uses Jet SQL.
I disagree here. Visual tools are a great stepping stone. A lot of people who can't code find that learning something visually is much easier. And lets face it, 99% of all queries are coded exactly the same regardless of whether a designer writes the code, or you do.
honestly i find access code builder is bloated, adding extra "features" that isnt required. and its mass brackets are ugly aswell.
something like myphpadmin fucking rocks!
but then my 1st sql experiece was with paradoxx.... 2nd major experiece was with oracle 9i.
What query do u need to write? What version of Access r u using?