Help with microsoft access problem 2 | Introduction to Computer Concepts & Applications

 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

For the Week 3 Microsoft Access Module 2 Lab Assignment, you create queries using a starter database. Use skills/techniques/concepts learned in the Microsoft Access Module 2. HINT: The finished Lab Assignment should include: 2 tables, 12 queries, 2 forms, and 2 reports.

Problem: The manager of the Milledgeville, Georgia, science museum gift shop has come up with a variety of questions he wants to answer using the database. You are to find the answers to these questions.

Perform the following tasks:

  1. Open the following starter database (Week 3 Microsoft Access Module 2 Lab Assignment), save the database as LastnameFirstnameAccessLab2.accdb.
  2. Create a query for the Item table that includes all fields and all records in the Item table. Save the query as Step 1 Query.
  3. Create a query for the Item table that includes the Item Number, Description, Wholesale Cost, and Vendor Code fields for all records where the vendor code is BW. Save the query as Step 2 Query.
  4. Create a query for the Item table that includes the Item Number and Description fields for all items where the description starts with G. Save the query as Step 3 Query.
  5. Create a query for the Item table that includes the Item Number and Description for all items with a Wholesale Cost greater than $15.00. Save the query as Step 4 Query.
  6. Create a query for the Item table that includes the Item Number, Description, and Wholesale Cost fields for all items with a Wholesale Cost between $5.00 and $10.00. Save the query as Step 5 Query.
  7. Create a query for the Item table that includes the Item Number, Description, On Hand, and Wholesale Cost fields for all items where the number on hand is less than 5 and the wholesale cost is less than $15.00. Save the query as Step 6 Query.
  8. Create a query for the Item table that includes the Item Number, Description, Wholesale Cost, and Vendor Code for all items that have a Wholesale Cost greater than $20.00 or a Vendor Code of FD. Save the query as Step 7 Query.
  9. Create a query that joins the Vendor and the Item tables. Include the Vendor Code and Vendor Name from the Vendor table and the Item Number, Description, Wholesale Cost, and Retail Price fields from the Item table. Sort the query in ascending order by Description within Vendor Code. Save the query as Vendor-Item Query.
  10. Create a form for the Vendor-Item Query. Save the form as Vendor-Item Form.
  11. Create a report that uses the Vendor-Item Query but does not use all the fields in the query.  Include Vendor Name, Description, Wholesale, and Retail.  Save the report as Vendor-Item Report.
  12. Create a query for the Item table that includes the Item Number, Description, Wholesale Cost, and Retail Price. Calculate the difference between Retail Price and Wholesale Cost (Retail Price – Wholesale Cost). Assign the alias Mark Up to the calculated field. Save the query as Step 11 Query.
  13. Create a query for the Item table that displays the average Wholesale Cost and the average Retail Price of all items. Save the query as Step 12 Query.
  14. Create a query for the Item table that displays the Item Number, Description, On Hand, and Retail Price for the 5 items with the lowest retail price. Save the query as Step 13 Query.
  15. Update the author (use your name) and title (use ‘Week 3 Microsoft Access Module 2 Lab Assignment’) in the document properties.

Upload your assignment as a Microsoft Access database using the following naming protocol: LastnameFirstnameAccessLab2.accdb

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Order a unique copy of this paper
(550 words)

Approximate price: $22

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

It's no longer good enough to create a high-quality product at a reasonable cost.
That is why we have created 9 compelling warranties to make your usage of our service pleasant, simple, and secure.

Money-back guarantee

You must be completely confident in the quality of your products in order to provide a money-back guarantee. This is precisely how custom paper writing services work. We double-check that there are no hidden issues with this promise and that you are completely happy with the quality of your purchase.

Read more

Zero-plagiarism guarantee

Our writers do not employ others’ writing tricks, because we are aware that plagiarism may cost a lot to our clients and take away their reputation.

Read more

Free-revision policy

We want you to be satisfied with your order, so we offer a free revision policy. If you are not completely happy with your order, let us know and we will revise it for free.

Read more

Privacy policy

We care about our customers and always strive to keep their trust. That’s why Customwritingspapers.com guarantees privacy and safety of your personal information. To ensure total security, we take the following measures:

Read more

Professional Editors

Our team of editors works tirelessly to ensure that all papers meet our high standards for quality. They check for the instructions, grammar, punctuation, and spelling mistakes as well as for plagiarism.

Read more

Fair-cooperation guarantee

We would never want to jeopardize our relationship with you, and that is why we offer a fair-cooperation guarantee: If for any reason you are not satisfied with your order, you can always get your money back.

Read more

Professional Writers

We only hire the best, most qualified professionals to work on your order. Each writer is a degree holder with extensive experience in their field. You can be assured that your project will be handled by a true expert.

Read more

Quality Control

Our quality assurance department ensures that each paper is of excellent quality before it is sent to you. You can be sure that your paper will meet all of the requirements that you set. Our experts are highly skilled and will follow your specific instructions to the letter.

Read more

Customer support

We have a highly professional and qualified customer support team that is available 24/24, 365 days a year. They will be more than happy to answer any questions or concerns that you may have about our company or products. You can contact them by phone, email, or chat on our website.

Read more

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
Open chat
1
Order through WhatsApp!
customwritingspapers.com
Hello!
You Can Now Place your Order through WhatsApp

Order your essay today and save 30% with the discount code DISCOUNT2022