Order Now

Go16_ac_vol1_grader_cap2_as – supplier data | Computer Science homework help

Uncategorized

 GO16_AC_VOL1_GRADER_CAP2_AS – Supplier Data

  

Project Description:

In this project, you will apply skills you practiced from the Objectives in Access Chapters 1 through 3. You will create a database for Gina Gomez, Sales Manager, that contains inventory and supplier information. In addition, you will create queries that answer specific questions relating to the inventory items and suppliers, forms for entering and updating information, and reports.

     

Start   Access. Download, open, and save the database named go_acc_grader_capstone2_Supplier_Data.accdb.

 

Open   the Cap2 Inventory table in Design View. Rename the ID field to Item ID and change the Data Type to Short   Text. Continue adding the following fields as Short Text except for Cost,   which should have a Currency Data Type, and Quantity, which should have a   Number Data Type:
 

Item Name
  Department
  Cost
  Quantity
  Supplier ID

 

Switch   to Datasheet view. Enter the following two records into Cap2 Inventory:
 

  Item ID: H102
  Item Name: Hair Brush Set
  Department: Hair Care
  Cost: 9.99
  Quantity: 92
  Supplier ID: S-186
 

  Item ID: M089
  Item Name: Pedicure Kit
  Department: Hands & Feet
  Cost: 22.59
  Quantity: 71
  Supplier ID: S-133

 

Close   the table. Append a copy of the records from the downloaded aCap2_Inventory.xlsx workbook to the   Cap2 Inventory table. Accept all defaults in the wizard and do not save the   Import steps. Open the table, verify there are 24 records, and apply Best Fit   to all fields. Save and close the table.

 

Import   the source data from the downloaded aCap2_Suppliers.xlsx   workbook into a new table in the current database. In the wizard, click the   First Row Contains Column Headings option and set the primary key to Supplier   ID. Name the table Cap2 Suppliers.

 

Open   the Cap2 Suppliers table in Design view. Delete the Office Manager field and   save the table. Switch to Datasheet view and apply Best Fit to all of the   fields. Save and close the table.

 

On   the Navigation Pane, group the objects by Tables and Related Views.

 

Create   a relationship between the two tables in the database using Supplier ID as   the common field. Enforce Referential Integrity and select both Cascade   options. One supplier can supply many inventory items.

 

Create   a relationship report. Save the report with Relationships   as the name. Close the Relationships window.

 

Create   a query in Design view, using your Cap2 Inventory table to answer the   question, What is the item name (in alphabetical order), Cost, and Quantity   for the department of Hair Care?   Do not display the Department field in the query results. Run the query, save it as Cap2 Hair Care Query, then close the query. Three records   match the criteria.

 

Create   a copy of Cap2 Hair Care Query named Cap2 Hair Care or   Easy Wear Query. Redesign the query design to answer   the question, What is the department, item name, cost, and supplier ID where   the department is hair care   or easy wear? Arrange the fields in the order in   which they’re mentioned in the question. Sort the records first in ascending   order by Department and then in ascending order by Item Name. Run and then   close the query. Seven records match the criteria.

 

Create   a query in Design view, using both tables to answer the question, What is the   department, supplier name, item name, and phone, for a supplier name that   begins with the letter B   for the department of bath?   Add the fields in that order. Sort the records first in ascending order by   the Supplier Name field and then in ascending order by the Item Name field.   Run the query, save it as Cap2 Wildcard   Department Query, and then close it. Seven records   match the criteria.

 

Create   a query in Query Design view, using your Cap2 Suppliers table and your Cap2   Inventory table to answer the question, What is the supplier name, item name,   department, and cost (in that order) for items that have a cost of $25 or   greater? sorted first in ascending order by department and then in descending   order by Cost? Six records match the criteria. Save the query as Cap2 Cost $25 or More Query and close it.

 

Create   a query in Design view, using the Cap2 Inventory table to answer the   question: For Supplier ID S-186,   for each Item Name, if the Markup is calculated as 62% of Cost, then what is   the Selling Price if Cost and Markup   are added together? Add the Supplier ID, Item Name, and Cost fields (in that   order), then create the calculated fields. Name the first calculated field   Markup and name the second calculated field Selling Price.   Run the query and apply Best Fit to all of the fields. All numeric fields   should be formatted as Currency, 2 Decimal Places. Save the query as Cap2 Markup Query and close it.

 

