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
Reference Book:
Lab Manual of our Department
Text Book:
Lab Manual of our Department