$($Note: Ignore the problems in the textbook.$)$

After you have worked through Perry Chapters $1$ & $3,$ download the Access #$1$ Homework file from the Assignments link on the $475$ Blackboard site, do the homework problems listed below and save the objects as indicated in each problem. Rename the file YourLastName. Access$1.$acedb and submit it$.$ To submit this homework, go to the Assignments link on the course Blackboard site. Under the Access Homework $1$ assignment link, click

"View$/$Complete$",$ attach your file, under "Your Comments" write the file name $($YourLastName$.$Access$1.$accdb$)$ and upload your file.

Problem $1$: Using the tbIClient table, create a query the displays California clients assigned to broker $701.$ From left to right display only columns ClientID, ClientLastName, and BrokerID.

Make sure that the query sorts the rows by ClientID in ascending order. Save the query as gryProblem$1.$

Problem $2$: Create a query that produces a list of stock purchases for client $1002,$ sorted in descending order by Volume and, within each volume, in ascending order by Date. Have the dynaset of the query show the following fields left to right: TransID, ClientID, PurchaseDate, Purchase Volume, PricePerShare and StockName. Save the query as gryProblem$2.$

Problem $3$: Management would like to know the total value of each stock purchase made for the company's two best clients: $1002$ and $1005.$ Create a single query that shows ClientID, StockName, Purchase Volume, PricePerShare, and Purchase Total for each stock purchase for each of these two clients. PurchaseTotal should be a computed field that shows the total dollar value of the purchase, formatted Currency. Sort the dynaset Ascending on ClientID and then within ClientID, sort on stock name A$-$Z$.$ Save the query as qryProblem$3$

Problem $4$: Create an Autoform for $1$b$/$Stock and change the name of the form in the header to

"Stock Transactions Input Form". Save it at frmProblem$4.$ Create an Autoreport for tb$/$Stock$,$ changing the report name in the header to "Stock Transactions Listing". Put a label in the report header that contains your name and place it just below the time textbox,