DISC 4372 FINAL FALL 1999 ver 2
Name___________________________ Exam Number_____________
SS#____________________________Database Name _______
Homepage URL_______________________________
Time of Exam Start_____________ End Time_____________

Part 1 of 2 (50 points)

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

On all the add/modify/delete's and journal vouchers below, write the outcome of the update (i.e, worked ok or failed).

1.1 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome

4000 3000 3000 0000 Catalog Revenues Fall

4000 3000 4000 0000 Catalog Revenues Winter

4000 3000 5000 0000 Catalog Revenues Spring

4000 3000 6000 0000 Cash Revenues Summer

1000 4000 0000 0000 Cash AZ Office Pheonix B&T 2334-98676

1.2 Delete the following accounts from the general ledger:

Major Minor Sub 1 Sub 2 Outcome

1000 4000 0000 0000

3000 5000 0000 0000

4000 2000 0000 0000

1.3 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome

9000 4000 0000 0000 Insurance Expense

1000 1000 0000 0000 Cash Operating Houston B&T AN 888-8888

1000 6000 0000 0000 Cash Florida

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

SRN: 4111 Fiscal
Month 8

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -700.22 Texas Sales Tax

2500 1000 0000 0000 700.22

SRN: 4112 Fiscal
Month 8

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -5432.20 Federal Taxes

2400 1000 0000 0000 5432.20

SRN: 4113 Fiscal
Month 8

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -7.11

9100 1000 0000 0000 7.11

SRN: 4114 Fiscal
Month 8

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -975.00 to fix suspense

9999 9999 0000 0000 975.00

SRN: 4115 Fiscal
Month 9

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 100.20 record some sales

1000 2000 0000 0000 20.10

1000 3000 0000 0000 20.10

4000 3000 3000 0000 -140.40

SRN: 4119 Fiscal
Month 9

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -100.01 fix sales suspense error

1000 2000 0000 0000 -20.00

1000 3000 0000 0000 -20.00

9999 9999 0000 0000 140.00

SRN: 4116 Fiscal
Month 9

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -100.04 fix sales report

5000 1000 1000 0000 25.01

6000 1000 1000 0000 25.01

7000 1000 1000 0000 25.01

8000 1000 1000 0000 25.01

SRN: 4117 Fiscal
Month 9

Major Minor Sub 1 Sub 2 Amount Description Outcome

1000 1000 0000 0000 -37.02

9000 5000 0000 0000 37.20

SRN: 4118 Fiscal
Month 9

Major Minor Sub 1 Sub 2 Amount Description Outcome

9999 9999 0000 0000 -9972.03 fix suspense again

4000 4000 0000 0000 9972.03

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

PART 2 of 2 (50 points)

(DO NOT RUN glrestor before performing this part )

Given the following table heading of an asp page:

Write the asp page that:

Fills the table with journal entries from the je table according to the selections contained in the headings.
- The report should show ALL entries in je that match the chosen field value in the textboxes on the fourth row. Only one textbox should have a user entered value. If more than one is non-blank use the first ONLY. If all text boxes are blank then show all rows in je. The asp should use the LIKE qualifier to perform selections.
- All the radio buttons have the same name. So only one sort option may be chosen
- All sorts are ascending order
The first pass asp page contains NO data -- just the headings and the button (as shown above)
All subsequent passes should have data rows (however, the selection may yield no rows that qualify)
Show the count of rows retrieved at the bottom of the report

Print:

a3.htm
a3.asp (the posting active server page that processes transactions), and
your part two asp.

Put your name, SSN, Database Acct # on each page.
Be ready to turn these in.

When finished contact Parks.

SRN:	4111	Fiscal Month	8
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-700.22	Texas Sales Tax
2500	1000	0000	0000	700.22
SRN:	4112	Fiscal Month	8
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-5432.20	Federal Taxes
2400	1000	0000	0000	5432.20
SRN:	4113	Fiscal Month	8
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-7.11
9100	1000	0000	0000	7.11
SRN:	4114	Fiscal Month	8
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-975.00	to fix suspense
9999	9999	0000	0000	975.00
SRN:	4115	Fiscal Month	9
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	100.20	record some sales
1000	2000	0000	0000	20.10
1000	3000	0000	0000	20.10
4000	3000	3000	0000	-140.40
SRN:	4119	Fiscal Month	9
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-100.01	fix sales suspense error
1000	2000	0000	0000	-20.00
1000	3000	0000	0000	-20.00
9999	9999	0000	0000	140.00
SRN:	4116	Fiscal Month	9
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-100.04	fix sales report
5000	1000	1000	0000	25.01
6000	1000	1000	0000	25.01
7000	1000	1000	0000	25.01
8000	1000	1000	0000	25.01
SRN:	4117	Fiscal Month	9
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
1000	1000	0000	0000	-37.02
9000	5000	0000	0000	37.20
SRN:	4118	Fiscal Month	9
Major	Minor	Sub 1	Sub 2	Amount	Description	Outcome
9999	9999	0000	0000	-9972.03	fix suspense again
4000	4000	0000	0000	9972.03

Posted Journal Entry Query
Sort by: SRN Major Minor Sub1 Sub 2 Transaction Amount

Enter search requirements in ONE textbox below.

Source
Ref Num

Description

Transaction
Amount

.
.
.
journal entries go here
.
.
.