(XI) MS Access - Office Package

Lab works-4(MS access)
Practical works A. Create a table called ‘student’ having the following structure: Field Name Data Type Student_id auto number (primary key) Student_Name Text Student_address Text Student_grade number Student_gender yes/no 1. Enter any ten records. 2. Perform following queries. 2.1 Display the names of those students who are from address ‘Kathmandu’. 2.2 Display the names of those students who are female/male. 2.3 Display the names of those students who are from grade 12. 2.4 Display the names of those students who are from grade 12 and address ‘Kathmandu’. 3. Create a form having above fields to input two more records. 4. Prepare a report of query performed in question 2. B. Create a table called ‘customer’ having the following structure: Field Name Data Type customer _id auto number (primary key) customer _Name Text customer _address Text customer _account _number number customer_balance number customer _gender yes/no 1. Enter any ten records. 2. Perform following queries. 2.1 Display the names of those customer who are from address ‘Kathmandu’. 2.2 Display the names of those customer who are female/male. 2.3 Display the names of those customers whose account is >3412 2.4 Display the names of those customers whose balance is >10000. 2.5 Display the names of those customers whose name starts from letter ‘k’ and has balance >30000. 3. Create a form having above fields to input two more records. 4. Prepare a report of query performed in question 2.