how to sort datasheet and how to sort tables-what is the difference please (1 Viewer)

florida2001

New member
Local time
Today, 13:56
Joined
Apr 4, 2014
Messages
4
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
 

Cronk

Registered User.
Local time
Tomorrow, 07:56
Joined
Jul 4, 2013
Messages
2,770
Code:
Is there difference how to sort "your table" and "the datasheet".

The terms are synonomous.
 

florida2001

New member
Local time
Today, 13:56
Joined
Apr 4, 2014
Messages
4
thank you , it seems Im just overthinking :banghead:
 

Users who are viewing this thread

Top Bottom