Use   the Query Wizard to create a crosstab query using the Cap2 Inventory table.   Set the Supplier ID field as the row headings, and set the Department field   as the column headings. Sum the Quantity field, and do not include row sums.   Name the query Cap2 Crosstab Query   and then finish the query. Run the query and apply Best Fit to all of the   fields. Save and close the query.

 

Create   a query in Design view using the Cap2 Inventory table that prompts you to   enter the Department, and then answers the question, What is the department,   item name, and Cost for inventory items, sorted first in ascending order by   Department and then in ascending order by the item name? Add the fields in   that order. The query should prompt an individual to Enter the Department. Run the query, and type Face & Neck when prompted for the criteria. Five   records match the criteria. Save the query as Cap2 Parameter   Query   and close it.

 

Based   on the Cap2 Suppliers table, use the Form tool to create a form. Switch to   Form view, and then using the form, add a new record as follows:
 

  Supplier ID: S-152
  Supplier Name: Springfield Supply Co.
  Address: 146 Lincoln Drive
  City: Springfield
  State: IL
  Postal Code: 62707
  Phone: (217) 555-2543
 

  Use the Filter By Form tool to create a filter that displays records with a   State of IL   or TX. After verifying that three records   match this criteria, toggle the filter to display all 6 records. Save the   form as Cap2 Supplier Form and close it.

 

Based   on your Cap2 Suppliers table, use the Report tool to create a new report.   Delete the following fields from the report: Supplier ID, Address, City,   State, and Postal Code. Delete the Page Number control. Apply the Gallery   theme to this object only. Sort the Supplier Name field in ascending order.   For the Phone field, change the Width property to 1.25.   For the Supplier Name field, change the Left property to 1 and then close the Property Sheet.   Save the report as Cap2 Suppliers Report   and then close the report.

 

Use   the Report Wizard to create a report based on the Cap2 Inventory table. Add   the following fields to the report: Department, Item Name, and Quantity, in   that order. Group by the Department field. Sort in ascending order by the   Item Name field. Find the Sum of the Quantity field. Be sure that the Layout   is Stepped and that the Orientation is Portrait. For the report title, type Cap2 Inventory by Department Report   and then switch to Layout view. Delete the controls that begin with Summary   for ‘Department’. Under Item Name, click any text box control, and then set   the Width property to 2.5.   For the Quantity label control, set the Left property to 6.5. Save and close the report.

 

Close   all database objects. Open the Navigation Pane. Close the database and then   exit Access. Submit the database as directed.

Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

July 1, 2023
    

11) Net income appears on the worksheet:

A) only in the balance sheet credit column.

B) only in the income statement credit column

C) in the income statement debit column and balance sheet debit column

D) in the income statement debit column and balance sheet credit column

 

12) Net loss appears on the worksheet:

A) in the income statement credit column and balance sheet debit column.

B) only in the income statement credit column.

C) in the income statement debit column and balance sheet credit column.

D) only in the balance sheet debit column.

 

13) The prepaid rent account has a balance that is $400 less in the worksheet's balance sheet debit column than in the worksheet's trial balance debit column. This would be the result of a:

A) $400 entry to prepaid rent in the worksheet's adjustments debit column.

B) $400 entry to prepaid rent in the worksheet's adjustments credit column.

C) $400 entry to rent expense in the worksheet's adjustments credit column.

D) mistake in cross-adding the worksheet.

14) Salary expense has a balance of $65,400 in the trial balance debit column of a worksheet. The adjustments credit column contains a $500 credit to salary payable. The adjusted trial balance column will show:

A) salary expense with a debit balance of $64,900.

B) salary expense with a debit balance of $6,500.

C) salary expense with a debit balance of $65,900.

D) salary payable with a credit balance of $65,900.

 

15) Interest expense on a worksheet's trial balance debit column has a $3,400 balance and a $4,000 balance on the worksheet's income statement debit column. The difference is due to:

A) an entry in the adjustments credit column for $600 to interest expense.

B) an entry in the adjustments debit column for $4,000 to interest expense.

C) an entry in the adjustments credit column for $4,000 to interest expense.

D) an entry in the adjustments credit column for $600 to interest payable.

 

16) On a worksheet, the income statement debit column equals $190,800 and the income statement credit column equals $195,600. From this data, it can be determined that:

A) the company had a net loss of $4,800 added to the income statement credit column.

B) the company had a net income of $4,800 added to the income statement debit column.

