attached 4 projects

1. Create an Excel spreadsheet with the following columns: Title, Platform, Genre, and Score.

2. Fill the spreadsheet with data from this table: Best-Reviewed Games (Any Platform), 2013 and save it as CS102_Project7_YourUserName.xlsx.

3. Create a new Access database and import data from Excel. Accept all default options and make sure to check that first row of the spreadsheet contains column headings.

4. Add a calculated field Can Play that becomes true (Yes) if the game platform matches your favorite platform (PS3, Wii, PC, or 360).

5. Create a simple query that displays titles of the games you can play only.

6. Create a crosstab query with Genre as row headings and column headings. Use Count function to count number of titles in the intersection of Platform/Genre.

7. Save your file as CS102_Project7_YourUserName.accdb and submit it along with CS102_Project7_YourUserName.xlsx

Requirements

. A table with 5 specified fields

. Data imported from Excel to Access

. Yes/No field properly calculated

. A query that displays titles of the games for your platform

. A crosstab query that counts number of titles of each genre on each platform