Question

practical time


Prepare a table as shown in figure to maintain records of all the students in the class. Name the table as '8 '. Ex. 8 ITI Field Roll No St_name DOB Gender Blood grp Address Data Type Number Text Date/Time Text Text Long Text Create another table to maintain the records for the students who either board the bus or reach school on foot. Field Roll No St Name Means of Transport Data Type Number Text Text Enter minimum ten records. Create the following query to retrieve the records. a) Students who board the bus - show result in SQL view as well as Datasheet view. Create a form using the Design view to add records of new admission in the class. Generate report using the Report Wizard for both tables. Save the database as 'Class 8 Details' and send the screenshot/image/file to teacher.​

Answer 1

. Generate report using