Access Database Needed

已完成 已发布的 6 年前 货到付款
已完成 货到付款

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)

数据库管理 数据库开发 数据库编程 微软Access SQL

项目ID: #16500325

关于项目

19个方案 远程项目 活跃的6 年前

授予:

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 更多

£333 GBP 在5天内
(13条评论)
6.3

有19名威客正在参与此工作的竞标,均价£356/小时

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 更多

£500 GBP 在10天内
(30条评论)
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 更多

£750 GBP 在15天内
(72条评论)
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 更多

£250 GBP 在7天内
(55条评论)
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 更多

£200 GBP 在3天内
(73条评论)
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 在2天内
(24条评论)
5.6
shihan033010

A proposal has not yet been provided

£222 GBP 在10天内
(21条评论)
5.0
aubrey03

A proposal has not yet been provided

£200 GBP 在5天内
(19条评论)
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 更多

£266 GBP 在3天内
(10条评论)
4.1
NumanAnjum

A proposal has not yet been provided

£188 GBP 在10天内
(4条评论)
4.0
sunsoftpro

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

£609 GBP 在22天内
(4条评论)
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 在7天内
(6条评论)
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 在10天内
(1条评论)
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 在30天内
(1条评论)
0.8
Pawan070

Understood you requirement

£177 GBP 在3天内
(0条评论)
0.0
ryanmergen

A proposal has not yet been provided

£222 GBP 在3天内
(0条评论)
0.0