Misc 211 Final Exam With Complete & Verified Answers 2023 Update.

Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN. {Ans: You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to [Enter Department Code]. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button. Inside the Enter Parameter Value dialog, you typed FIN in the Enter last name input, clicked the OK button. History}Modify the Dec 18 worksheet so gridlines will print {Ans: On the Page Layout tab, in the Sheet Options group, click the Print check box under Gridlines}Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out. {Ans: In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A