Build a Microsoft Access Database

Build a Microsoft Access Database and import our current data held in multiple spreadsheets.

I need A need a series of speadsheets combined into one Microsoft Access Database file that can produce excel spreadsheets and PDf Files? for a wholesale business with about 150-200 products

1. Master database with all data for each product.

(Plus an input formto add new products.

I currently have

1. GS1 Bar Code spreadsheet.

(Holds the; SKU, Product Description, GSI Raw Barcodes allocated to the company. Creates the product Barcode with Checkdigit, Plus Inner & Outer carton Barcodes from that GS1 barcode) Can be a sheet within Master above. Logic already done. Current list deliberately has gaps in numbers used in it. Need to be able to select one from the available list when setting up a new product.

2. Product Cost & Margins Spreadsheet.2

Creates Prices for products (eg

RRP, Wholesale, plus 6 other price groups) based on a % of Landed Unit Cost. (landed unit cost based on carton cost units per carton and can have about 6 inputs (Unit Purchase price, freight, re-packaging, packing labour,labels, other) need to be able to enter what if margin % etc or fixed prices when entering or editing

3. Bar code Labels Database

Ingredients, Nutrition panel, grams, contact details country of origin, image logo, etc details (about 33 fields each product)

Needs to produce above as a stand alone Excel spreadsheet for label creating staff that dont have access to other data.

4. Product Price list spreadsheet

Product details, price, rrp ,grams, product dimensions, innner box dimension, outer carton dimensions, units and layers per pallet etc.

(needs to create stand alone spreadsheet to give to supermarkets to feed straight into their data base for any of 8 price groups.)

Also needs to produce a PDF file as a Product/Price list for any of the 8 price groups above.

5. Amazon Vendor spreadsheet .

A variation of 4 above to suit Amazon requirements. needs to be able to send this as a separate excel file.

Taidot: Excel, Tietokantaohjelmointi, Microsoft Access

Näytä lisää: microsoft access database search function, microsoft access database students attendance, microsoft access database website, how to create a database in access 2016 step by step pdf, how to create a database in access 2010 step by step, how to create a database in access 2016 step by step, how to create a database in access 2007, access database download, ms access database examples, access database templates, access database tutorial, print receipts microsoft access database, php microsoft access database connectivity dsn, vb6 access database import csv, executeable file microsoft access database, convert microsoft access database exe, calendar schedules microsoft access database, microsoft access database project timeline, microsoft access database exe, convert microsoft access database java database

Tietoa työnantajasta:
( 1 arvostelu ) Elderslie, Australia

Projektin tunnus: #27872705

Myönnetty käyttäjälle:


Hello! I am ready to carry out your project with the highest quality! BUT! If you are going to use linked Excel files, then you will not be able to edit these tables in Microsoft Access. You can read reviews about my Lisää

$500 AUD 5 päivässä
(211 Arvostelua)
(337 Arvostelua)

31 freelancers are bidding on average $496 for this job


Hi, Greetings! ✅checked your project details: Build a Microsoft Access Database ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects Lisää

$400 AUD 6 päivässä
(382 arvostelua)

Hi, As I understand you are looking for MS Access database to import the data in multiple spreadsheets. It would help to discuss further on this. Keen to work on this project. I have recently completed MS Access base Lisää

$300 AUD 5 päivässä
(113 arvostelua)
(60 arvostelua)

Hi Mr. Employer, I have a lot of experience in Access and I can do this project in an effective manner with 100% accuracy report to your requirements. I had gone through your project proposal and I would like to discus Lisää

$250 AUD 6 päivässä
(124 arvostelua)

Hi there! I'm Access/Excel/vba Expert from Georgia- full time freelancer. Please visit https://www.freelancer.com/u/zu02?w=f Here you can find: ------------------------------------------------------------------------- Lisää

$750 AUD 7 päivässä
(60 arvostelua)

Hi, I'm an expert Access / MS-SQL database application developer with several years work experience in developing business databases. Per your requirements, I am bidding to develop a multi-user Access database, with Lisää

$750 AUD 10 päivässä
(43 arvostelua)

Hi. I have written many automation Excel projects also database projects including Microsoft Access. Ready to write your project. Will complete within 6 days

$640 AUD 6 päivässä
(62 arvostelua)

hello there, Database experts are here. Lets have a discussion over Chat for further movement . Thanks

$550 AUD 3 päivässä
(54 arvostelua)

Hello, I have read your project description and I can combine all five of your spreadsheets into an MS Access database. I will be doing this using Python. I have expertise as well as experience in Python Programming an Lisää

$250 AUD 1 päivässä
(18 arvostelua)

Hi, I'm Microsoft Access and VBA expert. I developed many applications. Looking forward to work with you. Regards

$500 AUD 7 päivässä
(14 arvostelua)
(31 arvostelua)

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Lisää

$250 AUD 2 päivässä
(8 arvostelua)

Dear Hiring Manager, I have read the project description and would like to discuss it further. I have recently created a standalone Access database for a retail organization to manage their catalogue with forms for Lisää

$557 AUD 7 päivässä
(8 arvostelua)

Hello, we have built applications for many clients on Upworks for the past years or so, but we have been developing software for over 20 years. We have developed applications using the following: FileMaker Pro, OpenIns Lisää

$650 AUD 4 päivässä
(3 arvostelua)

Hello We are Microsoft Access experts. We have done several Client Management, Invoicing, office and job Management projects using MS access. We have created following Microsoft Access based software : + Pathology Lisää

$500 AUD 25 päivässä
(1 arvostelu)

Hi, Please to meet you. I'm Manish and I found your job profile interesting. Happy to create a database on Microsoft Access and move your speadsheets data into the software. I have sound knowledge working with MS E Lisää

$700 AUD 15 päivässä
(3 arvostelua)

Hi, there I have read this job specification very carefully with great interest. I have over 6 years experiences in access, so that I feel 100% sure to finish it up on time with required quality. I hope your kind reply Lisää

$300 AUD 3 päivässä
(1 arvostelu)
(3 arvostelua)
(3 arvostelua)

Hi, I have read your job requirements and specifications.i am a professional Statistician with master degree in Statistics and professionally qualified in statistics from the Royal Statistical Society London by passing Lisää

$444 AUD 3 päivässä
(1 arvostelu)