Find Jobs
Hire Freelancers

Microsoft Access Customer Database Complete Redesign and Linked To Xero Accounts

£1000-1250 GBP

In Progress
Posted about 3 years ago

£1000-1250 GBP

Paid on delivery
I would like my MS Access database updated and linked to the Xero accounting system API. The system is dated needs a revamp it is currently Access 2010. I have an electrical appliances business in Manchester UK est 1989. www.mostonlaneappliances.co.uk. The API link is a requirement of HMRC. The database is very basic but I would be interested to know what it could potentially do for me. We enter 150-200 jobs each week, customer details and job history are displayed along with sales. It is important to be able to quickly enter jobs as I own and manage the shop and the one phone line can get very busy. Nothing too elaborate is necessary. I hired a company a few years ago and it was taking up to five minutes to book a call/sale. Presently if the customer gives their address I can book in a minute as I have all the information recalled immediately. The whole look of the database is very dated and I would like something more user friendly as I find it difficult to show newcomers all its quirks. I am open to any suggestions from someone who has experience of this type of project. A very clear homepage which is easy to navigate, along with invoicing facilities, reminders of outstanding invoicing to landlords and agencies would be needed. Any suggestions regarding further improvements would be welcome. KInd regards, Mike.
Project ID: 29469283

About the project

8 proposals
Active 3 yrs ago
Location: Sheffield, United Kingdom

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
£0 GBP in 21 days
0.0 (0 reviews)
0.0
0.0
8 freelancers are bidding on average £1,389 GBP for this job
User Avatar
Hi Mike I hope all's well with you. I'll redesign your current Ms Access DB very professionally and on time. Please visit :https://www.freelancer.com/u/zu02?w=f Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£1,125 GBP in 7 days
4.6 (60 reviews)
6.3
6.3
User Avatar
Hi Mike, my name is Adam and I’ve been a developer in Microsoft Access since 2002. Firstly, thank you for the opportunity to work with you on this project. I’m a UK-based IT professional currently based in Rugby, Warwickshire. I have extensive experience with overhauling and redesigning systems, and can certainly help you give your system a fresh lick of paint. With regard to the link with Xero - well, I haven’t worked directly with this app but I have worked with numerous APIs and finance apps previously so although it may take a little time to figure out the details, I’m confident I can get the links in that you need. I’m happy to provide you with a portfolio of some of my current systems work. Also happy to talk through your needs to determine the best approach to make this work for you. Finally, I’m able to start work on this pretty much immediately for you. Would it be possibly to schedule a Teams call to run me through your existing system and talk through some options? Many thanks, Adam Taylor
£1,333 GBP in 28 days
4.8 (12 reviews)
4.8
4.8
User Avatar
Hi Mike, I am a Manchester based software developer with over 11 year's experience. I have implemented many API integrations, databases and user interfaces and would like to take on your project. My work is high quality and well priced as I like to build long-term relationships with clients. I saw this project a few weeks ago and bid on it at the time. Please DM me if you would like to discuss my experience in more detail, or if you would like to arrange a phone/video call. Thanks an regards, Oliver
£1,200 GBP in 14 days
5.0 (5 reviews)
4.4
4.4
User Avatar
Hi Mike, I work for a number of SMEs running Access DBs. I'd be pleased to tidy up your existing database and also link up to Xero. See profile for further CV details - some of my work is in MS SQL which me gives a stronger database focus than many operators on freelancer - and ensures that any database structures I setup in MS Access are efficient and reliable. I'd suggest 3 stages, I would sort out the link to Xero first if possible so as to get you up and running with Xero integration. If its currently a single Access DB with both forms and data in it then I would split into a front end with forms and back end with data since this increases reliability and makes development work much easier. After that I would tidy up the layout and navigation screens and finally if needed I'd tidy up data structures though since you had the system upgraded a few years ago I would hope those are not too bad. I'd need to view your existing application before accepting the work to confirm that there were no serious gremlims that would mean this quotation was way off. If you are on an older version of MS Access then I would recommend moving to Office 365 Business. I'd discuss options and costs of this with you but if you are only runing the DB on one machine then its approx £10 per month to Microsoft. Price includes VAT. Adrian Brough West Cumbrian Data & Analysis Ltd t/a Brough Databases I'm now based in Annan so can visit fairly easily if needed.
£1,800 GBP in 60 days
5.0 (1 review)
3.9
3.9

About the client

Flag of UNITED KINGDOM
SALE, United Kingdom
0.0
0
Payment method verified
Member since Feb 4, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.