Table Set Up

C

Chance

New to Acces Need HELP!! I want to build a data base that
will track job cost. I need help in figuring out the best
way to set up the tables. I have a current way of tracking
it in excell. I use 3 data sheets and then one summary
sheet. I want to use access for it's abilty to use forms
and reports. The colums for the sheets I use are as
follows:

PO LOG: Date, PO#, Vendor, Description, Cost, Ordered By,
Category

Rental Log: Item Description, Vendor, PO#, Start Date,
Stop Date, Stand by days, Min. Charge Amount, Min Charge
Days, Additional Daily Charge, Additional Days, Current
Cost, Estimated Stop Date, Estimated Days Left, Forecasted
Cost(It does the calculations from the current date for
current days used and for the forecasted cost)

Payroll: Day#, Date, Position, Hours, Total

Thanks,
Chance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top