Correcting and updating an access file.

databaseaccess2.accdb

Home >Computer Science homework help >Correcting and updating an access file.

Customer_ID	Last_Name	First_Name	Street_Address	City	State	Zip	Phone
1	Smith	Joe	303	New York	Queens	9987	55556234
2	Ken	Martin	6633	Texas	Dallas	7765	99877655
3	Mary	Jones	88765	Atlanta	Georgia	2234	9908776
4	Amanda	Liz	1123	Kennewick	Florida	8874	88997765
5	Kim	Tom	44775	Alabama	Anniston	8876	99008765
6	Jolly	Joe	7765	Alaska	Haines	7765	6675432
7	Steve	John	8876	Kennewick	Ajo	8876	667543
8	Terry	Anne	77654	Arkansas	Benton	77654	777654432
9	Joan	Jowi	7786	Kennewick	Corona	2234	87765
10	Jim	Kelly	8876	Colorado	Aurora	2234	4488654

Order_Number	Customer_ID	Date
1	2	10/11/18
2	3	10/12/18
3	4	10/1/18

Product_ID	Product_Name	Category	Quantity_In Stock	Supplier_Price	Supplier_ID
1	Pizza	Food	5	¤ 5.00	9987
2	Donuts	Food	10	¤ 10.00	99087
3	Camel	Live animal	20	¤ 15.00	8897
4	Jewellery	miscellaneous	50	¤ 500.00	2234
5	Phone	miscellaneous	10	¤ 600.00	8876
6	horse	Live animal	20	¤ 400.00	3324
7	Pet	Live animal	3	¤ 300.00	3324
8	Ice cream	Food	15	¤ 100.00	9980
9	Mule	Live animal	20	¤ 200.00	3345
10	Sun glasses	miscellaneous	30	¤ 150.00	8976

Order_Number	Product_ID	Quantity	Unit_Price
2	1	3	¤ 4.00
3	4	5	¤ 5.00
4	5	2	¤ 10.00

Supplier_ID	Supplier_Name	Street_Address	City	State	Zip	Phone
1	Kane	3345	New York	Queens	3343	889765
2	Kelly	2234	Texas	Dallas	22345	90087654
3	Maggy	38875	Utah	Arizona	26654	9887623
4	Jane	34456	Atlanta	Chicago	77654	89776523
5	Martin	3777	Illinois	Chicago	88765	8997654

PARAMETERS __Order_Number Value; SELECT DISTINCTROW * FROM Purchase AS [Order Form] WHERE ([__Order_Number] = Order_Number);

SELECT DISTINCTROW * FROM Customer;

SELECT [Customer].[Customer_ID], [Customer].[Last_Name], [Customer].[First_Name], [Customer].[Street_Address], [Customer].[City] FROM Customer;

SELECT DISTINCTROW * FROM Order;

SELECT DISTINCTROW * FROM Product;

SELECT DISTINCTROW * FROM Purchase;

SELECT DISTINCTROW * FROM Supplier;

SELECT DISTINCTROW * FROM Customer;

SELECT DISTINCTROW * FROM Product;

SELECT Customer.Customer_ID, Customer.Last_Name, Customer.First_Name, Customer.Street_Address, Customer.City FROM Customer WHERE (((Customer.City)="Kennewick")) ORDER BY Customer.Last_Name;

SELECT Product.Product_ID, Product.Product_Name, Product.Category, Product.[Quantity_In Stock], Product.Supplier_Price, Product.Supplier_ID FROM Product WHERE (((Product.Category)="Live animal"));