419
Page views
5
Files
0
Videos
0
R.Links

Icon
Syllabus

UNIT
1
Payroll using MS - Access

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.

UNIT
2
Label using MS Access

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.

UNIT
3
Invoice using MS Access

3. Gather price, quantity and other descriptions for five products and enter in the Access table and create an invoice in form design view.

UNIT
4
ASSETS for forms using MS Access

4. Create forms for the simple table ASSETS.

UNIT
5
report for the PRODUCT using MS Access

5. Create report for the PRODUCT database

Reference Book:

Lab Manual of our Department

Text Book:

Lab Manual of our Department

 

Print    Download