BTM 200 MINI CASE

GuidelinesFrom your training, you remember that the solution procedure for each client will not be straight forward with a set of steps to follow as each of their problems will be different. However, you remember the basic guidelinesyour trainer taught you when looking for a solution:1)Type the data in Excel2)Organize your data with titles3)Addtables,charts and functions if needed4)Add columns and rows when needed to help your analysis (sums, averages, etc)5)Structure your analysis so your client can understand how you came to the solution6)Highlight the cell which contains the answer(s) to your client’s problem(s)For Scenario B:You werealso trainedonAccessto create adatabase that will help your client bettercapture, integrate and analyzefuture datasets. You remember that your trainer also gave you some guidelines for creating an Access database:1)Identify all fields needed in the dataset (columns)2)Start by creating your tables(database)3)Create forms to help capture the data4)Create relevant reportsfor your client