Day 18: MICROSOFT ACCESS – CHAPTER 3 CONTD. Akhila Kondai [email protected] October 21, 2013. Exercise. Go to the lecture notes page and Download Music_extended.accdb
We want to see all members whose last names begin with “E”…
Note: This technique is similar to what part of a query asks for in HW4 !
Note: If you see <<expr>> be sure to remove it ! ! !
YOU MUST RUN THE QUERY ONCE FIRST !
We are running an investment firm and have some consultants working for us who have clients for which they manage investments.
We want a query that will show us how many clients each consultant has and the total amount of investments each consultant is handling…
This Database has not yet had a relationship created. We will do it in the query for this one. Sometimes under special circumstances you will create them here instead of in the relationships window. Generally it is done in the relationships window though…
# of Clients: LastName
We want to display our: