In Progress

CREATE ORDER ENTRY PROGRAM IN ACCESS

We operate a number of websites and ebay stores. We don't make a lot of money so we don't want to invest in a multi-channel online system. We sell both inventory that we have and drop shipping.

We need an access database which will allow us to enter orders - in two currencies, track the customer information, order information (products purchased, quantity, what site the order came from) and the taxes. We also need to track when the order was placed with one of our vendors (date), shipping information (date shipped, method, tracking #). Shipping cost to customer needs to be set up as well.

We also need to be able to produce an invoice; and the invoice # has to be automatically generated. The invoice needs to relate to the source of the sale (i.e. we only own one company but need to produce an invoice based on the website it was purchased from - so we need to either select the invoice report (there should be 4 of these), OR the source of the order, automatically identifies the invoice produced.

We need to be able to produce pick lists and maintain an inventory of actual items we have in stock. Product Code, Product Description, Selling Price and Quantity on Hand. We would like to override the selling price, as we have items which sell for different prices on different sites.

I've attached a word document with more information and an excel file showing the tables that need to be created.

Skills: Microsoft Access, SQL

See more: sql inventory system, multi program online, make program sell online, make actual money online, create websites online, create website online invest, sql microsoft access, microsoft word sale, microsoft excel price, microsoft access sql, ebay stores sale, ebay drop shipping, drop shipping ebay, microsoft access online, microsoft access website, create websites money, sell entry, multi channel, in stock, want invest, create invoice, database invoice microsoft access, customer invoice report, order online system, create sql report

About the Employer:
( 18 reviews ) Stoney Creek, Canada

Project ID: #5726159

33 freelancers are bidding on average $491 for this job

Prashantskin

Res.Buyer I have gone through your project requirements and the excel and document files.. I will create an access database which will allow you to enter orders - in two currencies, track the customer information More

$555 USD in 5 days
(491 Reviews)
7.2
rhomeu

Hi, I have read your specifications it sounds clear for me for the moment. For items with the same name but different in sizes and color it is better to separate them as a different item so we can track the invento More

$750 USD in 7 days
(65 Reviews)
7.0
jawadaman

Hi, I am interested in this project. I can do this job for you. I am an experienced IT professional with 13 years of experience and hand-on experience of MS-Access database development. if interested in hiring me then More

$250 USD in 10 days
(69 Reviews)
5.6
abdellatif81

Hello DISCOUNTWIG , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Micros More

$684 USD in 10 days
(20 Reviews)
5.3
farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data More

$250 USD in 5 days
(22 Reviews)
5.3
winnet21

Hi, I have experience with this project, please refer programs that I done here: http://winnet.vn I send a small example that i doing, please download here : https://www.amazon.com/clouddrive/share?s=dPn4XpgPQdohoq5 More

$526 USD in 25 days
(24 Reviews)
5.3
alekhine1962

Dear Buyer, I have been working with Access databases since 1998 ... I have gone through your attached documents. Both are really descriptive about your requirements ... About the selection of Company Name / Logo More

$250 USD in 10 days
(25 Reviews)
4.8
elboukharimu

Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfol More

$947 USD in 20 days
(31 Reviews)
5.4
nblsoft

Hello sir, I am interested in your project and offer my services. I have gone through your project details and checked files you supplied. I have added a portfolio item just for you to review, Softdrink manage More

$555 USD in 15 days
(6 Reviews)
4.5
sunshinelabs

You need an MS SQL Database setup using .NET, NOT Access...MSSQL is "Access' Big Brother" You can get a 1-year free Amazon AWS account that will let you have an MSSQL server and web server if you don't already have More

$556 USD in 10 days
(5 Reviews)
3.9
Pharoa

Thanks for the opportunity to bid on your project. I specialize in accounting and Point of Sale solutions and shall bring over 20 experience developing business applications to this role. I have worked with Ms Acces More

$500 USD in 10 days
(1 Review)
3.6
andriy3s

Hi, I've very interesting proposition for you. I'm developer from GGDS (Green Global Data Solutions - company from Canada, MB). You could find us in ggds.ca where are some extra information as well. We develop ap More

$250 USD in 20 days
(14 Reviews)
3.4
swarm22

A proposal has not yet been provided

$555 USD in 15 days
(6 Reviews)
2.9
pnjadhav

I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based More

$833 USD in 10 days
(2 Reviews)
3.0
fazeelatmazhar

Sir, Greetings. This is an IT person and a technical writer. I have seen the attached files.Let me know if you need any other specifications as well. I need to discuss this section "We need to be able to produc More

$250 USD in 7 days
(9 Reviews)
3.1
driverahz

Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.

$250 USD in 5 days
(1 Review)
2.3
navindodanwela

I have over 9 years of experience in the IT industry. I have developed a similar system utilizing MS SQL server and Visual Basic for a retailer in Sri Lanka who also maintains a minor online store. I have a good unders More

$399 USD in 20 days
(0 Reviews)
0.0
rajaeian

BSc in industrial Engineerign MBA PhD student in Information Systems more 12 years of experience in sysment minimum price anything else?

$250 USD in 8 days
(0 Reviews)
0.0
iikaz

Years of experience in developing robust databases in MS Access for investment and utility companies. These apps automated inventory management, investment reporting, accounting reconciliations, and populated informat More

$250 USD in 10 days
(0 Reviews)
0.0
CertifiedKennedy

This seems like a fun project to design. I have solid experience in MS Access, SQL, and Visual Basic. In fact I created an application to manage inventory, create barcodes, and manage payroll, all from scratch. I ha More

$555 USD in 10 days
(0 Reviews)
0.0