Preview

Accounting

Satisfactory Essays
Open Document
Open Document
288 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Accounting
Week 2 – MS Access Lab Requirements:
Problem 4.4 Retrieve the S&S In-Chapter Database (in Microsoft Access format) from Doc Sharing or the text’s Web site (or create the tables in <link linkend="ch04table05" preference="0">Table 4-5<xref linkend="ch04table05" label="4-5"/></link> in a relational DBMS product). Write queries to answer the following questions. <emphasis>Note</emphasis>: For some questions, you may have to create two queries—one to calculate an invoice total and the second to answer the question asked. 1. You must include a screen shot of the query (or queries) created and a screen shot of the results for each question. 2. Be sure you include the question and label your queries as 4-4.x (where x=question letter). 3. Paste all screen shots into a Word document and save the word document as WK2_Lab_LastName_FI.docx. 4. Place your completed lab in the dropbox.

Grading for this assignment will be as follows: Answer the following questions based on query results 25 Points Total | Query | Results | a. How many different kinds of inventory items does S&S sell? | 1 | 2 | b. How many sales were made during October? | 1 | 2 | c. What were total sales in October? | 1 | 2 | d. What was the average amount of a sales transaction? * Table Query = 1 * Table Results = 1.5 * Query = 1 * Query Results = 1.5 | 2 | 3 | e. Which salesperson made the largest sale? * Table Query = 1 * Table Results = 1.5 * Query = 1 * Query Results = 1.5 | 2 | 3 | f. How many units of each product were sold? | 1 | 2 | g. Which product was sold most frequently? | 1 | 2

You May Also Find These Documents Helpful

  • Good Essays

    accounting

    • 463 Words
    • 2 Pages

    You are partner in charge of the audit of Shangri‑La, Inc. The company is a real estate developer, specializing in luxury vacation areas. The company's operations have been profitable, although not spectacular. Most of the development property is pledged as collateral for bank loans; there is a reasonable stockholders' equity of about $10,000,000.…

    • 463 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Accounting

    • 8672 Words
    • 35 Pages

    Q3-1 The basic idea underlying the preparation of consolidated financial statements is the notion that the consolidated financial statements present the financial position and the results of operations of a parent and its subsidiaries as if the related companies actually were a single company.…

    • 8672 Words
    • 35 Pages
    Powerful Essays
  • Good Essays

    Accounting

    • 320 Words
    • 2 Pages

    1. Ida needs to test the U.S. commercial building for recoverability under both U.S. GAAP and IFRSs. Recoverability test is one of the requirement tests for impairment. As a result, we need to verify if impairment should be recognized.…

    • 320 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Accounting

    • 2910 Words
    • 12 Pages

    F, a 50 percent owner of Y, is single and has no other tax information. F's A.G.I. is…

    • 2910 Words
    • 12 Pages
    Better Essays
  • Satisfactory Essays

    Accounting

    • 501 Words
    • 3 Pages

    The conveyance of a noncash financial asset by and to someone other than the issuer of that financial asset. A transfer includes the following: selling a receivable, putting a receivable into securitization trust, and posting a receivable as collateral. A transfer excludes the following: the origination of the receivable, settlement of a receivable, and the restructuring of a receivable into a security in a troubled debt restructuring.…

    • 501 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Accounting

    • 1181 Words
    • 5 Pages

    What is the future value of $7,540 at the end of 7 periods at 8% compounded interest?…

    • 1181 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Julius Caesar Act I Q A

    • 1360 Words
    • 5 Pages

    corroborate the answers to the questions. Be sure to use the exact language in the line format presented.…

    • 1360 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Microsoft Basics Exam

    • 944 Words
    • 5 Pages

    When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you…

    • 944 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Nt1330 Unit 7 Lab 1

    • 566 Words
    • 3 Pages

    8: If you had any extra entries from step 4 the open the text document on the desktop and select…

    • 566 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Accounting

    • 852 Words
    • 3 Pages

    d) Does the report contain management’s discussion and analysis (MD&A)? If so, what are the key issues addressed?…

    • 852 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    Accounting

    • 551 Words
    • 8 Pages

    Directions: Answer the following four questions on a separate document. Explain how you reached the…

    • 551 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Accounting

    • 6356 Words
    • 26 Pages

    Xilinx, Inc. designs, develops, and markets complete programmable logic solutions, including advanced integrated circuits, software design tools, predefined system functions delivered as intellectual property cores, customer training, field engineering and technical support. Customers are electronic equipment manufacturers primarily in the telecommunications, networking, computing, industrial, and consumer markets. Products are sold globally through a direct sales management organization and through franchised domestic and foreign distributors. (Source: Company 2007 Form 10-K)…

    • 6356 Words
    • 26 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Accounting

    • 888 Words
    • 4 Pages

    | | |Personality is , for the most part, comprised of traits that cannot be measured or defined. |…

    • 888 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Accounting

    • 748 Words
    • 3 Pages

    2. Costs that rise and fall proportionately with the volume of output are often referred to…

    • 748 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Accounting

    • 418 Words
    • 2 Pages

    I watched How It’s Made and chose to tell you about artificial limbs. Job order costing is appropriate to use since artificial limbs are specially made for certain people of all different shapes, sizes and colors so each limb is unique. This company would need a cost system because there are many different steps needed to create the limb. A manager would need to decide how much each individual person who spent time making the limb would get paid. They could get paid by the hour or by how many limbs they complete in one day. A manager would also need to decide how many people it would take to complete each task. Some jobs might be quicker if two people worked together instead of one.…

    • 418 Words
    • 2 Pages
    Satisfactory Essays