Question: Learn how to import data into Access and Excel, and how to create and use pivot tables for detailed analyses. Required a. Obtain the article

Learn how to import data into Access and Excel, and how to create and use pivot tables for detailed analyses.

Required

a. Obtain the article “Drilling for Information” by Jeff Lenning, in the Journal of Accountancy (August 2000 issue). You can find the article by accessing www .aicpa.org and following the links to Online Journal of Accountancy.

b. Download the text file for this problem from this course’s Web site.

c. Follow the instructions in the article to do the following:

• Import the text file into Access (create a table in Access that has columns: Month, Dept_num, Account_num, Account_desc, Trans_desc, and Amount).

• Import the data from Access into Excel. The data should go into PivotTable reports that you create for each department.

• Save your work, and print screen shots ofyour Pivot Table for department 100.

d. Follow the instructions in the article to automate the reports. Save your work.

Step by Step Solution

★★★★★

3.40 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Information Systems Questions!

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...

Divvy Bikes Background Information: Divvy is a bicycle sharing system in the City of Chicago and two adjacent suburbs that is operated by Motivate for the City of Chicago Department of...

Required information Lab 2 . 4 Excel: Public, Private, and For - Profit Colleges ( LO 2 - 5 ) Skip to question [ The following information applies to the questions displayed below. ] Keywords: Pivot...

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Can someone help make this java file run? The code is probable the main issue I am having //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

For each of the accompanying control charts, analyze the data using both median and up/ down run tests with z = 1.96 limits. Are nonrandom variations present? Assume the centerline is the...

Disc Ltd, a registered vendor that only makes taxable supplies, entered into the following transactions during the year of assessment ended 31 March 2020. The company brought forward an assessed...

When is rolling your lump - sum retirement benefits into an IRA a good financial decision ? a . All of them are correct b . If you have retired early If you don't need the funds immediately dyou have...

Suppose these selected condensed data are taken from recent balance sheets of LO15 Bob Evans Farms (in thousands). 2017 2016 Cash $ 13,606 $ 7,669 Accounts receivable 23,045 19,951 Inventory 31,087...

Describe how data mining and a CRM system might be used by any of the managers depicted in Figure, a horizontal perspective of the OE/S process, or in Figure, a vertical perspective of the OE/S...

Describe how Web 2.0 tools might be used by any of the managers depicted in Figure 10.1, a horizontal perspective of the OE/S process, or in Figure 10.2, a vertical perspective of the OE/S process.

BioTech expects to earn $2 million per year in perpetuity if it undertakes no new investment opportunities. There are 100,000 shares outstanding. The firm will have an opportunity at Year 1 to spend...

I would like to discuss a refund. I was under the impression I cancelled my subscription in May but having checked my credit card statement noticed I was still being charged.

Identify the different types of yield curves and explain what they indicate for the U.S economy? What is the current shape of the yield curve and why is it shaped that way? No Copy And Paste Please