To create a database in Microsoft Access to analyze video game sales, specifically focusing on "Zelda: Breath of the Wild," follow these steps laid out in your project outline. I'll outline specifics you can use for Zelda and suggest complete steps for each part.
Part 1: Setup the Initial Database
-
Open Access and Create a Blank Database
- Start Microsoft Access.
- Choose "Blank Database" and name your database (e.g.,
VideoGameSales.accdb
).
-
Add Four Tables
- You can create the tables from the "Create" tab by selecting "Table Design."
-
Table 1: Name of Game Company
- Name:
GameCompany
- Fields:
gameID
: AutoNumber (Primary Key)GameName
: Short Text (Description: "Name of the game")Genre
: Short Text (Description: "Game genre (e.g., Action, Adventure)")Developer
: Short Text (Description: "Game developer")Sales
: Number (Description: "Total sales in millions")AvgRating
: Short Text (Description: "Average game rating")
- Set
gameID
as the Primary Key.
- Name:
-
Table 2: Reviews
- Name:
Reviews
- Fields:
reviewID
: AutoNumber (Primary Key)gameID
: Short Text (this will be used to link with the Game Table)ReviewName
: Short Text (Description: "Name of the reviewer")Comments
: Long Text (Description: "Review comments")
- Set
reviewID
as the Primary Key.
- Name:
-
Table 3: Sources
- Name:
Sources
- Fields:
ID
: AutoNumber (Primary Key)WebsiteName
: Short Text (Description: "Name of the source website")WebsiteURL
: Hyperlink (Description: "URL of the source")
- Set
ID
as the Primary Key.
- Name:
-
Table 4: Recommendation
- Name:
Recommendation
- Field:
Recommendation
: Long Text (Description: "Details of the recommendation")
- Name:
Part 2: Research and Add Data to the Game, Recommendation, and Source Tables
- Research and Populate Game Table: Focus on "Zelda: Breath of the Wild" and related games by Nintendo. An example of data could be:
| GameName | Genre | Developer | Sales (Millions) | AvgRating | |--------------------------------|--------------|--------------------|------------------|-----------| | Breath of the Wild | Action-Adventure | Nintendo | 25 | 10 | | Ocarina of Time | Action-Adventure | Nintendo | 7 | 9.9 | | Twilight Princess | Action-Adventure | Nintendo | 8 | 9.7 | | Skyward Sword | Action-Adventure | Nintendo | 4 | 10 | | Wind Waker | Action-Adventure | Nintendo | 6 | 9.5 |
- Assign an appropriate
gameID
for each entry.
-
Add Sources: For example, you might add: | WebsiteName | WebsiteURL | |-------------------------|-------------------------------| | IGN | https://www.ign.com | | Metacritic | https://www.metacritic.com | | Polygon | https://www.polygon.com |
-
Populate Reviews Table: You could include reviewer names and comments. | gameID | ReviewName | Comments | |--------|--------------------|----------------------------------------------| | 1 | John Doe | "An amazing game that redefined the genre." | | 1 | Jane Smith | "A visual masterpiece with an engaging story."| | 1 | GameSpot Reviewer | "Fantastic open-world experience." |
Part 3: Relate the Game and Review Tables
- Create Relationship:
- Go to "Database Tools" -> "Relationships."
- Drag
gameID
from theGameCompany
table togameID
in theReviews
table to create a one-to-many relationship.
Part 4: Create 3 Queries
-
Cross Table Query: Combine data from
GameCompany
andReviews
. For example:- Create a select query that pulls
GameName
,AvgRating
, andComments
.
- Create a select query that pulls
-
Most Sales Query: Create a query to see sales:
- In the design tab, select fields and set sort order for Sales in "Descending."
-
Restricted Query: Create a query with specific restrictions, such as showing only games with sales over a certain amount.
Part 5: Create a Form and Type Your Recommendation
- Create Recommendation Form: Select the
Recommendation
table and then create a form. - Open the Form: Type your data-supported recommendation. Example:
- “Based on the high sales and exceptional reviews for 'Zelda: Breath of the Wild,' I recommend exploring sequels within the action-adventure genre. Given the success of open-world environments, another title featuring exploration and puzzle-solving elements like its predecessor could capture the audience well."
Part 6: Create and Format a Report
- Using the Report Wizard: Choose fields from the
GameCompany
andReviews
tables to create a report. - Custom Formatting: Adjust styles and layouts (colors, fonts) to make it engaging.
Save Your Work
After completing all parts of the project, save your Access database file to ensure all your data and structures are preserved.
This guideline should provide you with a comprehensive approach to structure your Access database, use relevant video game data, and analyze it to make a recommendation.