We are interested to build a MS Access project, that will allow customers and contacts management. The idea is to have one ease to use database to ask "give me all customers who work in <X> field and are located in <Y> place".
Please do no propose a stand-alone application. We are interested to be able to change the project through Access interface in the future.
Detailed requirements (like required fields) provided below.
Please take a look in the detailed requirements section if you are interested.
Coder must speak fluent English and have the required knowledge.
Thank you.
## Deliverables
We need 2 main facilities:
1. Data entry: Usual forms to enter data
2. Search contacts. Contacts will be search using all available fields. AND logic should be in use when combining multiple fields. After searching, a grid should display the contacts that fulfill the criteria. Then these contacts could be:
a. Edited
b. Copied to clipboard all email addresses (with one button)
c. Printed as envelope labels (labels for sending regular mail) (other button)
Here are the fields for each contact:
Name, Surname, Work, Internal Code, Company, Position, Phone1, Phone2, Fax, Mobile, Source, Address, Postal code, City, Prefecture, Region, Country, email1, email2, website, Contact_Way (email or mail), Type, Comments, Attached MS-Word document.
Some of them will take specific values (foreign keys - typical 1 to many relationship). Like: Prefectures, Type, Region.
All these types will be provided.
In labels printed, we need for each label:
Name Surname
Title
Address
City
Prefecture
Region
Some fields might be removed/added after first deliverable.
We need the application to be ready to open in a desktop icon. This icon will open a switchboard. The switchboard will provide: "Search", "Add new" buttons. User should not be able to see most Access toolbars etc. when opening the app.
Please ask any questions.
Thank you very much.
Best regards.