1. Assignment: MS Access® Exercise “� Due Day 7 · � Complete the following tasks using Microsoft® Access®: o Create a database consisting of two tables. o Name both tables. o Create fields for each table. The first table must contain the following fields: · � Student ID number · � First name · � Last name · � Gender · � Phone number · � Address · � Major · � Minor The second table must contain the following fields: · � Student ID number · � Course · � Letter grade o Establish a primary key for each table. o Create a relationship between the two tables. o Set appropriate properties for all fields. o Enter at least five mock student records in the first table. In the second table, enter at least three courses for each student listed in the first table. o Create a report containing student ID numbers, first names, last names, courses, and letter grades for all students. o Create a query to search for students who received an A in a course. Display student ID number, first name, and last name in the query. · � Read the following scenarios: You are working at a support desk for a company providing onsite and telephone support to customers with Microsoft® Access® questions. On this particular day, you are presented with the following three situations: Situation 1: Jack, a veterinarian, has experienced tremendous growth within his business. All animal records are shelved in folders and are sorted alphabetically by the owner’s name. Jack is ready to rid himself of the time and space these files take and has inquired about Microsoft® Access®. He wants to know about the key functions of using Microsoft® Access® and how a table, query, primary key, and a report are important to his database needs. Situation 2: Frank has created a database to inventory his customers’ past due accounts to ensure that he receives payment. He has created two tables: one for customer demographics, and the other for the type of service rendered. When he creates a report, the customers’ demographics are all that show and not the amount that is past due. Situation 3: Stephanie has been using a Microsoft® Access® database and queries to track her commemorative plate collection. She recently discovered that her plates have serial numbers and decided to record these within her database. When she replaced each plate’s ID with the appropriate serial number, she was unable to use her queries. She wants to know why this has happened. Stephanie also wants to know if each serial number is unique or similar to the assigned ID number she has used in the past. · � Write a 1-page response for each of the three situations. Include the following items in each response: o Identify a general approach for facilitating the customer over the telephone. What are possible challenges in the given situation? What strategies would help you overcome the challenges? o If causes to the problem or question described by the customer are unclear in the situation, explain how you would further diagnose the problem or question. o Once the causes are identified, describe a step-by-step troubleshooting process to help the customer complete the task. o If the customer has problems understanding your instructions, briefly explain an alternative solution.