A new owner has purchased Swagger Distribution Company, a company that distributes clothing and apparel
A new owner has purchased Swagger Distribution Company, a company that distributes clothing and apparel. She does not have experience with IT-relatedproblem solving, so she is contracting you, as an IT consultant, to help. For Milestone One, you will submit a document summarizing the human-computerinterface (HCI), information management/database (IMD), and programming components of the distribution company using appropriate IT terminology.Human-Computer Interface (HCI): On a daily basis, Swagger Distribution’s employees log in to the company’s network and utilize many different types ofsoftware and the internet. They use Microsoft Word and Microsoft Visio daily. Summarize the human-computer interface (HCI) of these two softwareapplications. Be sure to note any commonalities between the applications and note any metaphors that are utilized. Suggest one enhancement to one of the twoapplications that would improve HCI, supported by at least one example for the suggestion. Create a brief tutorial for Microsoft Visio, including screenshots, fornew employees who are familiar with Microsoft Word but have never used Microsoft Visio. Cover at least two basic functions and/or menu options. Usefundamental IT terminology to label components in the tutorial. Label at least five components in the tutorial.Databases: Swagger Distribution’s partners/customers include a variety of clothing companies. Swagger Distribution utilizes a database to store information onthe partner companies and the orders that are received. You will review the provided database for Swagger Distribution and summarize what the tables containand what the queries do. Be sure to apply key terms that you have learned such as “metadata.” Based on information provided, you will change one data type inone of the tables. Specifically:1. Open up each table in the database to look at the data and examine its formatting. Be sure to open each table in regular view and design view. Describeeach table and the information it stores. Discuss any data types present other than text.2. Open up the table “Clothing Products” in design view. Change the data type of the “Retail Price” field from “text” to “Currency.” Now reopen the table“Clothing Products” in design view and notice the change. Provide a description of your actions and the results.3. Run the query “Retail Purchases” by double-clicking on the query. Make note that it is an empty query. Open up the query in design view. Make note ofthe actions it is taking and how the tables are linked. Why does the query provide no results? Describe how the tables are linked together and what thequery is doing.4. Open up the table “Retail Stores.” Make selections for each retailer in the “Clothing Item” field. Now close the table. Re-run the query “RetailPurchases.” Do you now have results? What do these results represent? Describe each column in the table. The screenshot of your results needs to beincluded with your final submission for this milestone.Programming: Every day, when an employee of Swagger Distribution signs on to her computer, a pop-up window opens and gives a greeting to the employee.The new owner would like to continue to have the pop-up window but would like to change the greeting. You will open up the current code and identify the keycomponents of the code that need to be changed and make those changes. Submit the modified code and identify the various components of that code.