Find Jobs
Hire Freelancers

Build a newesround database in MS Access 2010

£20-250 GBP

Closed
Posted about 6 years ago

£20-250 GBP

Paid on delivery
Hi I am looking to get an MS Access 2010 database which can manage newspaper& magazine orders for a number of customers on behalf of a small village shop run by elderly couple. It needs to be able to do following:- 1. Print off daily delivery schedules for customers' orders grouped via delivery routes & recognise day of week eg weekday,Saturday or Sunday. 2. Table list of newspapers and magazines need to be categorised by weekday, Saturday,Sunday or monthly [login to view URL] item will have unique cost. [login to view URL] customer's order must be able to be suspended for holidays [login to view URL] can be sigle day or several weeks. 4. Each customer will need a weekly invoice printed taking account of each days' order for past week which also recognises any suspended days 5 Users must be able to add or delete customers as well as newspapers or magazines plus be able to amend costs of any newspaper or magazine. I would prefer that any alterations to delete data or amend prices be controlled by password . Hope this is clear enough but I would be happy to further clarify and would like to know how much this MS Access 2010 database would cost and how I could proceed if cost is agreed.I attach what I have produced already. Bob
Project ID: 16835918

About the project

23 proposals
Remote project
Active 6 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
23 freelancers are bidding on average £184 GBP for this job
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
£250 GBP in 5 days
4.9 (232 reviews)
7.1
7.1
User Avatar
Hello I went over your specifications and the sample database that you have attached. Here are my thoughts: 1 - You will need a database with a user based login module so that you can control what each user is able to see and/or edit. 2 - You need a order form where the customer can input an order for a specified length of time - say for a month or for a year. Since he should also be able to suspend or cancel the order at any given time - when you save the order the code should create a "Delivery calender" with tentative prposed dates for the order delivery. This could be every day, every sunday or once month depending upon the schedule of the item ordered. 3 - This calender which will be unique for each customer must be "editable" to certain users so that you can cancel or change the sunbscription. 4 - Based on this calender you will be able to print daily delivery list, Monthly or weekly invoices etc. 5 - If required you will also be able to send invoices directly to your customers from the database itself. I look forward to discussing this in more details. regards Rajiv
£222 GBP in 12 days
4.9 (154 reviews)
6.9
6.9
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. 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
£166 GBP in 3 days
4.8 (83 reviews)
7.4
7.4
User Avatar
Hello Sir, I am an expert in MSAccess and would like to work with you on this project. Looking forward to discussing the same with you. Thanks Aanvik
£277 GBP in 3 days
5.0 (47 reviews)
6.6
6.6
User Avatar
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Access/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Access/Excel projects. I'll do your current Ms Access "manage newspaper& magazine orders .." for 200 GB during 5-7 days Thank you for your consideration. Zura
£222 GBP in 5 days
4.7 (74 reviews)
6.5
6.5
User Avatar
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 develop this orders management Database. This looks fairly simple and I'll be glad to make look as simple as possible for the users. I have checked the attached DB and we can build on that. However, I'd like more details about the project. Check my profile for previous clients' reviews and projects. Best, Alaeddin
£166 GBP in 5 days
4.9 (73 reviews)
5.9
5.9
User Avatar
Good day. The time frame and the bid amount are just for the preliminaries and are still subject to change depending on our agreement and negotiation. I have been using MS Access for my personal and professional use and I can guarantee you that I can finish the project on as soon as possible without sacrificing the app's quality. Feel free to message me so that we can talk more about this project. Thanks and have a nice day.
£100 GBP in 5 days
5.0 (68 reviews)
5.7
5.7
User Avatar
Dear Sir, First good job, and i'm interested on doing your project, i can build it with friendly interface, and also to build a sample for your. Kind Regards, NourElDeen
£155 GBP in 7 days
5.0 (58 reviews)
5.5
5.5
User Avatar
Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already designed a School Management System using MySQL and Java. In this project I applied database skills which your project needs. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates requesting any revisions or additions that need to be made. I will also work with you until the project comes to fruition, in perfect condition, and ready for submission. I realize that each academic project is unique and requires thoughtful research. With care and planning we can work together to create something which can fulfill your expectations. Hope to work with you soon! Looking forward to hear from you Thanks Nyaronyari
£150 GBP in 3 days
5.0 (27 reviews)
4.8
4.8
User Avatar
I really appreciate your efforts in this database. It's a good start. I can make it more professional and user friendly for you. I have excellent depth over MS Access, SQL, VBA and Excel. I have been working on this platform since 2007. Please ping me to get started. Thanks
£150 GBP in 3 days
4.7 (22 reviews)
5.0
5.0
User Avatar
Please open a chat window with me so that we may discuss your requirements. I have been building MS Office solutions since 1994.
£333 GBP in 14 days
4.5 (12 reviews)
4.5
4.5
User Avatar
Hello, Myself Barduga, I have expertise in MS Access design and development. I have also worked on development of forms and reports in MS Access. I should be able to deliver the project as per your requirement. please feel free to discuss with me. Warm Regards Barduga
£170 GBP in 6 days
5.0 (6 reviews)
3.7
3.7
User Avatar
Hi Bob, I can develop the database as per your requirement. The database that you have created is a good start. Please be careful as to things like the price field and how you store the values in the orders tables. A common pitfall in database design is that on changing the price of an item say increasing the price. The prices for all previous order get automatically increased which is not what you want. Is there is a particular reason as to why you would like the database to Access 2010? I am guessing it is the version of Access that is already available. Are you aware of Ms access run-time software which is free and has some advantages of using it for an end user. I would charge 150 pounds (negotiable if it helps makes an elderly couples life easier). I would work with you by providing drafts of the database for your comments and suggestions. I would then amend the database, taking on board your feedback until you are satisfied with the final product. Please do not hesitate to contact me if you need any further information or clarification. What are you project timelines. I can look to completion with in a week or quicker if you need it urgently. Many Thanks Nitin
£125 GBP in 3 days
5.0 (1 review)
3.1
3.1
User Avatar
hi there I am an access developer with enough experience to handle your project with the description requirements all handled in a well and easy database with all the functions working perfectly lets get in touch and discuss more on the database
£116 GBP in 3 days
5.0 (1 review)
2.7
2.7
User Avatar
A proposal has not yet been provided
£333 GBP in 15 days
4.0 (5 reviews)
3.3
3.3
User Avatar
Hi there! I am a business analyst with over 15 years of professional experience in database design and development, including extensive experience with Access based solutions. I also have a strong background in retail, and exposure to delivery / route scheduling logistics thanks to experience in a wholesale / warehouse environment. I would love to talk with you about your newsagency project, as I am really passionate about working with small business - I love building solutions which save time for busy people. A few questions: 1. When you mention the delivery routes - I'm assuming these will be assigned by the user (i.e. there isn't an expectation that the DB will try and split the scheduled deliveries into optimum routes')? 2. Is the invoice period the same for every customer (so the weekly invoices are always say Mon - Sun for each customer)? 3. Is there any need for the invoices to track payments so the user can see the amount owing by customers at any point - or is this handled by an accounting package? 4. I am not overly familiar with the accounting requirements for the UK sorry - is there a need to incorporate VAT (I just googled and it seems newspapers and magazines cannot have VAT passed on the the customer, but they do attract VAT?? Good to see your system is almsot as complicated as Australia's - over here we have different tax rules for different flavours of milk)?
£277 GBP in 5 days
5.0 (3 reviews)
2.0
2.0
User Avatar
Hello Bob: -I am programming Access since 90s 95 version. All versions up to 365. -I can do the job: schedule, customers, magazines, delivery, newspaper, costs, users. I think what that group of tables will suffice, it will be efficient and easy to use. -The schedule maybe the difficult part, I do not know right now all details because of course I have to chat with you or someone who knows the workflow, but I have worked a lot of systems -You can see my portfolio, also I have more samples on Access. Excel. Microsoft platform. -What I can not assure is time with exactly deadline, but 7 to 14 to deploy to your computer, maybe 7 more to see how it work. Support for free bugs online, althought it´s rare on me. I am a software developer (trainer, translator and writer), doing desktop, web and cloud programming. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at my portfolio tsftportfolio wordpress com, Office apps VBA, ERPs, scripting, ETL, DBA, SysAdmin, Wordpress, Python, .NET, Clarion, PHP are part of my skills and experience, including UML, BPMN as well as GIMP for graphic design. PROCEDURES Remote Work -Online distance working -Online collaboration: easier system for you. -Daily communication automatized workflow. -Extreme programming, Agile methods. I look forward to work with you, Kind regards.
£244 GBP in 10 days
5.0 (2 reviews)
2.2
2.2
User Avatar
I have 25 years experience in IT..I am an Excel, Access, and VBA expert and have 10 years experience
£166 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an MBA in MIS. I have developed number of software applications and mostly on MS-Access. I can do this job for you. Send me the details and get software from me in a week time.
£150 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since Apr 30, 2018

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.