Mouse Computer School

Background

You are enrolled in a computer course at Mouse Computer School. The following questions all concern aspects of that school.

Create a folder called MOUSE in which all files must be saved.

Print your work as you go through the paper. Do not leave the printing to the end.

	Print and hand in		Files in the MOUSE folder
A3	LISTDATA table	A3	MOUSE with table LISTDATA
A4	Amount Owing report	B1	LETTHEAD
B2	Non mail-merged letter	B2	MERGE
B3	Merged letter to Your Name

Question A

Create a database called MOUSE. Create the following table structure called LISTDATA

Field name	Data type	Field size	Primary key	Description
StudNo	Text	6	Yes	Student number (Primary key)
Name	Text	20		Student's name
Diploma	Text	12		CAD, E-Commerce, Networking
Courses	Number			Number of students
Fees	Currency			Tuition fees due (Rand)

Add the following records to the database structure:

StudNo	Name	Diploma	Courses	Fees
1111	White A.B	E-Commerce	12	3050.00
5555	Brown B R	Networking	5	1200.00
4444	Black K C	CAD	8	2750.75
9999	Green W	Networking	6	2000.50
3333	Cyan W C	E-Commerce	6	1800.00
2222	Red L M	E-Commerce	6	1525.00
7405	Name Your	CSSG	7	1999.00

Display the table in list view (table format) and resize the fields to display all data. Print the table LISTDATA in landscape. Save the table as LISTDATA..

Create a database report entitled Amount Owing, including just the Names of all the students and the Fees. Print the report Amount Owing.

Question B

Using a word processor design a letterhead for the school, showing all its details (as provided below). Make sure that the letterhead only takes up a few lines at the top of a sheet of paper. (Some marks will be awarded for the use of different fonts, size, etc.) Save your design with the name LETTHEAD.

Name of computer school	Mouse Computer School
Postal address	P O Box 674 Table View 7439
Physical address	145 South Road Table View 7441
Telephone	557 1234
Fax	577 1235
Email address	bmouse@iafrica.com
URL	http://www.mouse.co.za

The students whose details are contained in the database will receive accounts at the end of October. Use the letterhead you have created, and the format of the letter below, to create a form (mail merge) letter to be sent to these students. Use the database table called LISTDATA in the database called MOUSE. Save the letter with the file name MERGE. Print a plain (non mail-merged) copy showing field markers.

Letterhead

17 July 2005

Dear XXXNameXXX

Please be informed that you owe the institution the amount of XXXXXFeesXXXXXXX for the XXXXDiplomaXXX Diploma. We hope that payment will be made by 30 November 2002.

Yours sincerely

B. Mouse

Merge the Names and Fees that are stored in the table with the form letter. Print a copy of one letter to the student called (Your Name) on the school letterhead.

PHS CyberSchool