Open the Access database named SLO Music

Open the Album table and change the field length of RecordLabel to $40$ characters. Then, change the caption to "Label."

Relate the two tables by the common field and enforce referential integrity.

Examine the data in the tables. Become familiar with the field names and data in each field.

Create and save the following queries, using the names provided $($Q$1,$ Q$2,$ etc$)$

Q$1$: Create a query to list all the Artist names and Platinum Album Dates for all Hip$-$Hop songs that went platinum

after $\frac{1}{1}\frac{?}{2015}.$ Why? This will be used to send out congratulations for their achievement.

Q$2$: Create a query to list the Genre, Artist, and Digital Downloads for all sales on Pop albums with Digital Downloads.

Why? We need to create a special database for our digital downloads.

Q$3$: Create a query to show all the Albums that are Rock or Film Score. Display the Revenue Id and the Artist name but

not the genre field. Why? We need to give them more marketing due to their low sales.

Q$4$: Create a query to sum up all the Projected Sales grouped by SalesID. Show the list in order by Projected Sales, high

to low. Instead of displaying the label "Projected Sales" in the result, display "Future Sales". Why? We want to see who

makes the most sales so we can send them an opportunity to donate to our company. Make sure no fields or data is

chopped off.

Create a report that shows every Label, Platinum Album Date, Genre, and Artist. Group by Genre and sort on Artist, so

they sort in alphabetical order. Use a block layout in portrait mode. The report will be named Artist by Genre. Make sure

no fields or data is chopped off.