MS Access: Supplier Database Business Plan

Total Length: 319 words ( 1 double-spaced pages)

Total Sources: 0

Supplier Database: MS Access

If your database contained around 1000 suppliers (using the same fields contained in this exercise and no other), what other types of reports beside contact information could you create with the data?

Well, apart from a contacts report, the data fields used in this exercise can conveniently be used to generate both a supplier-sales report and supplier revenue report. The YTD order figure represents the supplier's sales level. For instance, we could take the YTD order to be a measure of the number of orders placed for the company's products by customers from, say, three years in the past. If we are comparing 1000 producers dealing in the supply of, in our case, a particular mouse model from a specific manufacturer, then we can compare suppliers based on their level of sales and consequently, size -- higher YTD order figures can rightly be taken to indicate higher online sales levels, higher sales revenues, and consequently, larger sizes.


Question Two

How would these reports assist you in preparing your solution to your case study?

The contacts report prepared in this exercise informs the assessor's decision by showing the suitability, in terms of proximity to the company, of each of the potential suppliers. The further away the supplier is, the higher the costs that will be incurred in transportation costs; therefore, it makes sense to pick a supplier who is located within reasonable reach. The sales-size and sales-revenue….....

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"MS Access Supplier Database" (2015, February 19) Retrieved June 6, 2026, from
https://www.aceyourpaper.com/essays/ms-access-supplier-database-2148771

Latest MLA Format (8th edition)

Copy Reference
"MS Access Supplier Database" 19 February 2015. Web.6 June. 2026. <
https://www.aceyourpaper.com/essays/ms-access-supplier-database-2148771>

Latest Chicago Format (16th edition)

Copy Reference
"MS Access Supplier Database", 19 February 2015, Accessed.6 June. 2026,
https://www.aceyourpaper.com/essays/ms-access-supplier-database-2148771