I need to get a basic database done that will allow me to keep track of some gift vouchers I intend to sell for my company.
I want to have a sequential number series (starting from something higher than 0) and the ability to assign each number with:
Buyer name
Date of Purchase
Date of Expiry (auto fill a predetermined time from date of purchase, ie: we set if it's 6, 12, 18 or 24 months globally and can override that on each individual voucher if we wish)
Amount Purchased
Voucher redeemed checkbox or yes/no
Voucher redeemed by - text box for name and other details specific to the redeemer
Report that will print off the voucher which I can edit to fit my templates
Reports that will print off:
* outstanding voucher details
* expired vouchers
* soon to expire vouchers
* individual voucher details (details of the redeemer of a voucher in case of dispute)
I think that's pretty much it, not a lot in it I know but I don't have the time. I have access 2007 but the final product would be better in 2003 (or compatable) as some of the machines here don't have 2007. Oh, no need for network abilility, would be a standalone database accessed by only one pc.
Thanks
Stephen