how to sort datasheet and how to sort table in access

Discussion in 'Windows 7 Help and Support' started by florida2001, Apr 6, 2014.

  1. florida2001

    florida2001 New Member

    Joined:
    Jan 26, 2014
    Messages:
    10
    Likes Received:
    0
    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
     

Share This Page

Loading...