Find Jobs
Hire Freelancers

Create a Jobs Database in MS Access

£250-750 GBP

Completed
Posted over 8 years ago

£250-750 GBP

Paid on delivery
We are a printing company who needs a order database developing for MS Access 2010. We have been using Lotus Approach for this purpose since 2003 but this is now massively out of date and very limited. The current database has 7100 orders in it which would need to be imported into the new system. The current data can be exported to an Excel Sheet/DBF file or any other format that can be used. The database needs to be able to keep customer details (name, contact, phone, email) in a table and link these to an 'Orders' table. Within each order, there will be one or more items. Each item in an order will detail the product being ordered, the type and weight of paper, the quantity ordered, etc. Some of these fields are simple text entry, some would need a drop down with options (possibly taken from another table). Currently this is all done on a single entry screen, putting data into a single table, so there is no customer management (we have to enter the details every time). We would like relationships creating so that if customer details are changed once, they change every time we can update customer details easily. It would also be useful to have the option of more than one contact name/number/email for a company, that can viewed easily. I've put on a screenshot showing an example entry on the current database, to show the information that would need to be in the new database. This currently limits us to 4 items per order. The new system should be able to handle any number of items on each order. We would need the order form to have an 'Add Item' button which would bring up an additional form to put in the details for the item. It should then be easy to view and search past orders. We don't necessarily need everything designing to look pretty, as we can modify the look of the various forms afterwards if required. We need the functionality setting up and the contents of the existing database importing and setting up correctly. We haven't tried to do something like this before, so i have no idea what to set the budget as. Please quote realistically. We will be able to supply a full brief of everything required before proceeding.
Project ID: 8184179

About the project

