Quite a long term project I am looking for here.
The designer will be an EXPERT, yes I mean an EXPERT in MS Access. Not someone that has a bit of experience, but a very accomplished designer with experience in MS Access.
I am looking for a database to be designed for a nightclub website, a secure database available only to staff, password protected etc etc.
It will allow us to enter details such as emails, phone numbers etc of contacts for 'customers' and other contacts such as promoters, bands etc etc.
We should be able to generate queries producing us lists of upcoming birthdays etc and if possible we would like to generate automated emails promoting events and advertising birthday hire of the club to those with upcoming birthdays.
Also to plan events with use some sort of calendar system to organize events so we can see clearly what is happening on any one day.
It should have a fool proof menu, easy to operate.
The website should contain a public form so that 'customers' could input their data into the 'customer' database.
Creating filters etc should be simple.
This project will lead to much further work enhancing what I want and developing it further.