I gang

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.

Evner: Excel, Programmering af database, Microsoft Access

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Elderslie, Australia

Projekt ID: #27872705

Tildelt til:

VladimirLilenko

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 Flere

$500 AUD in 5 dage
(211 bedømmelser)
6.9
(337 bedømmelser)
7.8

31 freelancere byder i gennemsnit $496 timen for dette job

schoudhary1553

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 Flere

$400 AUD in 6 dage
(382 bedømmelser)
8.1
finecodervw

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 Flere

$300 AUD in 5 dage
(113 bedømmelser)
6.4
(60 bedømmelser)
6.6
royalcalif

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 Flere

$250 AUD in 6 dage
(124 bedømmelser)
6.3
zu02

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: ------------------------------------------------------------------------- Flere

$750 AUD in 7 dage
(60 bedømmelser)
6.2
expertcoder1vw

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 Flere

$750 AUD in 10 dage
(43 bedømmelser)
5.9
writingapp

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 in 6 dage
(62 bedømmelser)
5.5
nlikhon

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

$550 AUD in 3 dage
(54 bedømmelser)
5.7
AgentEdge

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 Flere

$250 AUD på 1 dag
(18 bedømmelser)
5.0
MHassanBedor

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

$500 AUD in 7 dage
(14 bedømmelser)
4.4
(31 bedømmelser)
4.7
hayteekeys

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 Flere

$250 AUD in 2 dage
(8 bedømmelser)
4.1
chintuag

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 Flere

$557 AUD in 7 dage
(8 bedømmelser)
3.9
maxdmg

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 Flere

$650 AUD in 4 dage
(3 bedømmelser)
3.5
accessdeveloper

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 Flere

$500 AUD in 25 dage
(1 bedømmelse)
2.8
manishp2015

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 Flere

$700 AUD in 15 dage
(3 bedømmelser)
1.8
woshiang717

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 Flere

$300 AUD in 3 dage
(1 bedømmelse)
1.8
(3 bedømmelser)
1.9
(3 bedømmelser)
1.9
bamiteko1969

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 Flere

$444 AUD in 3 dage
(1 bedømmelse)
1.7