Sample data for STOCK table: (MICROSOFT ACCESS)

Stock_symbol	Company_name	Exchange_name
OMC	Omnicon Group	NYSE
AAPL	Apple	NASDAQ
IBM	IBM Corp	NYSE
GOOG	Google Corp	NASDAQ
BBY	Best Buy	NYSE
LNG	Cheniere Energy, Inc.	AMEX
CSCO	CISCO	NASDAQ
DIS	Disney Corp	NYSE
NGD	New Gold	AMEX
BAC	Bank of America	NYSE
JPM	JPMorgan and Chase	NYSE
PFE	Pfizer Inc	NYSE
C	Citigroup	NYSE
GRPN	Groupon Inc.	NASDAQ
WEN	Wendys Company	NASDAQ
NOK	Nokia, Inc	NYSE
GE	General Electric Co.	NYSE
BIDU	Baidu Inc	NASDAQ
PCLN	PriceLine Inc	NASDAQ
HPQ	Hewlett-Packard Inc	NYSE

PORTFOLIO (owner_ID, Stock_symbol, number_bought, PRICE_PAID_per_share, Date_bought)

Owner_ID	Stock_symbol	Number_bought	PRICE_PAID/share	Date_bought
A112	AAPL	10	450	4/12/2018
A112	PFE	3000	25	1/5/2018
A123	C	50	4	1/18/2018
A123	AAPL	50	425	1/12/2018
A123	PCLN	150	650	1/18/2012
A123	GOOG	50	430	3/18/2012
A123	GE	1000	16	1/18/2018
A231	AAPL	200	430	1/18/2013
A231	IBM	200	85	1/10/2019
A441	NOK	3000	2	1/12/2011
A441	LNG	1000	5	1/12/2008
A441	HPQ	300	22	3/12/2011
A441	OMC	100	45	2/12/2013
A451	PCLN	300	620	1/12/2015
B111	HPQ	1000	4	2/12/2013
B111	BAC	1000	6	8/12/2012
B111	C	5000	2	2/12/2018
B111	DIS	300	31	5/12/2012
B118	PCLN	1000	650	2/12/2019

PART B:

Develop the following queries in ACCESS and run (execute) them Q 1-13

1. List the company names.
2. Give the count of stocks traded on all stock exchanges. (simple count and not number of shares)
3. Give the names of owners who bought stocks on 8/12/2012?
4. Give the count of stocks bought on each dates. For example, 4 stocks were bought on 1/18/2012
5. Give the count of stock bought between 1/1/2012 and 1/1/2015
6. Give the client number of clients that hold IBM or BAC company stocks.
7. Give the total number of outstanding stocks of stock whose symbol is BAC
8. How many different stocks client B118 holds? (give the number)
9. Give the total worth of client A441 (this is the total amount that A441 has) price* number of shares
10. Give the count of stocks traded on each exchange
11. Give the worth of each client. (worth is defined as price* number of shares).
12. Give the names of stocks whose price is more than $200
13. Whats total worth of INT.com?

Report

14. Create a Client Portfolio report of INT.com, stocks they hold and their net worth

See the template below:

Client Portfolio Report for INT.COM

Client number Stock Name Total amount

A112 AAPL $4,500 (note: this is 10*450) etc..

Total for Client A123 XXXXX.XX

A231 AAPL $86,000 (note:200*$430)

etc..

Total for Client A231 XXXXX.XX

Etc..

Overall Total Worth : xxxx