Is Access the right progrem for my needs?

[Jiveman]

HI,

New to access and, of course, the forum. i work in a small office. we have about 40 employees, and each day we rotate assignments. an employee can work in the warehouse one day, then the sales floor the next and so on. i built a simple excel form which will allow us to track qualifications, and make sure that only people qualified for a certain job can be assigned to it. pretty simple job, nothing fancy.

Now i want to create something much more complicated (for me at least) - create a spreadsheet/database that will allow me to track on a quarterly basis how many times each employee has been assigned to a specific area, how many times he has been supervised in a time period (quarter, year etc.), how many sick days they took and so on. Excel seems the wrong program for that, and from what i've heard Access is much more suited for this task. i got the Microsoft "step by step" guide, but before i invest too much time into familiarizing myself with an entire new program and building my database, wanted to ask if I'm even using the right program....



any answers/tips will be extremely appreciated!

Eran

[Homegrownandy]

Access can be as simple or as complicated as you make it. In my opinion its easy to learn, hard to master. Once you understand relationships and how to handle the data you can make a simple system that would do what you want.

I would go for it if I were you

[NTC]

Yes, based on your description the Access database will work. Really the question is generic - will a database work? - and the answer is yes. The next question then is which brand of db. Access is far & away the best PC based database available today.