65 proposals
Remote project
Active 9 yrs ago

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
Hello there. I will be glad to help you to develop this app in msAccess 2010. According with you needs, I can offer you the following modules: 1) Customer manager module: A window where you can add, edit and suspend customers (with all his contact info, including multiple contact persons If your client is a company for example). 2)Product module: Windows where you can add, edit and delete all yours items orr services to be sold/invoiced for your Company 3) Price List module: Windows to Pre-config, add, edit and delete the price for each of your products and services 4) Order Module: Module to manage your orders (add, edit, delete, suspend, etc). With unlimited number of items for each order. All previous module include basic Search functionalities. 5) Reports: 3 reports: a- Qty of Orders in a period of time (monthly, quarter, year today, custom) b- Items sold in a period of time (best seller) c- Orders by Customers in a period of time (best customers) I hope all this covers all your needs. The Price for this App is :£300 If you want to include a Security module, add £100 Security module is: Create users with password and its access Profile (to customize access to some modules). If you want to migrate all your existing data to this new app, add $100 Please let me know any doubt.
£300 GBP in 10 days
5.0 (19 reviews)
4.8
4.8
65 freelancers are bidding on average £481 GBP for this job
User Avatar
Hello, I am employed MS Access/SQL Server developer specialized in Databases. I saw the screenshot and read the description. I understand that application is outdated and I can recreate in office 2010 or 2013 for you. Some parts of the code I can use from your previous app and some of them would need to be re-developed. I would be glad to communicate with you during the process so we could meet everything you need. Your database structure/ item forms requirements are all doable and I will not have much of a problem developing the application. It will just consume nice number of hours. I entered 30 days to finish the application assuming that we could have first version in 20 days and final in 30. It is a bit long period but I want to do a good job and I don't want to break the deadlines. If you are interested in me doing the application. feel free to contact me. In any case, thank you for consideration. Cheers
£355 GBP in 30 days
5.0 (28 reviews)
7.4
7.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
£600 GBP in 14 days
4.9 (167 reviews)
7.3
7.3
User Avatar
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. -Could you send me more details and screenshots about your project ? I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
£494 GBP in 7 days
4.7 (83 reviews)
7.4
7.4
User Avatar
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases I built are. ASCL database for Major Hospital in OKC. A scheduling program for the anesthesia department for a Major Hospital in OKC. A ford Parts Database to help a company keep track of inventory in house and EBay. and Many more. I was on Freelancer for 3 years and my account was hacked and I had to create a new profile. I have all my feedback from that site if you want to see them.
£333 GBP in 10 days
4.8 (42 reviews)
6.7
6.7
User Avatar
Good day, my name is Rodrigo. I have been developing MS Access solutions and applications for my workplace for the past 6 years, during this time I have been in charge of: designing, planning, implementing and maintaining given databases that people use as a daily tool on different departments. I have information coming in from DB2, SQL and Oracle Databases as well as SharePoint tables. I'm very focus and proficient with it and I'm sure we could work together in order to reach a solution for your project.
£555 GBP in 7 days
4.7 (28 reviews)
6.0
6.0
User Avatar
Hi I am interested in this project. I am an experienced MS access applications developer. i can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks Regards Jawad
£333 GBP in 10 days
5.0 (79 reviews)
5.7
5.7
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer and a mathematician 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. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity....I can demonstrate it via my PC with team viewer. I'll do it via Access 2010 or 2013, just you'd like. As for price , I see the average price here £505 .. I think it's a normal price. I'll code faste,r as you don't need high design in start stage... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£555 GBP in 10 days
4.6 (57 reviews)
6.4
6.4
User Avatar
Hello, I've got extensive experience with MS-Access and VisualBasic/VBA. Several projects in my FL job history were actually developed in MS-Access, even though not labelled as such by the project creators. I convinced them to adopt MS-Access as the implementation of choice. My design strategy with MS-Access focuses in taking advantage of the often overlooked 'native' MS-Access features to the greatest possible extent, avoiding the use of VBA code where not necessary or convenient. This way, the logical hierarchy of the application is automatically derived from the relational schema, established at a first stage. This approach provides me with a more compact, neat and robust product, whereas the often discretionary use programmers make of VBA results in unnecessary complications, as well as more error-prone. VBA is used in more complex functions like special formatting, compound filtering, calculations, etc. On another note, you can see in my profile I've achieved a high rate (40%+) of projects for recurring customers. This speaks about my commitment to meet their requirements, while maintaining high quality as a primary standard throughout the development. I'm most interested in taking up your project. I'm proposing a tentative schedule (milestones) to be refined in further discussion. Looking forward to your contact, thanks for your consideration. Grunty. PS: Let me know if you are on a tight timeline, I could rearrange my workload and shorten delivery time.
£350 GBP in 20 days
5.0 (10 reviews)
5.8
5.8
User Avatar
Hello, I represent Automyze Consulting. We are a business process automation firm based out of India. We recently solved a very similar automation problem for another printing company in UK. Like you, they also had data being managed in an offline system (in Excel) and it was not optimum. We migrated their order and client management system online to be used by multiple users. Is there any specific reason you want this to be done in Access. I am an expert in Excel/Access and can certainly do it and deliver a system that will be much more efficient that the current 'single-table' system. However, based on my experience with similar systems, I can tell you that even an Access based system will become difficult to maintain after a certain time as you grow. My recommendation for your purpose is to have a web-based system which will allow you to manage client data and order data separately, it will also allow you to 'auto-fill' client details as required and provide reporting as well. The system will also have features to allow addition to many items to an order and will be easy to manage and enhance as required. Does this sound interesting enough to explore further? Please drop a note to me and we may discuss the details. I can assure you of excellent quality work like I have been doing for many years. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
£1,111 GBP in 21 days
4.9 (49 reviews)
5.8
5.8
User Avatar
Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in Access and .Net programming. I am ready to work for you for free until you get the results. I can develop an Access database or write a stand-alone multi-user application which interacts with database. The database can be any (Ms Access, MS Sql Server, MySql, Sqllite, Oracle, Sql Server Compact Edition) Please contact me to discuss the details. Waiting for your messages. Best regards, Tolib Rahimov
£333 GBP in 10 days
4.9 (6 reviews)
5.1
5.1
User Avatar
I am a software developer with 10+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.
£250 GBP in 15 days
4.1 (14 reviews)
5.8
5.8
User Avatar
Dear Buyer, I am working with Access databases since 1998 (versions 95 up to 2010). First of all, I had a first look at your jpg. As it seems, you have already some items as drop-down lists but you lack two basic things (customers and items - more than four). This is something that can be handled relatively easily and the budget should normally be around 250. I would like to know if you are in need of "using" screens of your current Access database (after converting it to 2010, of course !) with appropriate modifications, or you would like to re-build something completely from scratch. I opt for the first solution because it will save time by utilizing already existing items. Of course, the decision for this will be yours. If you need further discussion about this, it would be more than welcome ... Now, since I have to be absolutely honest with you from the beginning, I have to inform you that I can deliver this in a timeline of 10 days (of course I would like to have an idea of the whole database size, before committing to an exact time frame), BUT, unfortunately, I can start working on Monday, August 17 ! The reason is on Sunday I am leaving for summer family holidays, returning on Sunday the 16th. So, if you expect to have a really quick turn around on this, I understand that I am not your person. If you, however, are not in such a hurry, I would like to hear from you and work in this upon my return. Waiting to hear from you. Best regards, Solon ...
£250 GBP in 10 days
4.9 (24 reviews)
4.7
4.7
User Avatar
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in VB.Net I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble Ashish Seth
£400 GBP in 10 days
4.9 (27 reviews)
4.9
4.9
User Avatar
I am expert in all version of MS Access. I have developed many application using MS Access. Please contact me. I am ready to start work
£750 GBP in 10 days
5.0 (2 reviews)
4.4
4.4
User Avatar
Hi, I have been developing solutions for more that 20 years. I will be happy to provide you with the solution you want. After the acceptance, I will provide 1 month of FREE support to make sure that the systems is running in the real environment as it should. I am providing 3 snapshots for some of the most recent applications I have developed in Access. You may have a look at my portfolio for more details. Your satisfaction is guaranteed. Best Regards Ahmed Otoom P.s I am sorry I cant see where in the system I can attach the snapshot to my bid. Please contact me so I can email these snapshots with my reply.
£500 GBP in 21 days
4.8 (13 reviews)
4.4
4.4
User Avatar
Hi, I am 19+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration Assistant, Database Migration Assistant,SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, Oracle Forms, Oracle Reports, ADF, Oracle Fusion Procurement. Let me know when can we discuss.
£666 GBP in 15 days
4.7 (15 reviews)
4.7
4.7
User Avatar
Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual Basic to solve many of the problems presented in each role. I’ve built numerous applications varying from simple reporting tools to more complex multi-user client-server applications used in production environments. I am very motivated to exceed your expectations, earn a great review from you to post on the website, and begin a long standing business relationship. Your projects sounds interesting and I believe that my background will allow me to provide additional perspectives and insights into how to optimally leverage the data once we develop the base application. Developing the application that you’ve specified should be a straight forward exercise that I can complete quickly for you. After that, depending on what you're looking for, we can collaborate to take advantage of the rich functionality that Access presents. If you choose to hire me, I promise you won’t be disappointed and I promise to go above and beyond for you. Thanks for your consideration, Rob
£500 GBP in 10 days
5.0 (6 reviews)
4.2
4.2
User Avatar
Hi I'm an IT Project manager in a local bank with over than 20 years of experience in banking software development. Im an expert in .NET (c#, vb, c++), vba and sql server technologies I sugest you to work with an SQL server database instead of an MS Access (access is not a robust technologie for large and secure databases). The Express edition (free for download) is a very good option. You only need a server to install. The front may me an asp.net (c# or vb). Your requirements are simple to implemnet this way. I use to build a multi layer security access architecture to ensure the secure access to the data. The data must be accessed via sql stored procedures (i use a banking standard to build this layers). Regards Carlos
£555 GBP in 10 days
5.0 (9 reviews)
3.9
3.9
User Avatar
Hello sir, I am developer from Serbia. I have read carefully your project description and I have clear image of what you want. I can do it in few days. I already did similar jobs, if you want I can send you some of my work. Please choose me, you will not regret I promise, you will get the best European quality of work. Kind regards
£277 GBP in 5 days
5.0 (2 reviews)
3.2
3.2
User Avatar
I am proficient in web development using HTML5, CSS3, Javascript, jQuery, jQuery UI, Ajax, Bootstap, Foundation, Asp.Net MVC etc. I have also have strong experience of software development using Foxpro, Visual Foxpro, C#, Asp.Net, MVC, Crystal Reports, Sql Server and MySql. I have developed various software related to Accounting, Inventory, Taxation, Production / Manufacturing etc. Do you want only MS Access database or better solution for it? Because you want to re-designe / re-develop you old application, and its needs to be future proof. You have following better options for it. 1) Windows database application using .Net along with Sql Server. 2) Web application using Asp.Net MVC with MsSql or MySql database or Php along with MySql. Please provide full details. Thank you, Pramod
£555 GBP in 10 days
5.0 (1 review)
3.2
3.2

About the client

Flag of UNITED KINGDOM
Sheffield, United Kingdom
5.0
6
Payment method verified
Member since Apr 12, 2010

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.