C) the company had a net loss of $4,800 added to the income statement debit column.

D) the company had a net income of $4,800 added to the income statement credit column.

 

17) Which of the following appears in the balance sheet debit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts payable

18) Which of the following appears in the income statement credit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts receivable

 

19) If the unearned service revenue account had an unadjusted normal balance of $4,800, and an adjustment was made debiting the account for $1,500, the account would appear on the adjusted trial balance of the worksheet as a:

A) $4,800 debit.

B) $6,300 credit.

C) $3,300 credit.

D) $3,300 debit.

 

20) After all the account balances have been extended to the balance sheet columns of the worksheet, the totals of the debit and credit columns are $35,350 and $38,750, respectively. It can be concluded the company has a:

A) net income of $3,400.

B) net loss of $3,400.

C) $74,100 net loss.

D) $74,100 net income.

 

 

 

default image
July 1, 2023
    

11) Net income appears on the worksheet:

A) only in the balance sheet credit column.

B) only in the income statement credit column

C) in the income statement debit column and balance sheet debit column

D) in the income statement debit column and balance sheet credit column

 

12) Net loss appears on the worksheet:

A) in the income statement credit column and balance sheet debit column.

B) only in the income statement credit column.

C) in the income statement debit column and balance sheet credit column.

D) only in the balance sheet debit column.

 

13) The prepaid rent account has a balance that is $400 less in the worksheet's balance sheet debit column than in the worksheet's trial balance debit column. This would be the result of a:

A) $400 entry to prepaid rent in the worksheet's adjustments debit column.

B) $400 entry to prepaid rent in the worksheet's adjustments credit column.

C) $400 entry to rent expense in the worksheet's adjustments credit column.

D) mistake in cross-adding the worksheet.

14) Salary expense has a balance of $65,400 in the trial balance debit column of a worksheet. The adjustments credit column contains a $500 credit to salary payable. The adjusted trial balance column will show:

A) salary expense with a debit balance of $64,900.

B) salary expense with a debit balance of $6,500.

C) salary expense with a debit balance of $65,900.

D) salary payable with a credit balance of $65,900.

 

15) Interest expense on a worksheet's trial balance debit column has a $3,400 balance and a $4,000 balance on the worksheet's income statement debit column. The difference is due to:

A) an entry in the adjustments credit column for $600 to interest expense.

B) an entry in the adjustments debit column for $4,000 to interest expense.

C) an entry in the adjustments credit column for $4,000 to interest expense.

D) an entry in the adjustments credit column for $600 to interest payable.

 

16) On a worksheet, the income statement debit column equals $190,800 and the income statement credit column equals $195,600. From this data, it can be determined that:

A) the company had a net loss of $4,800 added to the income statement credit column.

B) the company had a net income of $4,800 added to the income statement debit column.

C) the company had a net loss of $4,800 added to the income statement debit column.

D) the company had a net income of $4,800 added to the income statement credit column.

 

17) Which of the following appears in the balance sheet debit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts payable

18) Which of the following appears in the income statement credit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts receivable

 

19) If the unearned service revenue account had an unadjusted normal balance of $4,800, and an adjustment was made debiting the account for $1,500, the account would appear on the adjusted trial balance of the worksheet as a:

A) $4,800 debit.

B) $6,300 credit.

C) $3,300 credit.

D) $3,300 debit.

 

20) After all the account balances have been extended to the balance sheet columns of the worksheet, the totals of the debit and credit columns are $35,350 and $38,750, respectively. It can be concluded the company has a:

A) net income of $3,400.

B) net loss of $3,400.

C) $74,100 net loss.

D) $74,100 net income.

 

 

 

default image
July 1, 2023
    

11) Net income appears on the worksheet:

A) only in the balance sheet credit column.

B) only in the income statement credit column

C) in the income statement debit column and balance sheet debit column

D) in the income statement debit column and balance sheet credit column

 

12) Net loss appears on the worksheet:

A) in the income statement credit column and balance sheet debit column.

B) only in the income statement credit column.

C) in the income statement debit column and balance sheet credit column.

D) only in the balance sheet debit column.

 

13) The prepaid rent account has a balance that is $400 less in the worksheet's balance sheet debit column than in the worksheet's trial balance debit column. This would be the result of a:

A) $400 entry to prepaid rent in the worksheet's adjustments debit column.

B) $400 entry to prepaid rent in the worksheet's adjustments credit column.

