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 a44.asp to the local drive. Save it as a55.asp. Modify the program so that the query produced is a balance sheet. The report should be:
.
TOTAL REVENUE x-------x (this is the sum of the revenue balances above)
EXPENSES:
NET INCOME x---------x (this is the difference in Revenues and Expenses above)
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
REVENUE:
.(show all accounts with first digit of major = 4 AND have a NON-ZERO BALANCE)
.
.
(show all accounts with first digit of major = 5,6,7,8 or 9 AND have a NON-ZERO BALANCE)
.
Save this a55.asp locally. FTP it back to the server. Add a "INCOME STATEMENT" link to the assignments homepage that runs the a55.asp you just wrote.