Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Microsoft Access Data Queries

29/09/2020 Client: mmm78901 Deadline: 7 Days

  


Part 2


Software skills: Database design and querying


Business skills: Inventory management


In this exercise, you will use database software to design a database for managing inventory for a small business. Kamen Rider, located in New York, sells road, mountain, hybrid, leisure, and children’s bicycles. Currently, Kamen Rider’s purchases bikes from three suppliers but plans to add new suppliers in the near future. Using the information found in the tables given in the small desktop database, help manage information about Kamen Rider’s suppliers and products. Perform the following.


1. Execute a query that identifies the five most expensive bicycles (for customers). The query should list the bicycles in descending order from most expensive to least expensive (by Selling Price), the quantity on hand for each, and the markup percentage for each. Save this query as Q1_Five_Most_Expensive_Bicycles. Hint: Profit Mark Up = (Selling Price – Cost Price)/Cost Price. (2.5 points)


2. Execute a query that lists each supplier, its products, the quantities on hand, and associated reorder levels. For each supplier, the products should be sorted alphabetically. Include a criterion for bicycles that have Quantity_on_Hand that is more than 5. Hint: This requires hierarchical sorting and a numerical filter. Save this query as Q2_Supplier_Product (2.5 points)


3. Execute a query listing only the bicycles with names starting with “E” as well as those that end with “er”, and their corresponding suppliers. In your query, include the Product Name, Purchase Cost, and the supplier’s Company_Name. This needs a little bit of thinking. Save this query as Q3_BR_bicycles (2.5 points).


4. To enhance the database, we need a table of supplier information. Create a table called Supplier_Info that has supplier telephone numbers. For full credit here, include an appropriate input mask. Populate the table with the appropriate fields. Populate the table with the suppliers to demonstrate our ability to enter data to a database and to check that it works. Be sure to enter all suppliers (there should be 5). Make up the telephone numbers. This requires some thinking on what field(s) to include other than telephone numbers in the new table. Recall that databases should be normalized, and we should join apples to apples, oranges to oranges; and we want to avoid redundancies. For purposes of this assignment, create the table accordingly. There’s no need to join other tables. Save this table as Supplier_Info (2.5 points).


Your work will be evaluated on the accuracy of the results, quality of your answers, and ability to apply the concepts. Submit your work on Canvas. There should be 2 documents: (1) a single word document (or pdf) for part 1, and (2) the database file (Access file) for part 2 by the due date. Late submissions will result in a 5% penalty for each day late.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Isabella K.
Instant Assignments
Essay & Assignment Help
Top Essay Tutor
Calculation Guru
Writer Writer Name Offer Chat
Isabella K.

ONLINE

Isabella K.

I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in this industry since 2014 and I have served more than 1200 clients with a full amount of satisfaction.

$125 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Good day dear client, I am a full-time freelance writer with years of experience. My strongest strengths are strong dedication to duty, reliability, quality and excellence. I am going to do an outstanding job for you, kindly PM me and let us commence. Thank you so much in anticipation of your positive response. Thank you very much.

$125 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$125 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

Hi dear, I am ready to do your homework in a reasonable price.

$115 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

$125 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

O to ue spanish verbs - Michael goldstein and hannah snopes - Conscientization approach in community organization - Why do organizations resist change - The white company is a member of the lamp industry - Rules for solving equations - National electrical code questions - Sociology - Ramirez company installs a computerized - Separation of mixtures lab chemistry - Gymnosperms were the first plants to reproduce using - Titration of kmno4 with feso4 - Assig 5 Nursing Theory - Bookkeeping differs from accounting in that bookkeeping primarily involves - Leader/Context Interaction and Theory Applicability - Patwa language st lucia - Data analysis plus excel 2019 - Vocabulary -1 - Northcentral university dissertation proposal template - Current Topic Essay #2 - Shadow health focused exam abdominal pain objective - Bernhard rapid relief 1000 - Meiotic division beads diagram with crossing over - Discussion - Organizational development case study analysis - Based on surveys of managers the society's moral - Itec ashton under lyne - Discussion Board/ HLT 103 - How can policies and procedures facilitate good strategy execution - How to install elfa easy glider - Occupy all streets book amazon - Correctional leadership competencies for the 21st century - P2 30a accounting - Geometry found in nature - Saint lucian creole french - Projectile motion lab answers - Human resource management noe hollenbeck gerhart wright pdf - Alla en el rancho grande instrumental - Ceres gardening company funding growth in organic products case solution - Describe the health illness continuum - Market offerings are limited to physical products - 4 noble truths worksheet - 4400 ml in pints - 4-4 project part one - Third person past tense - Traveling electromagnetic wave mastering physics - Constructed wetlands for wastewater treatment ppt - Job cover letter and resume - Probability carnival games - Emancipation proclamation historical significance - The hunger games solution - She did deceive her father marrying you - ChatGPT Nederlands Gratis – Ontdek de Mogelijkheden van Gratis AI - Chapter 5 the time value of money - What is a good percent yield - Whispers on the color line - Sampling analog signal in matlab - Game of life career cards - Bedford hospital children's outpatients - Airbnb marketing strategy case study - Ps2 movie games list - English 4 part 1 assignment - Brookville carriers nova scotia - Sea bean seed dispersal - A mi hermanito le dolía la con frecuencia. - Robert morris associates financial ratios - Https www procon org headline php headlineid 005323 - Cloverleaf plc case study answers - Penn foster books - Colours in te reo - HR_GLOB_FIN (U3) - Money and materialism in a doll's house - Discussion - Cheap hotels near royal brompton hospital - 300 words - Hr assignment 15 - Report descriptive statistics apa - Grant and Contract Proposal Writing – Week 2 - Xtm air compressor 160 lpm 150 psi review - Geoadvertising sends ads to users based on their - Housing options port talbot - Selby council bin collection - My personal leadership philosophy paper - The story of an hour literary devices - Annual Report Project - Section 1 - Marketing Plan - Call centre shrinkage definition - Peer and self reflection critique assignment. - Costco employee turnover rate 2012 - Week 7 Discussion 1 Physiology an Pathophysiology - Ncia wwnorton - A psychologist using the method of naturalistic observation would - Method statement exhibition stand - Roip server open source - Pole dancing fitness classes birmingham zumba class birmingham body synergy - 250-300words summary of focused topic - Experiment 1 enzymes in food - Ronald reagan tribute to the challenger astronauts speech - What is the rational approach - Sbar a shared mental model for improving communication between clinicians