C) $400 entry to rent expense in the worksheet's adjustments credit column.

D) mistake in cross-adding the worksheet.

14) Salary expense has a balance of $65,400 in the trial balance debit column of a worksheet. The adjustments credit column contains a $500 credit to salary payable. The adjusted trial balance column will show:

A) salary expense with a debit balance of $64,900.

B) salary expense with a debit balance of $6,500.

C) salary expense with a debit balance of $65,900.

D) salary payable with a credit balance of $65,900.

 

15) Interest expense on a worksheet's trial balance debit column has a $3,400 balance and a $4,000 balance on the worksheet's income statement debit column. The difference is due to:

A) an entry in the adjustments credit column for $600 to interest expense.

B) an entry in the adjustments debit column for $4,000 to interest expense.

C) an entry in the adjustments credit column for $4,000 to interest expense.

D) an entry in the adjustments credit column for $600 to interest payable.

 

16) On a worksheet, the income statement debit column equals $190,800 and the income statement credit column equals $195,600. From this data, it can be determined that:

A) the company had a net loss of $4,800 added to the income statement credit column.

B) the company had a net income of $4,800 added to the income statement debit column.

C) the company had a net loss of $4,800 added to the income statement debit column.

D) the company had a net income of $4,800 added to the income statement credit column.

 

17) Which of the following appears in the balance sheet debit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts payable

18) Which of the following appears in the income statement credit column of a worksheet?

A) service revenue

B) income summary

C) owner withdrawals

D) accounts receivable

 

19) If the unearned service revenue account had an unadjusted normal balance of $4,800, and an adjustment was made debiting the account for $1,500, the account would appear on the adjusted trial balance of the worksheet as a:

A) $4,800 debit.

B) $6,300 credit.

C) $3,300 credit.

D) $3,300 debit.

 

20) After all the account balances have been extended to the balance sheet columns of the worksheet, the totals of the debit and credit columns are $35,350 and $38,750, respectively. It can be concluded the company has a:

A) net income of $3,400.

B) net loss of $3,400.

C) $74,100 net loss.

D) $74,100 net income.

 

 

 

default image
Essay (any type)
August 22, 2022
    

They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.

 

default image
Customer #32567
Zoology, 8 Pages
Case study
August 22, 2022
    

Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.

default image
Customer #30093
Biology (and other Life Sciences), 6 pages
Presentation/PPT
August 22, 2022
    

The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.

default image
Customer #37612
Computer science, 8 pages
Journal article
August 22, 2022
    

My third using this writer and absolutely amazing work! Very punctual and very understanding.

default image
Customer #34820
Agriculture, 4 pages
Article
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #17907
Technology, 5 pages
Thesis/Thesis chapter
August 22, 2022
    

I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!

default image
Customer #32146
Economics, 9 pages
Research paper
August 22, 2022
    

It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.

default image
Customer #22371
Ecology, 5 pages
Lab Report
August 22, 2022
    

Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again ❤️

default image
Customer #13712
Nursing, 6 pages
Outline
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #267302
IT, Web, 6 pages
Essay (any type)
August 22, 2022
    

Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!

default image
Customer #14472
International Trade, 8 pages
Essay (any type)
August 5, 2021
    

You are making my life so much easier! I am a single mom that works and goes to school. You guys are helping me with my projects so I can have more free time with my son.

default image
customer #13832
Tourism, 3 pages
Annotated Bibliography
August 5, 2021
    

I was sure it can fit in a single page but the next time I will add one more page because I am impressed with your professionalism and quality. Will use many more times till I graduate.

default image
customer #12008
Management, 7 pages
Essay (any type)
August 5, 2021
    

Simple registration and quality services. I just ordered one paper, and it was good enough to pass the exam. That is what I need the most. Good job.

default image
customer #16257
Communication, 4 pages
Research Proposal
August 5, 2021
    

I couldn’t finish my freaking essay, and I was very desperate. A friend of mine sent me a link, and that is how I found out about you guys. Thank you for professional tips and editing. Now, I understand how to write it properly.

default image
customer #17128
Law, 5 pages
Reflection
August 5, 2021
    

I’m so grateful to you since you managed to complete my term paper in one day! You are definitely the best company ever!

default image
customer #16528
Public Relations, 7 pages
Essay (any type)
August 5, 2021
    

I am sure on your ability to provide any type of paper I will order. I wish I could develop that skill your writers have to be able to have a flow of ideas and excellent sequencing of thoughts in writing.

