MS-ACCESS 2013Lesson 4

Query Design - Date, Number, yes/No, And, OR

11/11/2017 Dr.Girija Narasimhan 1

By Dr. Girija Narasimhan

This slides are available http://slideshare.net /nbgirija

11/11/2017 Dr.Girija Narasimhan 2

11/11/2017 Dr.Girija Narasimhan 3

Query Design

• Yes/ No

• And

• OR

• Between two dates

11/11/2017 Dr.Girija Narasimhan 4

Create a new query Q1 which will select Passid, Email, Flight_No of Passenger table whose Registered is “Yes”.

11/11/2017 Dr.Girija Narasimhan 5

Create a new query Q2 which will select Passid, Email, Flight_No of Passenger table whose Registered is “No”.

11/11/2017 Dr.Girija Narasimhan 6

Create a new query Q3 which will select the Passid, Tdate, Flight_no, Source from FLIGHT & PASSENGERtables, whose Tdate is before 10/31/2016 AND Source is Dubai

11/11/2017 Dr.Girija Narasimhan 7

Create a new query Q4 which will select the Passid, Tdate, Flight_no from PASSENGER table, whose Tdate is between 10/1/2016 and 11/30/2016

11/11/2017 Dr.Girija Narasimhan 8

Create a new query Q5 which will select the Passid, Age of Passenger table whose Age between 40 to 58

11/11/2017 Dr.Girija Narasimhan 9

Create a new query Q6 which will select the Passid, Age, Flight_no of Passenger table whose Age is greater than50 OR whose Flight_no is WY101.