Instructions_RM_Access2019_9_1a

Number Arrangements Database APPLICATION 9-2: SORT DATABASE RECORDS (OBJ. 5) GETTING STARTED  Open the file RecordsMgmt10e_Ch09_P1a_ FirstLastName _1.accdb , available for download from the SAM website.  Save the file as RecordsMgmt10e_Ch09_P1a_ FirstLastName _2.accdb by changing the “1” to a “2”.  If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.  Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.  In this project, you will practice using database queries to sort numbers by terminal-digit, middle-digit, and consecutive numbering.  The numbers to be sorted have been entered into the Number Arrangements table so that they can be sorted for terminal-digit, middle-digit, and consecutive numbering. The first group of two digits is in the Group_1 field; the second group of two digits is in the Group_2 field; and the third group of two digits is in the Group_3 field. PROJECT STEPS 1. Using the Query Wizard, create a new query based on the Number Arrangements table to sort the numbers in terminal-digit filing order : a. Choose the fields Group_1 , Group_2 , and Group_3 . b. Sort the query in descending order by the Group_3 field, then in descending order by the Group_2 field, then in descending order by the Group_1 field. c. Save the query as Terminal-Digit Order and then close the query. 2. Create a query based on the Number Arrangements table to sort the numbers in middle- digit filing order : a. Choose the fields Group_1 , Group_2 , and Group_3 . b. Sort the query in descending order by the Group_2 field, then in descending order by the Group_1 field, then in descending order by the Group_3 field. c. Save the query as Middle-Digit Order and then close the query. 3. Create a query based on the Number Arrangements table to sort the numbers in consecutive filing order : a. Choose the fields Group_1 , Group_2 , and Group_3 . b. Sort the query in descending order by the Group_1 field, then in descending order by the Group_2 field, then in descending order by the Group_3 field. c. Save the query as Consecutive Order and then close the query. Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project. Records M