Hi,
This is for a bike recycling workshop. I need to either find some free software or use MS Office to log the following:
1) Bike model
2) Bike Type
3) Frame No.
4) Sold to: contact details
5) New parts used with cost - also software to add up cost
6) Second hand parts used.
I would like to be able to log a bike in with the above information and also to be able to make changes to 4), 5) and 6) when necessary.
It also needs to be a fairly simple and idiotproof entering system as some of the users are not very competent with PCs.
I have very basic excel and MS Access skills so can anyone suggest a good method please?
This is for a bike recycling workshop. I need to either find some free software or use MS Office to log the following:
1) Bike model
2) Bike Type
3) Frame No.
4) Sold to: contact details
5) New parts used with cost - also software to add up cost
6) Second hand parts used.
I would like to be able to log a bike in with the above information and also to be able to make changes to 4), 5) and 6) when necessary.
It also needs to be a fairly simple and idiotproof entering system as some of the users are not very competent with PCs.
I have very basic excel and MS Access skills so can anyone suggest a good method please?
I thought there would be a way to produce this with Access, however as i said my access skills are very limited. If you have the time or inclination and if it doesn't take too much of your time, any chance you could set up just a couple of the fields, 4) and 5) with a simple form? This would be very helpful and i could use that to build upon. I think 5) would need some sort of subform (like a dropdown list) with prices of parts but not sure how it works!!