I really need help with this Microsoft Access problem, please! Thank you!
Create a query that displays employees' first names, last names, date of birth, marital status, gender, and classifications. An employee is classified as QTA if the employee is married, female, and was born before 1960 or after 1975. Otherwise, an employee is classified as PTA. Sort the result in ascending order by qualifications, then gender, then marital status, then date of birth, then first name. Save this query as Query5.
The result of your query should look like:
Lori Linda Barbara Laura Paula Deborah Rebecca Annette Janet Jill Barbara Carole Mindy Jo Belinda Erin Terri Janeth Jean Candy Mary Sheela Susan
Penor Meisner Moreland Norman Barreto de Mat Poe Laszlo Hill Sheperdigian Williams Decker Poland Martin Brown Newman Hagens Duffy Esteves Trenary Spoon Dempsey Word Faton
8/31/1960 M 12/31/1960 M 2/4/1966 M 2/6/1966 M 3/14/1966 M 4/7/1966 M 8/11/1967 M 3/1/1968 M 4/9/1969 M 7/19/1969 M 8/2/1969 M 11/19/1973 M 12/22/1974 M 11/9/1946 S 10/19/1959 S 2/4/1961 S 9/1/1961 S 8/25/1962 S 1/13/1966 S 3/26/1966 S 3/1/1968 S 3/13/1968 S 3/20/1968 S
F F F F F F F F F F F F F F F F F F F F F F F
PTA
