HW01: MS Access Intro due Mon 23 Jan 13:00

This assignment will introduce the concepts of tables, relation...
...and help to \lq\lq put a
face'' with the concepts discussed in class.

Some Details

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.

Some Additional Information

The MS Access application organizes a database as a collection of:
where the actual data is stored.
that are used to combine data from multiple tables to produce a list. You can sort results of the list produced and can filter the list to show only certain results.
(not used in this assignment) provide a nicely-formatted presentation of a query.
(not used in this assignment) provide a user-friendly way to allow entry to data into tables.

Some other concepts that will be helpful:

Design View
When working with tables and queries for this assignment you will need to switch between the so-called “design view” and the datasheet view (tables) / run query view (queries). When you are in design view you can modify the definition of the tables and queries. The other view will allow you to put data into a table or to run a query, respectively.

Start with Tables
First create your tables by defining the name and type of each column (in design view). Once the tables are created, go ahead and enter the required data.

Relationships Page
Click on the relationship icon to visit the relationships page. On that page you can defined how tables are related. Doing this step before you create queries will simplify the query-creation process.

Queries Last
Once the tables are created, populated, and related to one another you can create the queries.

Submission Requirements

To submit this assignment upload your MS Access database file (with .accdb extension) in Canvas.