classification
classification number	classification name
1	food
2	food
3	raw material

Products
product number	product name	classification number
11	tires	2
22	cheesy	1
33	pills	1
44	gas	3

use microsoft access

1.Create a database in the name of food products

2. Check the above table with the identification of data types and key keys.

3. During design, the following points must be applied: lookup wizard.

a . The classification name must be a drop-down list entered by the lookup wizard

b . The size of the product name field must be 100. The value must be entered for the field and should not be empty (required).

4. Enter the data into the tables as shown flags.

5 .Establish the relationship between the two tables.

6. Create a query by design that contains the following fields: the product name from the products table and the category name from the classification table. So that it shows records for products whose classification name is foodstuffs and the product name ends with the letter B. The name of the query should be "Products and their classification".

7. Create a form through the wizard Form Wizard for the products table so that the fields appear product number and product name. The layout of the form must be tabular. The name of the form should be "Products Data Form"

8.Creat a normal report to query and classify products. Taking into account the following:

a. It must be ensured that all fields and their data are displayed in a clear manner.

b . The font color for the field headings should be dark green.

C .The name of the report should be "Products and Classification Report". ...