concept address database
Programming language: Visual Basic
general architecture:
• enterprise windows domain environment
• local database application in Access 2010 - 32bit or 64bit version English – using VBA and SQL
• tables on a central SharePoint 2010 server (published to SharePoint-lists)
• user the current NT-user as database user - simple table in the database whether a user is allowed to use it or not
• use of the Hungarian Notation
• clear documentation in the code and tables / so that a 3rd person can follow the procedures and ideas
• track record who added, changed or deleted a record
• track record of all changes (old value, new value)
User
Procedures
Add, change, delete companies
Add company:
1) check wether already existing (along name, postal code, street / give a message, if a similar entry exists
2) add the record
3) check mandatory entries
4) start procedure to add
1) sales person
2) categories
3) flags
4) contacts
Add, change, delete contacts in companies
New category or flag and assign category or flag to companies
1) define category or flag
2) filter per company cats and flags
3) add the new campaign flag to the filtered and selected company group
4) filter companies that HAVE the new cat or flag
5) filter companies that DONT HAVE the new cat or flag
6) always give the option to select and unselect contacts and add or remove the new cat or flag
New category or flag and assign category or flag to contacts
1) define category or flag
2) filter per company cats and flags
3) add the new campaign flag to the filtered and selected contact group
4) filter per contact cats and flags
5) add the new campaign flag to the filtered and selected contact group
6) search for company name
7) filter companies that HAVE the new campaign flag
8) filter companies that DONT HAVE the new flag
9) always give the option to select and unselect contacts and add or remove the new flag
Export AND flag
This procedure
1) select a list of companies or contacts
2) export this list to EXCEL
3) flag those companies or contacts wit a NEW flag (with a customisable name)
in general
Log all changes in all records
1) date
2) name of user
3) field name
4) old value
5) new value
Tables:
The central point of the database is the company table. Every information stored in the database connects somehow to a company. The needed database fields are like this PLUS “Country”
Category (industrial, commercial etc (1toMany))
Flag (doNotContact, inEndCustomerPromotionList etc 1toMany))
Contacts in Companies (1toMany)
Category (DecisionMaker, Technical, Operator) (1toMany)
Flag (Campaigns,...) (1toMany)
Connected to this company we need several 1toMany connections
Equipment (1toMany)
We need a flag list per company – with many flags per company. Those flags are supposed to be in groups.
We need connections to Sales people – 1toMany. With one MAIN contact per company!
As important as the companies are the contacts in the company. Of course many in one company!
This contacts needs FLAGs as well. eG.: “Main contact” “decision maker” “do not contact” and so on. Those should be in groups as well (whats missing in the table ex. below – please add)
The usability is crucial. I would prefer interface similar to this concept:
We can search in filter with some free text and some selectors (e.g. for the flags) – and this in various combinations.
Adding and removing from flags should be in dialogues like this:
Language will be English – those examples are partly in German – sorry
Project is divided into 4 parts:
1- Implementing all Company related parts
2- Implementing all Contacts related parts
3- Implementing all Sales Person related parts
4- Implementing other parts (like flags, category, export and etc...)
Good day. I am a database expert with a UK BSc. Computing degree, and over eight years of professional IT work experience. I would be very glad to assist you with this project. Kindly forward the project description as an attachment so as to include the sample data, example dialogues and tables referred to in the project description. Further information regarding my bid is available in the accompanying private message. Thank you. Kind regards.
$2.100 USD en 30 días
5,0 (5 comentarios)
4,9
4,9
21 freelancers están ofertando un promedio de $2.104 USD por este trabajo
Hello
Me an Ms-Access Expert working on MS-Access & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample copies if you so desire. U can expect quality work in time.
Thanks
Hi,
I have 8 years experience in ASP.NET, SharePoint, C#, Access and SQL Server. We can design web-parts for each of your entity.
Please discuss for more details.
Note: I don't have SharePoint development environment so you need to provide the same. Actually i am working with a MNC and here doing only part time work.
Hi,
We are Pune (India) based firm working since 1996. We are a team and we will complete your work in time. We provide online support for software and customer satisfaction is our goal.
Please see the private message box.
Regards
Hi,
I can do this as per your requirements. I have good experience with the related technologies - Sharepoint, VB and MS Access. Please let me know via PMB if you would like to do a prototype first.
Regards,