Tech Company Sales and Inventory Database

This is a database that we have created that tracks sales and inventory including costs, and commissions. It includes queries, forms, and reports that allow us to access specific information without going though a tremendous amount of data in excel spreadsheets. For Group 5’s project, we are a technology company that makes cell phones, mobile tablets, headphones, and device chargers. The data we have put together in this project will help is in important decision-making moments and assist with making direct comparisons between employees and products. Most importantly, it assists us with improving efficiency and tracks daily operations management within our company.

Group members include:
• Sophia Peceli
• Ivrona Page
• Shakeel Hamdani
• Anthony Okun
• Evan Le Grand-Sawyer



Database reports: (to download, highlight url, right click, click "go to...")

Employee Information Reports: http://webpages.csus.edu/anthonyokun/Empl%20info%20report.xls


Employee Sales Reports: http://webpages.csus.edu/anthonyokun/Employee%20sale%20report.xls

Inventory reports: http://webpages.csus.edu/anthonyokun/Inventory%20cost%20report.xls

Supplier reports: http://webpages.csus.edu/anthonyokun/Supplier%20report.xls




Access Database File

http://webpages.csus.edu/anthonyokun/Project%20Database.mdb

---