1. Create the following tables:

2. Input records on:

a. tblYearLevel

i. only 1, 2, 3, 4

b. tblSections

i. for YearLevel 1, input the following sections (1A, 1B, 1C, 1D)

ii. for YearLevel 2, input the following sections (2A, 2B, 2C, 2D)

iii. for YearLevel 3, input the following sections (3A,3B, 3C, 3D)

iv. for YearLevel 4, input the following sections (4A, 4B,4C, 4D)

c. tblStudents

i. input 10 records (your YearLevel and SectionName field must be in look up format using the tables above respectively)

3. Create the following queries:

a. Query1 – for all students in ascending record by their last name

b. Query2 – for all students in descending record by their StudentID

c. Query3 – for all female students

d. Query4 – for all male students

e. Query5 – for all female students in second year level

f. Query6 – for all male students in first and third year level

g. Query7 – for all students whose last name starts with letter S

h. Query8 – for all students in sections 1A and 4A

i. Query9 – for all students in sections 2B and 3C

j. Query10 – for all students in sections 4D and 1C

4. Send your exam to: pabilingyelongmalamig@gmail.com

Subject: MIDTERM EXAM COMED2 FULLNAME