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:
Major | Minor | Sub 1 | Sub 2 |
1000 | 4000 | 0000 | 0000 |
1000 | 5000 | 0000 | 0000 |
1000 | 6000 | 0000 | 0000 |
1000 | 7000 | 0000 | 0000 |
1.2 Delete the following accounts from the general ledger:
Major | Minor | Sub 1 | Sub 2 |
1900 | 9000 | 0000 | 0000 |
9100 | 1000 | 0000 | 0000 |
1.3 Using your transaction system post the following journal vouchers to your general ledger system:
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.
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.
SRN: 7111 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -7.00 2500 1000 0000 0000 7.00 SRN: 7112 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -7.00 2400 1000 0000 0000 7.00 SRN: 7113 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -7.00 9100 1000 0000 0000 7.00 SRN: 7114 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -75.00 9999 9999 0000 0000 75.00 SRN: 7115 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 100.00 4000 3000 1000 0000 -20.00 4000 3000 2000 0000 -20.00 4000 3000 3000 0000 -20.00 4000 1000 0000 0000 -20.00 4000 2000 0000 0000 -20.00 SRN: 7116 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -100.00 5000 1000 1000 0000 25.00 6000 1000 1000 0000 25.00 7000 1000 1000 0000 25.00 8000 1000 1000 0000 25.00 SRN: 7117 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -7.00 9000 5000 0000 0000 7.00 SRN: 7118 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 9999 9999 0000 0000 -7.00 4000 4000 0000 0000 7.00
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.