Create a report where sales query is filtered for only az

Assignment Help Database Management System

Reference no: EM131092549

• 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

Reference no: EM131092549

Questions Cloud

What is globalization : What is globalization? What is the relationship between globalization and information technology?

Performance orientation dimension measure : In reference to the GLOBE cultural dimensions, what does the performance orientation dimension measure? Which countries score high and low in performance orientation?

Difference between ethics and social responsibility : What is the difference between ethics and social responsibility? What are some of the social responsibility issues that MNCs must consider?

Stronger impact than its direct intervention : Why would the Fed's indirect intervention have a stronger impact on some currencies than others? Why would the Fed's indirect intervention have a stronger impact than its direct intervention?

Create a report where sales query is filtered for only az : 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.

Influence of color on perception : Psychology is an academic and applied discipline that involves the scientific study of mental functions and behaviors,Write a 3000 words report on the Color Psychology along with below points

Inflation disorder ratio analysis comparisons : How does inflation disorder ratio analysis comparisons, both for one company over time and when different companies are compared?

A current business problem through research : Write a 2 page paper in MLA format detailing your scenario and solution.Identify a current business problem through research.

Explain your thoughts on how technology does or will impact : Please read the assigned articles and in 3 pages, explain your thoughts on how technology does or will impact you in your current or future classroom.

User Account

All Pages