building queries

[laynlowz]

Hello my names Ian I am new to this site I am also new to Microsoft Access but I would like to learn to build basic queries.
I am working in a large food distribution warehouse and we currently have some production tracking systems but have no way to create new ones.
We have a warehouse operating system that our previous IT department would use its tables and have access to create production queries.
How would I go about doing this? Is it very advanced?
Such reports would be
user/how many minutes they worked for/how many pieces they picked/then their pieces per hour
Or
User/minutes they worked for/pallets they moved by scanning bar codes/then their Moves per hour.
Any help would be great

[laynlowz]

Also we only have ms access 1997 and we can't get a newer version

[June7]

The queries you describe are aggregate GROUP BY (Totals) queries or possibly even CROSSTAB query. Basic Access functionality.

Search Access Help, search web, get an introductory book on Access, experiment with the Access query builder and wizards. If you want to learn raw SQL syntax, one source is http://www.w3schools.com/sql/sql_intro.asp

[laynlowz]

Do I have to write any code or learn relationships to accomplish this?

[June7]

No macro or VBA code necessary to build a query object. Need to understand data relationships.

Suggest you complete a tutorial from web or get a book.

http://www.rogersaccesslibrary.com/

[nick404]

Find a good tutorial site and run through a few practice projects making a database and querying practice data. That's what I did when I started doing Access stuff over the summer for a company, I had no previous experience. Once you get your feet wet you will be able to better figure out what you need for your business and hopefully learn quickly.