For more
course tutorials visit
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.
