Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
classification classification number classification name food 2 food 3 raw material Products product number product name classification number 11 tires 2 22 cheesy 1 33 pills 1 44 gas 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). 3.

classification classification number classification name food 2 food 3 raw material Products product number product name classification number 11 tires 2 22 cheesy 1 33 pills 1 44 gas 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). 3.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
classification classification number classification name 1 food 2 food 3 raw material Products product number product name classification number 11 tires 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"..
Transcribed Image Text:classification classification number classification name 1 food 2 food 3 raw material Products product number product name classification number 11 tires 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"..
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS