Large Data Sets
To complete this assignment you must submit an electronic copy to BlackBoard by the due date. Download the starter files. To download the files from Google Drive, click the download button -- do not open the files in Google. Please follow the naming convention for naming your CS1100.LastName.E11 and your ACCESS file CS1100.LastName.A11where LastNameis your last name.
Knowledge Needed
This lab requires the following Excel and Access techniques:
- Load data into Access
- Connect Access to Excel
- Create Pivot Table in Excel from Access data
Analytical Research has obtained data for Amazon affiliate sales and wants to analyze the data. However, the data is too unwieldy for Excel and the queries are too cumbersome to express in Excel. So, a decision has been made to store the data in Access but to do the analysis in Excel. Here are your tasks:
- Download the Excel file "Amazon Referrals" from Blackboard
- Start Microsoft Access and create a "Blank desktop database". Name the database "AmazonDB". Press the "Create" button to create the database.
- Select the "External Data" tab and import the downloaded Excel workbook "Amazon Referrals".
- Create a "Link to the data source…" so that the database will be automatically updated whenever the Excel data changes.
- Use the table name "Data" (the default name) for the link table that is created.
- Double-click on the table "Data" to ensure that the data has been loaded.
- Use the names listed in the figure below and rename for ACCESS field names for your table “Data”.
- Create a query that finds all sales where the Seller was "Third Party". To do that go to the "Create" tab and select "Query Design", Here's what the query looks like in the Query Builder.
Attachment:- Amazon Referrals (2).xlsx
Attachment:- Lab 11.docx