DISC 4372 FINAL SPRING 1998 v4

Name__________________________Exam Number_____________

SS#____________________________

Database Name _______

Homepage URL_______________________________

Time of Exam Start__________________________

Part 1 of 2 (50 points)

Run glrestor.htm on your database to restore it to its original status.

1.1 Add the following accounts to the general ledger:

MajorMinorSub 1Sub 2
1000400000000000
1000500000000000
1000600000000000
1000700000000000

1.2 Delete the following accounts from the general ledger:

MajorMinorSub 1Sub 2
1900900000000000
9100100000000000

1.3 Using your transaction system post the following journal vouchers to your general ledger system:

SRN: 7111Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
25001000000000007.00 
SRN: 7112Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
24001000000000007.00 
SRN: 7113Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
91001000000000007.00 
SRN: 7114Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-75.00 
999999990000000075.00 
SRN: 7115Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000100.00 
4000300010000000-20.00 
4000300020000000-20.00 
4000300030000000-20.00 
4000100000000000-20.00 
4000200000000000-20.00 
SRN: 7116Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.00 
500010001000000025.00 
600010001000000025.00 
700010001000000025.00 
800010001000000025.00 
SRN: 7117Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
90005000000000007.00 
SRN: 7118Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
9999999900000000-7.00 
40004000000000007.00 

When finished, bring up your trial balance (a44.asp) and notify Parks you are ready to have Part One graded.

Part 2

2.1 FTP your a45.asp to the local drive. Save it as a55.asp. Modify the program to report from the JE table all Journal Vouchers. The report should show all entries in the je table sorted by "minor". Do NOT list any journal entries where minor=1000.


Save this a55.asp locally. FTP it back to the server. Add a "Some JEs Report" link to the assignments homepage that runs the a55.asp you just wrote.

Print your (1) a3.htm (2) a3.asp (the posting active server page that processes transactions) and (3) your new a55.asp. Put your name, SSN, Database Acct on each page. Turn these in.

When finished contact Parks.