Find more Network And System Administration Remote Jobs posted recently Worldwide

Required software development freelancer for small business needs your help in making a database to track products and generate report job

Posted at - Mar 25, 2023

Toogit Instant Connect Enabled


Looking for a database developer to build in MS Access.
I need a database that is setup very similar to the product inventory template in access. I would need a way to show who is creating the entry in the database or some sort of login.
I would need the template modified to show just the main tables of Inventory, Shipping, QA/QC, and Sales. Or if creating from scratch is easier

When a product is ordered from a manufacturer, I would need a form to show name of manufacturer, order date, Qty, unit of measure, unit cost, total price. This would need to be linked to the inventory table.
In the inventory table, I would need fields of invoice #(linked to order form), product name, lot #, Qty, unit of measure, reserved inventory, available inventory (Qty - reserved), Retest date, # of days until retest (Todays date - retest date), Status, and location.

In the shipping table, I would need the following fields. Ship date, customer name, ship to, invoice # (linked to order form), Customer PO#, Product name, Lot #, Qty, unit of measure (linked to inventory), total items, Shipping type, Tracking #, Status. Once product is shipped out, the qty of product available should decrease.

In the QA/QC table, I would need the following fields. Receiving date, product name, qty, unit of measure, total qty. Invoice # (linked to order form). Mfg Tracking #, Lot #, Retest date, Manufacturer name, vendor name, Status, NDC #, Note

Sales table. I would need Sales agent name, Customer name, Customer PO, Order Date, Product name, Quantity, unit of measure. Cost per unit. Total cost

I would need a report that can show real time data of products available in inventory, a report that shows products shipped each day, a report for # of sales per quarter by sales agent

About the recuiterMember since Nov 11, 2022 Dian Nurdianingsih
from Mississippi, United States

Skills & Expertise Required

software development 

Candidate shortlisted and hiredHiring open till - Sep 21, 2023

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$479.79
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Network And System Administration category.