Question

2. The school has organized an educational trip for its students. The monitor has been given the task of creating a
table to store the information. The fields are
ID, BusNo, No_Of_Students, Destination (Nainital, Dehradun, Kurukshetra, Chandigarh), Bus_Incharge
Perform the following tasks on the table:
a. Decide suitable data types for the fields and enter 10 records.
b. Display all the records in ascending order of No_Of_Students.
c. Remove the sorting applied in part b.
d. Display all the records in descending order of No_Of_Students.
​

Answer 1

photo synthesis means plant prepare it's own food is called photo synthesis

Answer 2

Answer:

Create a table in MS Access with the following information

Field Name

Data Type

ID No

Autonumber

Bus No

Text

No of students

Number

Destination

Look up Wizard

(Data values Nainital, Dehradun, Kurukshetra, Chandigarh)

5

Text

Bus incharge

a) Enter 5 records

b) Create a report

Explanation: