attached assignment details.

· Project: Advanced Database Management

Description

1. In order to complete this assignment you need to create a new Access database and download a template file (CS102_Access2_Proj_Template.xlsx)

2. Import data from the “winners” worksheet of the template file into a new table of the Access database using an External Data import Wizard. Note that columns in the template file contain headers. Save the table as “Winners”

3. Import data from the “locations” worksheet of the template file into a new table of the Access database using an External Data import Wizard. Note that columns in the template file contain headers. Save the table as “Locations”

4. Join two tables by Game number

5. Create query that displays a game number, a winning team and the game location.

6. Create a report that contains results of the query and save it as PDF

7. Submit CS102_Access2_Proj_YourUserName.accdb and the resulting PDF file

Requirements

. Two tables created from the provided data

. Query runs over joined tables

. The query produces the required result

. A report is generated based on the query results