CCNC/CCNC Module 5/Retrieving data with queries/Sorting Information

---

Sorting Data

Outcomes

Upon completion of this tutorial the learner will be able to: Sort data Execute simple ascending and descending sorts Create a sort using parameters

Simple Sorting

Figure 1. Opening a Table

Figure 2. The Sort Buttons

Figure 3. Sort Ascending

Figure 4. Sort Descending

Opening the Sort Dialog

Figure 5. The Sort Button

Figure 6. The sort parameters

Test your knowledge

Searching...

1. The earth has limited natural resources? TRUE → Absolutely Correct! FALSE → Incorrect, the planet earth is made up of limited resources. Click here to review the topic. 2. How should these resources be used. (a) Sparingly → Almost correct, Yes we should use the earths resources sparingly. The best answer is (e). Click here to review the topic. (b) With thoughts of sustainability → Almost correct, Yes we should use the earths resources sparingly. The best answer is (e). Click here to review the topic. (c) For the health of the planet → Almost correct, Yes we should use the earths resources sparingly. The best answer is (e). Click here to review the topic. (d) To keep the planet diverse → Almost correct, Yes we should use the earths resources sparingly. The best answer is (e). Click here to review the topic. (e) All of the above → Absolutely correct! Your score is 0 / 0