Concept explainers
In some cases, users want to use Access and Excel together. They process relational data with Access, import some of the data into Excel, and use Excel’s tools for creating professional-looking charts and graphs. You will do exactly that in this exercise.
FIGURE AE-3 Data Displayed in Pie-Chart Format
Source: Microsoft Corporation
Download the Access file Ch05Ex01_U10e.accdb. Open the
For this problem, we will define InventoryCost as the product of Industry-Standard-Cost and QuantityOnHand. The query InventoryCost computes these values for every item in inventory for every vendor. Open that query and view the data to be certain you understand this computation. Open the other queries as well so that you understand the data they produce.
- a. Sum this data by vendor and display it in a pie chart like that shown in Figure AE-3 (your totals will be different from those shown). Proceed as follows:
- (1) Open Excel and create a new spreadsheet.
- (2) Click DATA on the ribbon and select From Access in the Get External Data ribbon category.
- (3) Navigate to the location in which you have stored the Access file Ch05Ex01_U10e.accdb.
- (4) Select the query that contains the data you need for this pie chart.
- (5) Import the data into a worksheet.
- (6) Format the appropriate data as currency.
- (7) Select the range that contains the data, press the Function key, and proceed from there to create the pie chart. Name the data and pie chart worksheets appropriately.
h. Follow a similar procedure to create the bar chart shown in Figure AE-4. Again, your data will be different. Place the data and the chart in separate worksheets and name them appropriately.
FIGURE AE-4 Data Displayed in Bar-Chart Format
Source: Microsoft Corporation
Want to see the full answer?
Check out a sample textbook solutionChapter AE Solutions
Using MIS (10th Edition)
Additional Engineering Textbook Solutions
Starting Out With Visual C# (5th Edition)
Software Engineering (10th Edition)
Starting Out With Visual Basic (7th Edition)
Starting Out with C++: Early Objects
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
- An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.arrow_forwardCreate the table that results from applying an INTERSECT relational operator to the tables shown in Figure Q3.13. FIGURE Q3.13 THE CH03_VENDINGCO DATABASE TABLESarrow_forwardHow is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?arrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning