Completed

Microsoft Access- Create a Data Bank - repost

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...)

Skills: Microsoft Access, Sharepoint

See more: create bank project access 2010, who need data entry operator, visual basic 6.0 programming language, vba programming using excel, vba programming language, vba programming in excel, vba excel programming, track 1 data, the usability company, sql programming language, sql programming in vba for excel, sql programming course, sharepoint programming language, sharepoint company, programming operator, programming in visual basic 2010, programming in vba, programming in excel vba, programming in excel 2013, programming in excel 2010, programming in access database, programming in access, parts database access, microsoft visual basic programming, microsoft programming language

About the Employer:
( 2 reviews ) Berlin, Germany

Project ID: #4348390

Awarded to:

jeanek

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 More

$2100 USD in 30 days
(3 Reviews)
3.3

22 freelancers are bidding on average $2111 for this job

fastudiovw

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

$2800 USD in 20 days
(622 Reviews)
7.1
mahinthan86

Dear Sir, Please check the [url removed, login to view] for more information and discussion points.

$2500 USD in 30 days
(18 Reviews)
6.0
kulhanekd

I have 15 years exp in access. I have built many databases in this time. I would like the opertunity to build your database. Donna

$1700 USD in 30 days
(34 Reviews)
5.8
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 More

$2000 USD in 15 days
(26 Reviews)
4.6
rakib062

Please check private message.

$1700 USD in 20 days
(1 Review)
3.4
feninsoftech

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 enviro More

$2000 USD in 30 days
(2 Reviews)
3.3
paris2785

Consider it done! I am fully qualified

$3000 USD in 10 days
(3 Reviews)
3.1
aptecpymefree

We can work in your Microsoft Access- Create a Data Bank. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in Software development W More

$1900 USD in 40 days
(1 Review)
3.1
vickkey7

I am ready to start this project....... thanks

$1500 USD in 10 days
(1 Review)
3.0
skapsl

HI, I'm ready to start the project, but request you to read the message I've sent you. Thanks SKAP

$2250 USD in 30 days
(4 Reviews)
2.9
anomanpk

I would like to offer my services for this job.

$2250 USD in 30 days
(1 Review)
1.3
Caedu

Profissional with large experience in access development, ready to begin now!!

$1500 USD in 3 days
(0 Reviews)
0.0
LightITGroup

Hello! We're interested in taking up your project. Please PM us and we'll discuss the details. Thank you!

$2000 USD in 45 days
(0 Reviews)
0.0
amusto

.NET expert developer. Please isit my profile.

$2250 USD in 3 days
(0 Reviews)
0.0
adiprisacariuvw

Hi, I can do this in .NET using SqlLocalDb 2012 if more stable. What do you think?

$2250 USD in 3 days
(0 Reviews)
0.0
oplalchandani

Hi I have worked on a lot of similar projects and delivered quality work on time

$2250 USD in 15 days
(0 Reviews)
0.0
MohanParamane

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 messag More

$1991 USD in 20 days
(0 Reviews)
0.0
myteknologi

I have experience for data entry use microsoft acces, such as vehicle data for my province..

$1500 USD in 5 days
(0 Reviews)
0.0
Colaninfotech

Hello, Please check your PMB to know more about Colan Infotech.

$4000 USD in 30 days
(0 Reviews)
0.0
mneo

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,

$1500 USD in 21 days
(0 Reviews)
0.0