Access 2010 Work Roster

[easygoingdave]

I have put together a monthly work roster in Excel 2010 for a small security company. It works quite efficiently, but they now want to produce weekly/ monthly client invoices, staff hours and numerous other queries. Their requirements and now pushing me towards an Access Db, which I am not too familiar with but am willing to learn. I have 2 question:

1. Is it possible to produce a monthly work roster inputting the staff hours on a daily basis and also produce a snapshot of staff hours per day?
2. I know I can import data from Excel, would this be a more efficient way to met the clients requirements?

I have been advised by a colleague that Access is the ideal application for my clients requirements. However, when I Google 'MS Access 2010 work roster', very few links/examples are shown.

Dave

 

[Mr. B]

Beiing an Access Developer with years of experience I would immediately say that Access is the perfect place for the "Work Roster" type application you are describing but that simply means that I feel comfortable starting the project and completing the project.

One of the first things you need to understand is that Access tables are not just more Excel spreadsheets. Access is a relational database and therefore the structure that is created to support the application is absolutely critical.to the performance of the application. Do your homework on Relational Databases.

With that said, please understand that for the beginner, MS Access can and will present a rather large learning curve. While not insurmountable, it is, to say the least, a challenge. If you are up to the challenge then I would say you are on the right track.

You can post your questions here and there will be many folk who will be glad to try to assist you. I would suggest that you start by designing your schema (table structure). You will find plenty of help here on this subject. Make you favorite search engine you best friend and when you have questions, just start asking around.

Although I do not have a specific example or template for this type of application, I feel sure it would not be hard to design at all. Once you have your schema designed, then you can start to develop a user interface that will provide your uses with the opportunities needed to use your application in the appropriate manner.

Hope this helps.

 

[easygoingdave]

Mr B. Many thanks for your encouraging words. I have had a dabble at Access and do have a basic understanding. My Client (daughter) will have no choice but to wait until I have mastered the intricacies of Access. Thank you again, and I am sure I will be using this forum to solve many of my future problems.

dave