Access 2003

[aquias]

Alright, I'm going to preface this by saying I know a minute amount about Relational databases and SQL queries...so there may be many silly questions to follow.

I'm working on a database for work (I'm the sole technical contact here) to help track and control people's time off. I have my data structure set and have moved onto the next phase, creating my scripts. Now, I need to know a few things prior to moving forward.

1. How advanced can I get with SQL in Access?
2. One of my goals is to autopopulate a few fields based on hire date vs current date, can I setup a query in access to do this?
3. If the above is yes, can someone give me a hand in the how?

I'm certain I'm going to be back here bugging all of you a great deal, so let me say thank you all for any assistance you can provide.

Oh...and before you ask, I'm sitting here with an Access 2003 book on my lap flipping all over the place to try and get the rest of my queries in place

 

[aquias]

Ah, should have added this bit here to.

What I want to accomplish with the dates, exactly is to compare the current date with hire date and calculate the years that person has been working here. Time off is based on three factors, hours scheduled to work, Union vs Non-Union, and years worked. Right now this is my biggest hurdle (if I could get the query to return with a base number like 3, that would work ideally).