Find Jobs
Hire Freelancers

Create access database

$250-750 USD

Geschlossen
Veröffentlicht vor fast 9 Jahren

$250-750 USD

Bezahlt bei Lieferung
Our company is a reseller of I.T. and office supplies. We need to create a database to help us track information related to products that we have on a contract. We receive data from manufacturers in excel format. That data is then entered into a master excel sheet. This has worked well for us, but as we add manufacturers and update the existing manufacturer catalogs, manually entering the data has become too time consuming. We would like to have a database created in Access that would allow us to upload the new pricing. The upload process should update existing part numbers, set missing part numbers to inactive, and append new part numbers with relevant data. Fields in the data base are either uploaded from an external source, entered manually, or should be calculated in the database. Fields include but are not limited to. SIN (Special Identification Number) (Uploaded) Manufacturer Name (Uploaded) Part Number (Uploaded) Product name / Description (Uploaded) MSRP (Uploaded) Dealer Cost (Uploaded) Dealer Discount off MSRP GSA Discount from list (%) (Calculated) Markup (%) (Calculated) GSA Price without IFF (Entered Manually) GSA price with IFF and Shipping (Calculated) Warranty (Uploaded) Country of Origin (Uploaded) Energy Star Compliant (Uploaded) Section 508 Features (Uploaded) UPC Code (Uploaded) Unit of Issue (Uploaded) Shipping (Uploaded) MSRP Including Shipping (Calculated) Dealers Cost Including Shipping (Calculated) MFC Discount % from List (Entered Manually) MFC Price (Calculated) Status (Uploaded) We also need forms and tools developed to help us analyze and set pricing. We are looking to have this finished in two weeks. Thank you for your time. Please feel free to ask questions.
Projekt-ID: 7943108

Über das Projekt

