I need to build a query in Microsoft Access with the following tables below but can’t seem to figure it out. How

do I sort the information about the applicants with married first, then PhD and early applications? Tried the regular ascending order but that is not working. Make sure you include some samples into your query to ensure it’s working correctly. 

The Apartment complex would like to prioritizes married couples (versus unmarried), PhD students (versus MS students), and early applications. List the identification number, name, address, and telephone number of the applicants who need an apartment next semester. Sort the information about the applicants based on their priority level.

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"