contestada

You created a database related to medicinal plants and their uses. For a particular query, you’d like to view the names of the plants in alphabetical order. Which database operation can you use to view the desired output?

Respuesta :

alibaber
1. If in MS Access, Click on Query design, select the required Table.
 In Field select required field, in this case Select [Name of Plants]. Click on Order and set it as Ascending / Descending.

2. If you want to write a Query that it will look like this

SELECT MedicinalPlants.Name of the plantsFROM MedicinalPlantsORDER BY MedicinalPlants.Name of the Plants;

Answer:

"The sorting operation-"

Explanation:

Sorting a database means arranging the records in a specific way to make reported data more usable. For example, an alphabetical sort by the last name field will arrange text data in ascending alphabetical (A-Z) order.

I hope this helps! It took me awhile to get it lol.