42 Vorschläge
Remote Projekt
Aktiv vor 9 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
42 Freelancer bieten im Durchschnitt $451 USD für diesen Auftrag
Avatar des Nutzers
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. 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
$386 USD in 9 Tagen
4,7 (79 Bewertungen)
7,3
7,3
Avatar des Nutzers
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ I think we should be able to develop a module where you can upload various catalogs to your database at the click of a button. I understand that the different catalog files would have different structures. One easy way to circumvent this would be to create different upload modules for different manufacturers. However this will lead to issues when the manufacturer changes the file format or when you add a new manufacturer. Better alternative is to develop a a mapping module where you can choose which field from the manufacturer file maps to which field in our database. This approach would be more code intensive to start with but will give you more flexibility. I look forward to discussing the project in more details with you. regards Rajiv
$350 USD in 10 Tagen
4,9 (153 Bewertungen)
6,8
6,8
Avatar des Nutzers
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.
$350 USD in 12 Tagen
4,8 (91 Bewertungen)
6,5
6,5
Avatar des Nutzers
Hi, I can create such Microsoft Access database, as you described. I had completed project related to import from Microsoft Excel Workbooks to Microsoft Access database and updated same data. Here are my questions (in case if you will accept my bid, since you had not gave all necessary for this project data): 1. What is your version of Microsoft Office (for example: 2003, 2007, 2010, 2013) ? 2. What is format of Microsoft Excel files, received by you from manufacturers ? ( I need sample of the Workbook) 3. What are formulas for calculated fields ? 4. What is format of master excel sheet (in case if you need to import data from it initially) ? Regards, programmer Aleks
$388 USD in 14 Tagen
5,0 (49 Bewertungen)
6,0
6,0
Avatar des Nutzers
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need to create a database to help you track information related to products that you have on a contract for your company. I am able to create a database in Access that would allow you to upload the new pricing which you are receiving from manufacturers in excel format. The upload process would update existing part numbers, set missing part numbers to inactive, and append new part numbers with relevant data. Fields in the data base will be either uploaded from an external source (Excel file), entered manually, or it will be calculated in the database with the fields included you described in the project description. Also I will develop forms and tools which will help you analyze and set pricing. I have done this type of job many times. (I can send a sample application to assure you. If you request me.) I have 6 year's experience designing and developing Access Applications with advance knowledge of SQL and VBA and particular skill in integrated Microsoft Office solutions based upon automation of Excel, Word and Outlook.. 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, take a look at my Freelancer Portfolio.
$250 USD in 10 Tagen
4,9 (69 Bewertungen)
6,0
6,0
Avatar des Nutzers
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.
$444 USD in 10 Tagen
4,8 (32 Bewertungen)
6,1
6,1
Avatar des Nutzers
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.
$500 USD in 7 Tagen
4,7 (27 Bewertungen)
5,9
5,9
Avatar des Nutzers
Hey, I reviewed the requirements brief you shared and have an idea on what you are looking for. Such a database driven system could be done in multiple ways. While the table(s) would reside in Access, we could host the forms in either Access itself or in Excel. In both the cases, you would be provided with one (or more) uerforms and you would be able to enter the data through the form by manually entering it or by using an 'import' functionality. You mentioned that you need "tools developed to help us analyze and set pricing." If you could elaborate more, I would be able to suggest some options to go about it. Do let me know if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$722 USD in 15 Tagen
4,9 (46 Bewertungen)
5,6
5,6
Avatar des Nutzers
Hi Sir. I work in individual capacity and I am eager to take up this product management system. I can design a very user friendly interface to make entries in database and front end queries to ensue stock availability. I have done similar projects before. Please discuss so we may continue. Regards. Usman.
$600 USD in 10 Tagen
5,0 (17 Bewertungen)
5,5
5,5
Avatar des Nutzers
Hi, I am very interested working on your project: 'Create access database' As implementation offer, I propose developing your access db application as requested My 10+ years background in: - server side programming(php, C#, C++, Java, VBA, Python etc) ; - client side programming and design(HTML/HTML5, CSS, JavaScript, JQuery, Ajax etc); - database development(MySQL, PostgreSQL, MSSQL, Informix, Access, NoSQL etc); - multiple web frameworks(Wordpress, Symfony, Drupal, CodeIgniter, Yii, PrestaShop, WooCommerce etc), - CRM (SuiteCRM, VTiger, Zoho, Infusion) , ERP ( OpenERP) - HRM Software (OrangeHRM platform) - Google App, Web Services, Mobile App, Amazon App, RESTful ; - data processing, - web scrapping any kind of data - software testing - email management on large scale applications(with complete services on architecture, design, implementation, customization, SAAS) make me very confident that we can have a successful collaboration. I suggest we start as soon as possible by sending me all the necessary technical information and agree on the final details Thank you!
$555 USD in 15 Tagen
5,0 (21 Bewertungen)
5,1
5,1
Avatar des Nutzers
I am a conultant for a Fortune 50 company doing this type of work. I primarily work in Access for them and have created a tracking/reporting tool using Access and VBA that they have been using for the past 3 years. I am extremely knowledagble in this area and would be thrilled to work with you. I am would be willing to talk this project over with you before you select a freelancer.
$277 USD in 6 Tagen
4,1 (14 Bewertungen)
5,8
5,8
Avatar des Nutzers
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
$333 USD in 10 Tagen
5,0 (6 Bewertungen)
4,2
4,2
Avatar des Nutzers
hi, I am interested to develop a software application to manage your product price with backend access database and price upload and update facility. Please let me know details of all required functionalities. Please see my profile and let me work with you. Thanks Prakash
$500 USD in 10 Tagen
5,0 (4 Bewertungen)
3,5
3,5
Avatar des Nutzers
Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please give me chance to prove myself. Thank u!
$250 USD in 3 Tagen
5,0 (8 Bewertungen)
3,7
3,7
Avatar des Nutzers
I am database expert having experience of 2 years.I will definitely help you in designing your database and deliver it on time.
$250 USD in 10 Tagen
4,9 (13 Bewertungen)
3,3
3,3
Avatar des Nutzers
I am ready to work on your database design as per your time line requirement, Thank you
$263 USD in 5 Tagen
5,0 (3 Bewertungen)
3,0
3,0
Avatar des Nutzers
I have over 8 years of experience working with MS Access applications. Have developed a number of database applications using MS Access VBA. Could design reports to any level of complexity. Development of fully normalized database along-with key-definitions and relationships. I've attached a sample database which is a cut-down version of one of my projects. It has some forms and a report which could be viewed in design mode. Although the VBA code has been taken out, the attached sample Software Manual was prepared with the help of working version of the project. The forms of the new project will be having Save and Cancel buttons (based on VBA functionality) instead of the navigation mode which is default feature of MS MS Access. The forms given in the sample file could be referred for the same.
$250 USD in 10 Tagen
4,8 (4 Bewertungen)
2,7
2,7
Avatar des Nutzers
Hi, I have more than 14 years of Programming exp and I am expert in this kind of work. I have completed more than 240 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 USD in 25 Tagen
5,0 (3 Bewertungen)
1,8
1,8
Avatar des Nutzers
Hi, Your project sounds very interesting and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$300 USD in 10 Tagen
5,0 (1 Bewertung)
2,0
2,0
Avatar des Nutzers
We went through your requirements, we can understand the requirements. We have good experience in developing application in both standalone(windows) as well as web. have much knowledge handling excel file upload with existing data and reconsolidation with data in application and excel file. we can generate inventory, daily stock,sales and analytical reports
$500 USD in 15 Tagen
5,0 (1 Bewertung)
1,1
1,1

Über den Kunden

Flagge von UNITED STATES
Manchester, United States
5,0
2
Zahlungsmethode verifiziert
Mitglied seit Sept. 9, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.