Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the answer as soon as possible classification classification number classification name 1 food 2 food 3 raw material Products product number product name

I need the answer as soon as possible image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions