Microsoft Access Operations 2 and 3 (2 pts each) Use INSERT INTO statements to i
ID: 3741412 • Letter: M
Question
Microsoft Access
Operations 2 and 3 (2 pts each)
Use INSERT INTO statements to insert the following information into the database: maker C produces a flash drive (model is 4001, type is `flash’) whose storage is 32 (GB) and price is 20 ($).
Table Name is Flashdrive
Product maker model type A 1001 pc A 1002 pc A 1003 pc B 1004 pc B 1005 pc B 1006 pc C 1007 pc D 1008 pc D 1009 pc D 1010 pc E 1011 pc E 1012 pc E 1013 pc E 2001 laptop E 2002 laptop E 2003 laptop A 2004 laptop A 2005 laptop A 2006 laptop B 2007 laptop F 2008 laptop F 2009 laptop G 2010 laptop E 3001 printer E 3002 printer E 3003 printer D 3004 printer D 3005 printer H 3006 printer H 3007 printerExplanation / Answer
Solution:
The SQL query is given below:
Query 2:
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)