default image
customer #19552
Medicine, 5 pages
Coursework
August 5, 2021
    

I ordered a thesis paper and was satisfied. All the guys were polite and highly professional, even when I wrote to them several times per day. Thanks for your passion!

default image
customer #20376
Nursing, 6 pages
Discussion Essay
August 5, 2021
    

I turned to the service twice, and my papers always were beyond the expectations. To tell the truth, I was ready to find some grammar errors or something like that. However, everything was neat and tidy.

default image
customer #18529
Marketing, 1 page
August 5, 2021

My friend recommended Doctor My Essay to me. It is convenient! Now we both turn to the service periodically coz wanna save some time and use it more effectively. I know that while I’m developing my startup, an expert is working on paper. Time management in work!

default image
Research Paper
August 5, 2021
    

I write all paper works by myself but have some problems with literacy. Actually, I have enormous problems because English is not my native language. However, with proofreading from Doctor My Essay, I can relax and don’t be ashamed of mistakes.

default image
customer #12924
Business, 7 pages
Argumentative Essay
August 5, 2021
    

Your ability to write concisely is a finding. The paper has a solid argument. It’s clear that the writer understood central claim about the topic. He also presented original ideas to consider.

default image
customer #19304
Management, 3 pages
Coursework
August 5, 2021
    

That paper got the highest grade in my class and the professor thinks I’m the smartest student. Lol.

default image
customer #12387
Accounting, 6 pages
Essay (any type)
August 5, 2021
    

I was convinced that paper writing services are the fiction for naive students. But when it came to my research paper that was to be composed in 72 hours, I had no other options. I made the right choice when I ordered it from you!

default image
customer #12924
Ethics, 4 pages
Business Plan
August 5, 2021
    

I was also satisfied with the service. Usually, I write everything by myself, but this time ( I have no idea how it happens!) I missed the deadline. My writer was very responsible, wrote the essay quickly, and kept the instructions. Nice to know that such experts exist!

default image
customer #15677
Marketing, 10 pages
Annotated Bibliography
August 5, 2021
    

It is really affordable! The prices start from 9$, which is an excellent proposal on the market. Recently I worked with another service that took much more money and provided lower quality papers.

default image
customer #11234
Sociology, 9 pages
Research proposal
August 5, 2021
    

I am absolutely satisfied. I am first timer here. Revision was made quickly, and the author met my expectations. Thanks a lot. Paper is phenomenal.

default image
customer #15327
Economics, 5 pages
Essay (any type)
August 5, 2021
    

Having heard a lot of negative reviews about such services, I was a bit skeptical. However, our cooperation with Doctor My Essay was without pitfalls. I made two comments about the final work, and they re-wrote some parts very promptly. I am satisfied and will turn to them in the future.

default image
customer #17823
Human Resource Management, 2 pages
Research paper
August 5, 2021
    

It was my first experience in online ordering, and I was a bit nervous. However, this was for nothing. I’ve got a high mark!

default image
customer #12372
Public Relations, 3 pages
Dissertation
August 5, 2021
    

I understand that buying essays is a doubtful thing. You don’t put effort, don’t represent your ideas… However, I don’t perceive Doctor My Essay as a standard service. They don’t sell papers. They share high expertise!

default image
customer #12376
Journal article, 20 pages
Coursework
August 5, 2021
    

According to my previous experience, this service is really the best. They support the client and have competitive writers. I give them a perfect score!

default image
customer #19266
Political Science, 6 pages
Admission Essay
August 5, 2021
    

Nice service! It is cool that you can use the calculator on the main page and understand the price policy. For me, it is a huge plus!

default image
customer #11437
Tourism, 1 page
Discussion Essay
August 5, 2021
    

Thanks to God I found this service! If I didn’t send my research to the teacher on time, he would eat me. I tell you! However, with doctor my essay service, I met the deadline, and I am still alive.

default image
customer #12692
Philosophy, 5 pages
Report
August 5, 2021
    

Your service is excellent! Convenient and not expensive. Thanks for that!

default image
customer #10923
Psychology, 4 pages
Essay (any type)
August 5, 2021
    

If you have problems with time management, just like me, you need to cooperate with Doctor My Essay. Once you registered and made the order, you understand how easier it makes your life! Everything is online: ordering, communication… You can control the process everywhere and be sure that an expert will provide a high-level paper.

default image
customer #17823
Business, 8 pages

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more