• Create a new database in Access
• Import the four files located above
• Create 'Relationships with all four tables by their similar fields. See the image below for the correct relationships
• Create a query that selects for the files that have 'Never' been accessed and that are in the 'Spanish' language. The table should contain the following fields: last, first, the file name, and the file status of 'Never'.
• Sort the query by last name ascending
• Export the results to a HTML file named hw8.html
• Open a PowerPoint presentation name it 'Homework 8'
• On slide one make it a title only slide & paste the report on slide one
• Title the slide as "Homework 8 Report 1"
Switching programs for ease of operation
• Create a query with the 'Last', 'First', 'Sales', 'Countries' in that order
• Take this query and copy it to Excel
• Find the subtotals based on 'Countries'
• READ THE LAB MANUAL FOR COPYING AND PASTING THE SUBTOTALS
• Import the data back into Access
• Create a report & make it look nice and fit on one page.
• Remove the 'Average' after each country name as part of making the report look nice (see Lab Manual on how to do this)
• Export the report in the 'Word/RTF' format
• Add the report to the PowerPoint presentation on slide 2
Adding data to tables using forms
• Create a query named 'Sales Query' with the following fields: from the 'Employee' table get the 'ID1', 'Last', 'First', 'State'. From the 'Sales' table get 'Sales'
• Go to the end of the form. Leave the first field alone. The '(New)' in the 'ID' box will automatically fill in the correct value when you start to enter data into the next field
• Enter 8 records where the state is 'AZ'. Make up the names and sales figures. Sales must be a value
• Create a report where 'Sales Query' is filtered for only AZ
• Make the report look nice
• Save the report as a HTML file
• Add the report to the PowerPoint presentation on slide 3