This
document is made part of the class syllabus, and supersedes any previous
project schedule(s). The following projects are the culmination of the course,
and you, at this point, have acquired the necessary skills to analyze, organize,
and develop the following projects. Remedial experiences and subjects are
assumed.
Please
complete the following databases as if you were the Business Consultant. You
have the basic knowledge, as general information, obtained from the all lectures,
all notes, text, databases (1-6), all overhead presentations, all board work
presentations, and any hints. . .You are to take the given information (data)
for each database project, and add, delete, and correct, if necessary, any
data, fields, records, or structure.
It
is necessary that these projects are done independently, and developed and
solved with your own analysis. The completed projects will be presented and
submitted to the instructor in the time specified in class, and in this
document. Late projects are penalized one grade point on a four-point scale.
Any project two or more days late will not be accepted.
Project
1 (Due Week Nine)
You
are the consultant. Create a database named “salesperson” with two tables. The
first table should, at least, include the following fields: salespersonnumber,
firstname, lastname. The
second table should, at least, include the following fields: invoicenumber, productsold, salespersonnumber, totalinvoice,
and the dateinvoiced.
You
must set the primary key and relationship. You must develop a form and
sub-form. Create a report and a form to at least include calculations.
Project
2 (Due Week Nine)
You
are the consultant. Create a database named “order” with three tables. The
first table should be named “order” and, at least, include the following
fields: ordernumber, customername,
and employeenumber. The second table should be named
“orderdetail” and, at least, include the following
fields: order, productid, and sellingprice.
The third table should be named “products” and, at least, include the following
fields: productid, productname,
and sellingprice.
You
must create a query, form, and a report. Enter some duplicate records. Use the
Access help menu to find the concept “index.” Use index to enter duplicate
records.
Project
3 (Due Week Nine)
You
are the consultant. Create a database named “scores” with two tables. The first
table should, at least, include the following fields: lastname,
firstname, address, city, state, zip, phone, country,
and scoreqtr1. The second table should, at least, include the following fields:
lastname, finalexamscore,
and scoresqtr2. The weight for scoresqtr1 is .25, and the weight for scoresqtr2
is .25. The finalexamscore weight is .50.
You
must, at least, create query calculations concerning the difference and percent
change between the ending and beginning scoresqtr
fields. Create a weighted average score for scoresqtr1, scoresqtr2, and the finalexamscore.
You
must also, at least, create form/report calculations concerning the average,
maximum, minimum, standard-deviation for finalexamscore.
Project
4 (Due Week Ten)
You
are the consultant. Create a database named “communication” with three tables.
The first table named “name” should, at least, include the following fields:
#id, lastname, firstname,
salary. The second table named “address” should, at least, include the
following fields: #id, address, city, state, zip. The third table named “comm” should, at least, include the following fields: #id,
phone, and fax.
Create
a form/subform.
Create internal and external hyperlinks. View “index” for duplicate
records from the help menu.
Project
5 (Due Week Ten)
You
are the consultant. Create a database named “customer” with two tables. The
first table named “customerrecord” should, at least,
include the following fields: customernumber, customername, street, city, state, zip, country phone, and contactdate. The second table named “orderrecord”
should, at least, include the following fields:ordernumber, customernumer,
saledate, shipper, totalinvoice,
amountpaid, paymethod.
Create
a query that shows a balance of the account. Create a report that shows the
sum, count, maximum, minimum, and average for each of the following
fields: “totalinvoice”
and “amountpaid”
Project
6 (Due Week Ten)
You
are the consultant. Develop a music shop database. Include, at least, some of
the following fields: typeofmusic, singer, label,
song, release date, mode, price, singerid, singeradvance, contractdate cost.
Among other items, at least, include a formula that
illustrate the gross profit. Also, include some calculations that show the total of the price and
cost fields.
Project
7 (Due Week Eleven)
Create
a household inventory database. You are the consultant. Include, at least, some
of the following fields: photograph, householdid, categoryid, roomid, description,
model modelnumber, datepurchased,
purchaseprice, replacementvalue.
Lab1
(Due Week Eleven)
You
are the consultant. Create a database named “ratios” with two tables. The first
table named “company” should, at least, include the following fields: companyid, companyname, and
industry. The second table named “details” should, at least, include the
following fields: companyid, year, longtermassets, shorttermassets,
sales, costofgoodssold.
Create
the rate of return and profit margin ratios. Remember: shorttermassets
+ longtermassets=assets and profit margin=sales-costofgoodssold. The formula for the rate of return is
profits/assets, and formula for the profit margin is profits/sales.
Lab2
(Due Week Eleven)
You
are the consultant. Create a database named “used cars” and it should, at
least, include the following fields: vehicleid,
manufacturer, model classtype, transmissiontype,
year, cost, sellingprice, profitmargin.
Project
8 (Due Week Eleven)
You
are the consultant. Create a database named “customer2” with two tables. The
first table named “customer” should, at least, include the following fields: lastname, firstname, street,
city, state, zip, country, socialsecuritynumber. The
second table named “deposits” should, at least, include the following fields: lastname, accountnumber, date,
deposits, phone, status.
Create
query calculations to, at least, include percent-change, future value, and
present-value. Use an annual interest rate .06, compounded semiannualy
for two years.
Develop
a report to, at least, include sum, standard deviation,
count, average, and maximum for deposits.
Project
9 (Due Week Twelve)
You
are the consultant. Create a database named “customer3” with two tables. The first
table named “customer” should, at least, include the following fields: customerid, invoiceid, customername, street, city, state, zip, country. The second
table named “order” should, at least, include the following fields: customername, orderdate, phone, orderamount, status, customerid.
Develop
referential integrity, and set a primary key. Create a parameter query, action
query, cross tab, and a concatenation. Create calculations in a query and a
report. Insert an image or chart.
Project
10 (Due Week Twelve)
Open
the mdbEventManagement2-2 database located on the data disk. You want to make
simple for users to enter valid data. Define a Validation Rule for the StartDate and the EndDate fields
in the Event table. The dates should be no earlier than
Project
11 (Due Week Twelve)
Create a
copy of the mdbFanTours9database located on the data disk. Open the tblEmployees table in Design view. Create a Validation Rule
that requires the employees hire date to be on or after
Web
pages will be assigned and
developed by the students.
All Rights Reserved,
Glenn Knapp
2002