1.\u00a0\u00a0\u00a0\u00a0 Assignment: MS Access\u00ae Exercise “\ufffd Due Day 7\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Complete the following tasks using Microsoft\u00ae Access\u00ae:\t\u00a0\to\u00a0\u00a0\u00a0 Create a database consisting of two tables.\to\u00a0\u00a0\u00a0 Name both tables.\to\u00a0\u00a0\u00a0 Create fields for each table. The first table must contain the following fields:\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Student ID number\t\u00b7 \ufffd\u00a0\u00a0\u00a0 First name\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Last name\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Gender\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Phone number\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Address\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Major\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Minor\t\u00a0\tThe second table must contain the following fields:\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Student ID number\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Course\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Letter grade\t\u00a0\to\u00a0\u00a0\u00a0 Establish a primary key for each table.\to\u00a0\u00a0\u00a0 Create a relationship between the two tables.\to\u00a0\u00a0\u00a0 Set appropriate properties for all fields.\to\u00a0\u00a0\u00a0 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.\to\u00a0\u00a0\u00a0 Create a report containing student ID numbers, first names, last names, courses, and letter grades for all students.\to\u00a0\u00a0\u00a0 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.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Read the following scenarios:\t\u00a0\tYou are working at a support desk for a company providing onsite and telephone support to customers with Microsoft\u00ae Access\u00ae questions. On this particular day, you are presented with the following three situations:\t\u00a0\tSituation 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\u00ae Access\u00ae. He wants to know about the key functions of using Microsoft\u00ae Access\u00ae and how a table, query, primary key, and a report are important to his database needs.\t\u00a0\tSituation 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.\t\u00a0\tSituation 3: Stephanie has been using a Microsoft\u00ae Access\u00ae 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.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Write a 1-page response for each of the three situations. Include the following items in each response:\t\u00a0\to\u00a0\u00a0\u00a0 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?\t\u00a0\to\u00a0\u00a0\u00a0 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.\t\u00a0\to\u00a0\u00a0\u00a0 Once the causes are identified, describe a step-by-step troubleshooting process to help the customer complete the task.\t\u00a0\to\u00a0\u00a0\u00a0 If the customer has problems understanding your instructions, briefly explain an alternative solution.<\/p>\n","protected":false},"excerpt":{"rendered":"
1.\u00a0\u00a0\u00a0\u00a0 Assignment: MS Access\u00ae Exercise “\ufffd Due Day 7 \u00a0 \u00b7 \ufffd\u00a0\u00a0\u00a0 Complete the following tasks using Microsoft\u00ae Access\u00ae: \u00a0 o\u00a0\u00a0\u00a0 Create a database consisting of two tables. o\u00a0\u00a0\u00a0 Name both tables. o\u00a0\u00a0\u00a0 Create fields for each table. The first Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-225505","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=225505"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225505\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=225505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=225505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=225505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}