trial balance data base design for Model-II is used. . Using Model-III discuss the series of SQL statements to produce a trial balance up to a particular date. Project Work .
Payroll Accounting: Using the database design given in Exercise of Chapter-IV, as Project No: , you are required to generate the portion of payroll according to the specified format under MS Access environment. . Financial Accounting: Write the SQL statements for each of the following queries separately by using database design of accounting specified as Model- I, II and III in Chapter-IV. (a) List the transactions details of Accounts, which have been debited during the period April , to September , .
(b) List the transactions details of accounts which have been credited during the month of August . (c) Find the total expenses incurred during the period September, . (d) List all the transacted accounts with the amounts by which they have been debited and also the amount with which they have been credited. (e) List the amount of expenses authorised by each of the employees.
. Inventory Accounting: Using the database design developed in Exercise of Chapter-IV, for Project No: , you are required to generate Statement of closing stock in the following format by assuming that all goods are sold at a profit of % on purchase price. Statement of Closing Stock Particulars Purchases Sales Balance Code Item Name Qty Amount Qty Amount Qty Balance . Inventory Accounting: Using the database design developed in Exercise of Chapter-IV, for Project No: , Write the SQL statements for each of the following queries : (a) List out the Invoice No, Date and amount of sales made during the month of October, .
(b) Make a list of Invoice No, Date and amount of Purchases during the period April , to October , . (c) List items wise the quantity sold during the month of September (d) Find the Minimum and Maximum rate at which each item of goods has been purchased during the period April , . (e) Make a list of physical quantity