Lukket

Microsoft Access- Create a Data Bank - 1st Part

concept address database

general architecture:

• enterprise windows domain environment

• local database in Access 2010 - 32bit or 64bit version English

• tables on a central SharePoint 2010 server

• user the current NT-user as database user - simple table in the database wether 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 (Deadline: [url removed, login to view])

2- Implementing all Contacts related parts (Deadline: [url removed, login to view])

3- Implementing all Sales Person related parts (Deadline: [url removed, login to view])

4- Implementing other parts (like flags, category, export and etc...) (Deadline: [url removed, login to view])

This bid only relates to the 1st part of the project!

Færdigheder: Microsoft Access, Sharepoint

Se mere: simple date entry, track data, usability company, sharepoint company, parts database access, microsoft excel group, microsoft excel windows, microsoft access parts database, need free sales person, industrial bank, industrial architecture, free data entry course, equipment operator, define data entry, data access interface, company maker, company free log maker, clear search fields, change english german, access parts database, access group, microsoft project free, free excel course, excel course free, sales data entry operator

Om arbejdsgiveren:
( 2 bedømmelser ) Berlin, Germany

Projekt-ID: #4059449

12 freelancere byder i gennemsnit $621 for dette job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$680 USD in 10 dage
(613 bedømmelser)
7.1
qitsol

We are sharepoint experts.

$1500 USD in 15 dage
(28 bedømmelser)
5.7
sahanganepola

Dear Sir, I have completed several SharePoint portals and i have the necessary knowledge to complete the project.We have a team of 5 SharePoint developers. We can use our team to speed up the development process.I'm Mere

$600 USD in 10 dage
(9 bedømmelser)
4.6
es1496

Hi, I have 8 years of SharePoint development experience. Interested to work on this project. Please my message for more details. Thanks

$340 USD in 25 dage
(1 bedømmelse)
3.3
MajidAsgari3

please check your Pm

$630 USD in 12 dage
(2 bedømmelser)
2.9
emakis

With over of 20 years experience in the data manipulation/reporting in the field of client/server environments, I have done a number of similar projects in msAccess. So I think i can done your job in time!

$600 USD in 11 dage
(1 bedømmelse)
2.6
FcsMiranda

I am ready for the project.

$750 USD in 15 dage
(1 bedømmelse)
0.0
cynamador

My name is Cynthia, and I feel I may be a great fit for your project! I am an Independent Contractor; I work alone and put all my focus on providing key services and apply exceptional skill sets for your project! Mere

$625 USD in 15 dage
(0 bedømmelser)
0.0
KellogITSolution

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 c Mere

$550 USD in 7 dage
(0 bedømmelser)
0.0
MSDev2012

Dear sir , I have Solid experience in database + 7 years as DBA thanks

$250 USD in 10 dage
(0 bedømmelser)
0.0
hbxfnzwpf

I am very proficient in several kinds of db, like ms access, oracle db, berkeley db, and mysql. And I have 4 years of working experience and 10 years of programming experience, I can fulfill your task without any quest Mere

$400 USD in 10 dage
(0 bedømmelser)
0.0
trushalin

Dear SIR, I am currently employed as Software Developer for Alfatech Solutions Nagpur. I am interested in the position because of the emphasis on the Design and Developing skills which are applicable to your require Mere

$550 USD in 55 dage
(0 bedømmelser)
0.0
MichaelSDeVries

Dear Theres, I can help you quickly and cost effectively design and develop a Microsoft Access database/system that satisfies all of your requirements for your Data Bank. I have been designing and developing Micr Mere

$600 USD in 14 dage
(0 bedømmelser)
0.0
johnsalzman

I have more than 20 years experience in database design and creation in both large and small scale environments. I would be pleased to help make your business more productive and successful.

$250 USD in 9 dage
(0 bedømmelser)
0.0