Question

pls help me guys fast...

eneral Instructions:

Read the question and instructions properly.

After applying each criteria, upload Access file and then click on Turn in button.

1. Create a database named School Info and perform the following tasks.

1. Create a table named student_info using the following structure:

Fited name Data type

Class

Section

Roll no

Status

Name

Photos

DOB

Remarks

Description

1

2

3.

4.

5.

6.

7.

8.

SCHOOB HO HA Senior or

2. Give the related data type and description for all 8 field names.

3. Fill at least 4 records

4. Prepare a query to display all records according to the alphabetical order of their names



5. Prepare a query named senior to display name, class, sec, roll no, status of those records which

have the value senior stored in the field status.
​

Answer 1

4.

5.

6.

7.

8.

SCHOOB HO HA Senior or

2. Give the related data type and description for all 8 field names.

3. Fill at least 4 records

4. Prepare a query to display all records according to the alphabetical order of their names

5. Prepare a query named senior to display name, class, sec, roll no, status of those records which

have the value senior stored in the field status.