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.
No comments:
Post a Comment