Introduction

In this assignment, you will use SQL to join data together and explore how to retrieve only the data columns and rows that you desire by adding criteria to newly built queries.

Activity Instructions

Read the following resource for this activity:

Submit an Access database that has at least four (4) tables with data existing in each table. Create four (4) queries that are written against each table and only selecting some of the columns on each table. Create two (2) queries that join data from at least two (2) tables and have criteria that limit the result set of the query.

Submission Requirements

Submit Access database file.