Results 1 to 2 of 2
  1. #1
    florida2001 is offline Novice
    Windows XP Access 2013
    Join Date
    Apr 2014
    Posts
    4

    how to sort datasheet and how to sort tables-what is the difference please

    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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    No difference.

    So 9, 10, 11 are filtering and sorting on the table directly. What did you do? Did you right click in specified fields and make choices to accomplish the actions as instructed?

    Yes, just right click and close or click the X close. Respond No when asked if you want to save changes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Split form Datasheet Sort from A to Z
    By data808 in forum Forms
    Replies: 3
    Last Post: 03-30-2014, 12:43 AM
  2. sort filter, doesn't sort everything
    By deso in forum Queries
    Replies: 4
    Last Post: 01-25-2013, 05:27 AM
  3. Forms - ComboBox - Sort/Edit Tables
    By farner in forum Forms
    Replies: 3
    Last Post: 01-05-2013, 09:05 PM
  4. Access DataSheet View Sort Error
    By jim.hoffman in forum Access
    Replies: 10
    Last Post: 04-16-2012, 09:40 AM
  5. How to sort by three sort orders
    By captgnvr in forum Access
    Replies: 4
    Last Post: 11-09-2009, 07:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums