[login to view URL]
I have gone through your project requirements. I will create access db for your photography business.
I will include following things Forms and reports..
* Forms
* include a "tick box" once customers have signed a Model release form
* Customers phone number as the ID number
* Customers table so I only have to enter them once (like having an account for each customer)
* Customer details include picture of customer
* Suppliers details
* Reporting by customers purchased and business profit
* Payment type/balance etc.
* Profit made on Packages purchased (per day/ per week / per month / per year)
* Gift vouchers with 6mth automated expiry date
* Email button to notify customers when there prints are ready to pickup
* Calendar for Bookings linked to outlook
* Extra items orders outside packages
* Hiring of props - customer name, deposit, payment type, balance, date, description of prop
* Studio Hire - customer name, deposit, payment type, balance, date, time
* Print costs per size
* what prints are included in each package and profit per package
I will do the job within 3 days only
Thanks for your time
Regards
Prahsant