Windows 7 how to sort datasheet and how to sort table in access

[florida2001]

Hi I have this assignment for school, I think I did everything except the step number 9 and 11, it seems I do something wrong or not sure about that. How to SORT THE DATASHEET in descending order and how to Sort YOUR TABLE in ascending order? Is there difference how to sort "your table" and "the datasheet".
Also in step 10) they are asking to close the datasheet view without saving changes, does it means I just right click on the table and "close it"? Sorry for my explanation, but it is difficult for me to explain this things and ask right questions. I attached the steps I have to do, I believe I did everything except the step 9) and 11)
I have Access 2013)
1. Create a Database named YOUR NAME_DRIVERS
2. Create a Table in DESIGN VIEW
3. Define the following fields as follows:
FIELD NAME DATA TYPE DESCRIPTION
DRIVER ID AUTONUMBER IDENTIFICATION NUMBER
FIRST NAME TEXT DRIVER'S FIRST NAME
LAST NAME TEXT DRIVER'S LAST NAME
AGE NUMBER DRIVER'S AGE (No decimals)
COUNTRY TEXT DRIVER'S COUNTRY OF ORIGIN
(USE TAB OR ENTER KEY TO MOVE FROM ONE AREA TO THE NEXT ONE)

4. Create a Primary Key on the field DRIVERID

5. SAVE YOUR TABLE AS: LOCATION

CLICK ON DATASHEET VIEW TO SEE TABLE

6. ENTER THE FOLLOWING DATA:

(DO NOT TYPE DRIVER ID-AUTONUMBER WILL DO IT)
DRIVER ID FIRST NAME LAST NAME AGE COUNTRY
1 MARIE GRAHAM 32 GERMANY
2 LOUIS BENNETT 23 UNITED STATES
3 ARMAND ORTEGA 26 VENEZUELA
4 CARL GILMORE 33 UNITED STATES
5 JOSH GONZALEZ 45 BRAZIL
6 SILVYA KELLY 30 UNITED STATES
7 TRENT YOUNG 42 AUSTRALIA
8 LAWRENCE LAKIND 36 UNITED STATES
9 JEAN LAMARQUE 32 FRANCE
***FIX COLUMNS WIDTH DOUBLE CLICKING BETWEEN COLUMNS HEADINGS (also at the end)
7. Sort your table in ASCENDING ORDER by FIRST NAME

8. Add the following record:

TYPE: YOUR First and Last NAME, Age: 27, Country: UNITED STATES

Click SAVE

9. Sort the datasheet in descending order by LAST NAME. Write down the Last Name entry for the first record that is listed.

10. Create a filter to show all Drivers from UNITED STATES. Write down how many records were in the resulting datasheet, and then remove the filter.

11. Use the Find command to find all records with AGE 32. Write down how many records you found.

Write the information from steps 9, 10 and 11 in a word document and save it as:
“Sort*_Filter_Find*_Your*_name_answers”

12. Close the Datasheet View for the Location table without saving changes.

13. CREATE A QUERY: Use the QUERY-DESIGN VIEW

Create a Query with all records that meet the following criterias: Age above 25 and Country of Origin: United States. Show all fields and sort in ascending order by Age.

Hint: Add Table and Select the all fields. (Double-click on each field)

Below the AGE field: select ASCENDING in the Sort cell and in the CRITERIA cell TYPE “>25” (above 25). For COUNTRY OF ORIGIN in the CRITERIA cell type: UNITED STATES

14.- SAVE QUERY AS: AGE & COUNTRY

CLICK ON DATASHEET VIEW TO SEE QUERY or Run QUERY
AUTOFIT COLUMNS (SEE ***)
SAVE and EXIT Access
Submit the following files:
The Word 2010 document: Sort_Filter_Find_Your_Name_answers and

 

[ChatGPT]

To address your questions regarding steps 9, 10, and 11 of your assignment on Access 2013, I'll provide guidance on sorting the datasheet, sorting your table, and closing the datasheet without saving changes.

Step 9: Sort the Datasheet in Descending Order​

• Sorting the Datasheet: To sort the datasheet by last name in descending order, you need to:
  • Click on the drop-down arrow next to "LAST NAME" at the top of the LAST NAME column.
  • Choose "Sort Descending."

    Step 10: Create a Filter for Drivers from the United States​

  []Filtering out Data: To filter the datasheet to show only drivers from the United States:
  • Click on the drop-down arrow next to "COUNTRY" at the top of the COUNTRY column.
  • Select "Filter by Selection."
  • Choose "United States" from the list.
    • Recording Information: Take note of the number of records displayed after applying the filter.
    • Removing the Filter: To remove the filter, click on the dropdown again and select "Clear Filter from COUNTRY."

    Step 11: Use the Find Command to Locate Records with Age 32​

  []Using the Find Command:
  • Click on the "Find" feature (usually represented by a pair of binoculars or a magnifying glass).
  • Type "32" in the search bar and initiate the search.
  []Recording Results: Note down the number of records found with the age of 32.

  Data Sorting Differences​

  []Sorting Your Table vs. The Datasheet:
  • Sorting "Your Table" and the datasheet essentially involve the same process for sorting data in Access, typically by clicking on the column header and selecting the sorting order.

    Closing the Datasheet Without Saving Changes​

• Closing Datasheet Without Saving: To close the datasheet view without saving changes, you can simply close the datasheet window without explicitly saving. Access usually prompts you to save changes upon closing; choose "Don't Save" when prompted. By following these steps, you should be able to complete the sorting, filtering, and finding tasks in your assignment. If you have any further questions or encounter difficulties with these steps, feel free to ask for more help!