Is Access the best option?

[adams77]

Hello, I am trying to figure the best option to accomplish the task at hand.

I work for an office that collect union dues for approx. 100 companies.

Currently the company's information is entered in an Excel template. The company's information is then printed on a 3x5 index card with the company's address, corporate address, contact information, job class, business type, probation period, initiation fee, notes, billing period and dues for pay grades. There are some manual calculations that occur based on pay rate, cost of living, and job class.



Currently when the company's information is updated all the information needs to be entered again in the template. I am trying to determine if entering this data in to a database is my best option. The end result would be for the information with the calculation done within Access be printed on 5x8 index cards.

If Access would be my best option, do I have 4 tables containing Company Information, Dues Rate, Special Instruction and Requirements?

Any advice would be greatly appreciated!

Thank you

[rzw0wr]

Access is for storage of data.
It offers many, many options for the manipulation and retrieval of this data.

I would think that a properly setup database would be what you need.

Dale

[ssanfu]

Echoing Dale, yes, Access (or another database program) could handle your requirements. If you do not know Access/programming, it might take you a long time to create the database. Or you could hire someone to create the database for you.

Have you tried something like Quickbooks?

[June7]

Why the need to print to cards? Could just view data on screen.

Might look at the Desktop Contacts template database. Search for the file on the File > Available Templates page of Access. It might be a starting point for you.

[adams77]

Thank you everyone for your input! I will check back in and let you know how the project is coming along. Thanks again!