Completed

Access Database Needed

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)

Skills: Database Administration, Database Development, Database Programming, Microsoft Access, SQL

See more: access database templates, how to create a database in access, microsoft access tutorial, how to create a database in access 2010 step by step, access database design, how to use microsoft access 2013, how to create a database in access 2016, how to create a database in access 2013, access database needed, convert access database sql server database, access database sql server, convert access database sql server 2008 database, days will convert access database sql server, converting access database sql server visual basic, work needed access database design projects company

About the Employer:
( 6 reviews ) Gillingham, United Kingdom

Project ID: #16500325

Awarded to:

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 More

£333 GBP in 5 days
(11 Reviews)
6.2

21 freelancers are bidding on average £346 for this job

guoxinliu917

Hello, I have used .NET as front end and Access database as backend to develop a nice system. You don't need to install anything because windows have .net installed default. Here is the project [url removed, login to view] More

£250 GBP in 3 days
(43 Reviews)
6.7
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 More

£500 GBP in 10 days
(29 Reviews)
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 More

£250 GBP in 7 days
(41 Reviews)
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 More

£750 GBP in 15 days
(61 Reviews)
5.6
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 More

£200 GBP in 3 days
(62 Reviews)
5.5
mauricemarinus

High bid.. yes I know. Your requirements are for fixing bugs for a year. I have to charge accordingly. Note. There is a difference between fixing bugs and implementing additional requirements. Now that thats out the More

£1000 GBP in 15 days
(18 Reviews)
4.8
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 in 2 days
(21 Reviews)
5.0
shihan033010

A proposal has not yet been provided

£222 GBP in 10 days
(20 Reviews)
5.0
milansahu2010

6 years+ experience on .Net, Asp.Net, C#, MVC, WCF, SQL Server, AngularJS, Bootstrap, HTML5, Telerik Controls. Recently Completed web application - [url removed, login to view] [url removed, login to view] http:// More

£167 GBP in 10 days
(8 Reviews)
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 More

£266 GBP in 3 days
(5 Reviews)
3.9
sunsoftpro

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

£609 GBP in 22 days
(4 Reviews)
3.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 in 10 days
(1 Review)
1.1
aubrey03

A proposal has not yet been provided

£200 GBP in 5 days
(1 Review)
1.0
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 in 30 days
(0 Reviews)
0.0
NumanAnjum

A proposal has not yet been provided

£188 GBP in 10 days
(0 Reviews)
0.0
Hack04440

Hi There, I am UK based like yourself and so I am able to visit your place of work and discuss your database requirements with you in person. My quotation fee includes expenses for one such visit. I like to get t More

£500 GBP in 20 days
(0 Reviews)
0.0
ryanmergen

A proposal has not yet been provided

£222 GBP in 3 days
(0 Reviews)
0.0
Pawan070

Understood you requirement

£177 GBP in 3 days
(0 Reviews)
0.0
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 in 7 days
(1 Review)
0.0
£250 GBP in 5 days
(0 Reviews)
0.0