Access Database

I need a MS Access Database made that is wholly [login to view URL] will be several different databases (or 'tables). Security is big as well.I would like to discuss with the security of access in storing confidential data ie credit cards. One table is a simple customer details, with their name, phone number etc and the name of the sales person who got their account. Table Two provides a details of the client's billing and activity, ie Date they signed up and how many charges since. Most charges happen automatically fortnightly and I would like the system to handle this for me, with ability to add additional charges. Table Three is about the Sales Person, showing their Details as well as accounts they have brought in. It can calculate total revenue generated on new sales, total customers, commissions etc. I need a way where I can specify the profits, commissions, expenses etc of all packages sold. Another Table coming off the Sales Person is daily reports, indicating Day Worked, Hours Worked, People Seen, Customers, Leads, Etc. Any leads entered will need to go in another table (or whatever you suggest) with simply their 'Name, Number, Sales Rep, Other Details'. Table Four shows customer activity in attending functions. Customers are invited to fortnightly meetings and I need to be able to check attendance. This can be merged elsewhere. Table Five shows profit loss based on Sales Expenses (Income - Rep Commission) and other statistics. I also need the ability to see account age, as every 12 months my customers attract an additional renewal fee. I am unsure if these are all of the right tables required and in that order - I am open to suggestions. The database needs to be easy to use and I should be able to click between all areas while browsing to pull up required customer information. To give perspective and due to word Limit I have included a .doc outlining basic service info for your perspective. If you have any questions feel free to ask!

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows, Microsoft Access

Ingeniería Microsoft Access MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3285186

Sobre el proyecto