Create a simple select query to sort out products by food category.

Click Create – Query Design - choose products table, close the dialog window.

In the 1st cell of 1st column select field Category, Show option will NOT be selected /so the product category will not be visible on the list of selected products/, and in the criteria field type “food”.

In the next column choose field ProductName, sort Ascending (to have it in alphabetical order A-Z), checkmark show

In the 3rd column choose description - show, and then, price -show

Preview query in Datasheet View or click Run icon to see how it works. Then choose view – SQL view to see the structured query language that selects the data from the database table.

Close the query.

Create another simple select query to sort out products by CLOTHES category. Save the query as clothes.

Create a simple sort query to display a list of customers /full record/ sorted by last name in alphabetical order Z-A.

In the 1st cell choose lastname, sort , show

In the other fields choose all items listed in the table. Save query as lastnames.

Click Report Wizard icon in the Create section, from Tables/Queries menu select query Food, move all available fields to selected fields, click Next, Next, Next, Next, select

  style, Next, Finish.

Format properties of individual report items. (colors, fonts, …) Preview the report.

Save query and name it by the product category you will sort out (e.g. food).