I need to create a database in MS Access for a manufacturing facility, and I nee

Question

I need to create a database in MS Access for a manufacturing facility, and I need the Access file itself please. it is not important what kind of facility, however we need to have the following:

Description: This project asks you to create an inventory database for a manufacturing facility. You are free to create whatever type of facility you would like. However, you need to have the following: Inventory o Overall inventory o Area specific inventor Have at least 3 areas Users who can move and remove inventory o Have at least 3 users Users who can add inventory Queries o That show overall inventory status o That show individual area inventory statuses o That show overall and each individual area inventory status Three business rules Populated tables Deliverables: 1. Access file 2. Excel spreadsheet (export your database to an xlsx) 3. PDFs of reports

Explanation / Answer

This inventory database template is a warehouse software solution developed for cable television and satellite television installers. The Microsoft Access database employs barcode entry - speeding equipment inventory management.

NEW! Now you can also track bulk items such as connectors and LNBs ($1,299).

The major inventory management functions are as follows:

Add Warehouse Inventory Items

Issue Inventory to Technicians

Log Returned Items Back to Inventory

Warehouse Inventory Summary Report

Inventory Reports Menu

List MaintenanceAdd specific fields as necessary. Usual additions to MS Access databases for inventory include dates as well as quantitative fields like "units ordered" and "units received." As noted above, locations for production or product details may also apply.

NEW! Now you can also track bulk items such as connectors and LNBs ($1,299).

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.