For more course tutorials visit
Tutorial
Purchased: 3 Times, Rating: A
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