A
Ackms421
I'm a student and I am struggling with this assignment. I am
completely unfamiliar with Access and I don't know where to begin on
part's c and d, and i'm not sure if i'm even doing b correctly. I'm
just going go ahead and type the whole thing here...please, one of you
have mercy...
You have the responsibility for managing technical training classes
within your organization. These classes fall under two general types:
highly technical training and end user training. Software engineers
sign up for the former, and administrative staff sign up for the
latter. Your supervisor measures your effectiveness in part based upon
the average cost per training hour and type of training. In short,
your supervisor expects the best training for the least cost.
To meet this need, you have negotiated an exclusive on-site
training contract with Hands On Technology Transfer, Inc.
(HOTT)(www.traininghott.com), a high-quality technical training
provider. Your negotiated rates are reproduced below in the pricing
table. A separate tble contains a sample list of courses you routinely
make available for your organization.
a. Using the data below, design and populate a table that includes
basic training rate information. Designate the "Technical" field type
as "Yes/No" (Boolean).
b. Using the data below, design and populate a course table. Designate
the CourseID field as "Primary Key," and allow your database to
automatically generate a value for this field. Designate the
"Technical" field type as "Yes/No" (Boolean).
c. Prepare a query that lists each course name and its cost per day of
training.
d. Prepare a query that lists the cost per student for each class.
Assume maximum capacity and that you will schedule two half-day classes
on the same day to take full advantage of HOTT's per-dy pricing
schedule.
PRICING TABLE
TECHNICAL PRICE PER DAY
CAPACITY
yes 2680
15
no 2144
30
COURSE TABLE
COURSE ID COURSE NAME DURATION
TECHNICAL
1 asp programming
5 yes
2 xml programming
5 yes
3 php programming
4 yes
4 microsoft word-advanced
.5 no
5 microsoft excel-advanced
.5 no
completely unfamiliar with Access and I don't know where to begin on
part's c and d, and i'm not sure if i'm even doing b correctly. I'm
just going go ahead and type the whole thing here...please, one of you
have mercy...
You have the responsibility for managing technical training classes
within your organization. These classes fall under two general types:
highly technical training and end user training. Software engineers
sign up for the former, and administrative staff sign up for the
latter. Your supervisor measures your effectiveness in part based upon
the average cost per training hour and type of training. In short,
your supervisor expects the best training for the least cost.
To meet this need, you have negotiated an exclusive on-site
training contract with Hands On Technology Transfer, Inc.
(HOTT)(www.traininghott.com), a high-quality technical training
provider. Your negotiated rates are reproduced below in the pricing
table. A separate tble contains a sample list of courses you routinely
make available for your organization.
a. Using the data below, design and populate a table that includes
basic training rate information. Designate the "Technical" field type
as "Yes/No" (Boolean).
b. Using the data below, design and populate a course table. Designate
the CourseID field as "Primary Key," and allow your database to
automatically generate a value for this field. Designate the
"Technical" field type as "Yes/No" (Boolean).
c. Prepare a query that lists each course name and its cost per day of
training.
d. Prepare a query that lists the cost per student for each class.
Assume maximum capacity and that you will schedule two half-day classes
on the same day to take full advantage of HOTT's per-dy pricing
schedule.
PRICING TABLE
TECHNICAL PRICE PER DAY
CAPACITY
yes 2680
15
no 2144
30
COURSE TABLE
COURSE ID COURSE NAME DURATION
TECHNICAL
1 asp programming
5 yes
2 xml programming
5 yes
3 php programming
4 yes
4 microsoft word-advanced
.5 no
5 microsoft excel-advanced
.5 no