Use MS Access to create a database that has the structure and contents of
the example given in the class notes. In addition to creating and
populating the tables, create two saved/named queries as follows:
- All Albums
- A list of all albums in the database showing the
artist's name, the album title, the year of the album, and the genre
name associated with the album. The list should be ordered by artist
name first and then in descending order of album year.
- Albums 2005
- The same information as All Albums except show
only albums produced in 2005.
To submit this assignment do both of the following:
- Upload your MS Access database file in Canvas.
- Bring a printout of the All Albums query to class.