Day 18: MICROSOFT ACCESS – CHAPTER 3 CONTD. Akhila Kondai firstname.lastname@example.org October 21, 2013. Exercise. Go to the lecture notes page and Download Music_extended.accdb
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
October 21, 2013
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: