1.Prepare a payroll for employee database of an organization with the following Details: Employee id, Employee name, Date of Birth, Department and Designation, Date of appointment, Basic pay, Dearness Allowance, House Rent Allowance and other deductions if any. Perform queries for different categories. 2. Create mailing labels for student database which should include at least three Table must have at least two fields with the following details: Roll Number, Name, Course, Year, College Name, University, Address, and Phone Number.

3. Gather price, quantity and other descriptions for five products and enter in the Access table and create an invoice in form design view. 4. Create forms for the simple table ASSETS. 5. Create report for the PRODUCT database

1. Create new company and display relevant information. 2. Create voucher and show different types of voucher. 3. Creation of Groups and ledger accounts with minimum 5 transactions

4. Creation of ledger accounts with minimum 10 transactions. 5. Prepare and Display Cash book and Bank book 6. Create ledger and pass the transactions in the necessary vouchers.

7. Prepare Trial Balance, Trading, Profit and loss account and balance sheet. 8. Create stock group. 9. Prepare an Inventory Statement Calculate inventory by using all methods) a) FIFO b) LIFO 10. Prepare inventory statement using (Calculate inventory by using all methods) a) Simple Average Method b) Weighted Average Method