I need a database designing and building. The database will store about 100,000 records, each record will have the following data:
Shipping Address 1
Shipping Address 2
Shipping Post Code
The final four items marked * could have around of 30 items (although this is unlikely with the normal amount being about 5)
I need the ability to insert new records via a spreadsheet which I wish to upload via a web browser.
I need a frontend building for this which will give me the ability to be able to:
1) allow multi user log in
2) search the database based on any of these fields: Invoice No, Invoice Name, Post Code, Amount
3) list records by date range
3) list records by Invoice No
4) update/modify the fields from a web browser
5) send customer an email from a pre defined email template
I hope I have explained myself, but if you have any further questions please let me know.