HW01: MS Access Intro due Mon 22 Jan 13:00
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:- Tables
- where the actual data is stored.
- Queries
- 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.
- Reports
- (not used in this assignment) provide a nicely-formatted presentation of a query.
- Forms
- (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.