$1.->$ As$-$project$-$manager, $-$you$-$need$-$to$-$be$-$able$-$to$-$query$-$the$-$database$-$to$-$help make decisions. and answer questions from other managers. Create$-$a$-$query$-$based$-$on$-$the$-$Consultant$-$ table$-$in$-$Query Design$-$View$-$with$-$the following$-$options: $1$ a$.->$ Add$-$the$-$ConsultantID, LastName, and FirstName$-$fields to the design$-$grid$-$in$-$that$-$ order$\mathrm{.}1$ b$.->$ Sort$-$the$-$records in ascending order by LastName$\mathrm{.}1$ C$.->$ Save$-$the$-$query$-$with the name LastNameSorted.$<$ Open$-$the$-$query$-$in$-$Datasheet$-$View$-$and$-$then$-$close$-$it$.11.->$ As$-$project$-$manager, you$-$need$-$to$-$be$-$able$-$to$-$query$-$the$-$database$-$to$-$help make$-$decisions: and$-$answer$-$questions$-$from$-$other$-$managers. Create$-$a$-$query$-$based$-$on$-$the$-$Consultanttable$-$in$-$Query$-$Design$-$View$-$with$-$the$-$following$-$options: f a$.->$ Add$-$the$-$ConsultantID,$-$LastName, and$-$FirstName$-$fields to the$-$design$-$grid$-$in$-$thatorder. Il b$.->$ Sort$-$therecords$-$in$-$ascending$-$order$-$by$-$LastName, c$.->$ Save$-$the$-$query$-$with$-$the$-$name$-$LastNameSorted. Open$-$the$-$query$-$in$-$Datasheet$-$view$-$and$-$then$-$close$-$it$.1$