Access Database Needed

Slutfört Publicerat 6 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

My company needs to build an access database to handle clients and progress them. We must be able to export all the data to Excel.

The database must be user friendly.

A number of the entries will need:

1. Drop down options

2. Date

3. Simple calculation

4. Automated Client ID

5. Currency in GBP

The quote must allow for testing of the database fixing problems for upto 1 year for free.

There will be on going work when needed and an agreed set price for edits within that may need to be done later on.

Clients Details

• Client ID Number (Automated)

• First Name

• Last Name

• Company Name

• Email Address

• Home Number

• Mobile Number

Client Interaction

• How Did The Client Make Contact With Us (Drop Down Option)

• How Did The Client Find Out About Us (Drop Down Option)

• What Is The Best Way To Contact The Client (Drop Down Option)

• What Is The Best Day To Contact The Client (Drop Down Option)

• What Is The Best Time Of Day To Contact Client (Drop Down Option)

Correspondence Address

• Address Door Number/Name

• Address Line 1

• Address Line 2

• County

• Postcode

Property For Sale Address

• Address Door Number/Name

• Address Line 1

• Address Line 2

• County

• Postcode

Key Property Information

• Type Of Property (Drop Down Option)

• How Old Is The Property (Drop Down Option)

• How Many Bedroom (Drop Down Option)

• Is There a Study (Drop Down Option)

• How Many Living Rooms (Drop Down Option)

• How Many Dining Rooms (Drop Down Option)

• Freehold Or Leasehold (Drop Down Option)

• Condition Of Property (Drop Down Option)

• Structural Problems (Drop Down Option)

• Right of Way Over Property (Drop Down Option)

• Garden (Drop Down Option)

• Is There Parking And What? (Drop Down Option)

Keys Information In Regards To Sale (Drop down box of options)

• How Many Owners Of The Property (Drop Down Option)

• Reason For Selling (Drop Down Option)

• Is There A Mortgage On The Property (Drop Down Option)

• How Much Is Outstanding On The Mortgage (GBP)

• What Is There Time Frame For Selling

• How Much Are They Looking To Sell For

• When Did They Buy The Property

• Is The Property On With An Agent (Drop Down Option)

Property Purchase Price

• RICS Valuation (GBP)

• Estate Agent Valuation (GBP)

• Price Agreed (GBP)

• 3rd Parties Offer (GBP)

• 3rd Party Company (Drop Down Option)

• SDLT (Calculation)

• Legal Cost Seller (GBP)

• Legal Cost Ours Buying (GBP)

Property Sell On Information

• Legal Cost Ours Selling (GBP)

• Agreed Flipping Sales Price (GBP)

• Agreed Sales Commission (GBP)

• How Did We Sell (drop down box)

• Days We Held The Property For (This will need a calculation)

Notes

Large area for notes is needed

Property/Client Progress

• New Client Contact Has Not Been Made Yet (And Date)

• New Client Have Tried To Make Contact 1. call, text or email (And Date)

• New Client Have Tried To Make Contact 2. call, text or email (And Date)

• New Client Have Tried To Make Contact 3. call, text or email (And Date)

• New Client Have Tried To Make Contact 4. call, text or email (And Date)

• Valuation RICS Date Agreed (And Date)

• Valuation Estate Agent Date Agreed (And Date)

• Valuation Completed RICS (And Date)

• Estate Agent Valuation (And Date)

• Offer Made (And Date)

• 1st Price Offered (And Date)

• 2nd Price Offered (And Date)

• 3rd Price Offered (And Date)

• Offer Accepted (And Date)

• Lawyer Instructed (And Date)

• With Lawyer (And Date)

• Property Exchanged (And Date)

• Property Sale Completed (And Date)

• Building Works Started (And Date)

• Building Works Completed (And Date)

• Property Back On The Market (And Date)

• Property Re Sale Exchanged (And Date)

• Property Re Sale Completed (And Date)

Databasadministration Databasutveckling Databasprogrammering Microsoft Access SQL

Projekt-id: #16500325

About the project

19 offerter Distansprojekt Aktivt 6 år sedan

Tilldelades:

saseow

Good afternoon, This seems like a great project but may I suggest that instead of Access, you use MySQL. This will allow far better security, far more robust and much, much better at multi user scenarios. Web hosting Mer

£333 GBP inom 5 dagar
(13 omdömen)
6.3

19 frilansare har lagt bud på i genomsnitt £356 för det här jobbet

fuentro

Hi, my name is Rodrigo. I saw your project description and I have the right skills to help you with it. I have over 7 years of experience developing in MS Access and well versed in VBA and SQL. However, as a recommenda Mer

£500 GBP inom 10 dagar
(30 omdömen)
6.1
NourElDeen

Dear Sir, I'm ready to start on your project now, i know that your already assigned to anther freelancer but he lefted, but i'm interested on doing your project. please give me the chance to show you perfect implement Mer

£750 GBP inom 15 dagar
(72 omdömen)
5.9
zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de Mer

£250 GBP inom 7 dagar
(55 omdömen)
6.2
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel Mer

£200 GBP inom 3 dagar
(73 omdömen)
5.9
axiomswb

I have expertise in Access and VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

£50 GBP inom 2 dagar
(24 omdömen)
5.6
shihan033010

A proposal has not yet been provided

£222 GBP inom 10 dagar
(21 omdömen)
5.0
aubrey03

A proposal has not yet been provided

£200 GBP inom 5 dagar
(19 omdömen)
4.5
solucionesnet

hi, I can develop a windows application to store data for your clients and properties using a free database engine (access is not multiuser database), you can export the data to excel and you can connect all computers Mer

£266 GBP inom 3 dagar
(10 omdömen)
4.1
NumanAnjum

A proposal has not yet been provided

£188 GBP inom 10 dagar
(4 omdömen)
4.0
sunsoftpro

strong web app software, i can help you. plz contact me!

£609 GBP inom 22 dagar
(4 omdömen)
3.6
VnNorthStar

Hi I'm ready for this project. I'm expert in Access Development. Please give me an opportunity. I will do it perfectly. Best Regards VnNorthStar

£100 GBP inom 7 dagar
(6 omdömen)
2.6
FahadAhmed1012

Hi, I am experienced Ms Access Developer, I can build User Friendly an Access Database to handle clients, I am will to help you in this project. Thanks Fahad AHmed

£150 GBP inom 10 dagar
(1 omdöme)
1.1
sanjaybhansali

Hello sir I am senior IT Engineer I have 8 year experience in programming.... I am confident to do this job... Please inbox me thanks

£888 GBP inom 30 dagar
(1 omdöme)
0.8
Pawan070

Understood you requirement

£177 GBP inom 3 dagar
(0 omdömen)
0.0
ryanmergen

A proposal has not yet been provided

£222 GBP inom 3 dagar
(0 omdömen)
0.0