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.