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

Vsim kenneth bronson - What elements are typically included in outplacement services - High power variable capacitor - Strategic management topics for presentation - Case study analysis example - Answer 10 questions according to the reading, due Oct.4 - Bloom's higher order thinking questions - Tlc x tugger results - Shapiro wilk test of normality spss - Saving the bees persuasive speech - University park nottingham postcode - Ampere's law differential form - Find someone who present continuous - Unit 3 discussion board - What is a claim of definition - Angus young 1970 sg - You have two cows - Cross sectional area of copper wire - Manor lakes p 12 - Frimley park hospital physiotherapy number - Library chamberlain.edu - Mla format citation for the great gatsby - Woma high pressure pump - 100 roberts road subiaco - BBA 2026 DB 7 and 8 - Agrotop airmix nozzle chart - Geze 24v door closer - The human odyssey volume 3 - Samsung swot 2018 - Discussion 2.2: RFP or RFI? - W6 WORK - How do you calculate the thickness of aluminum foil - Bupa okta password reset - Sensitive and dignified care for the bariatric patient quizlet - Case Study 2: The Job That Was Too Good to Be True - 1 anzac highway keswick - Capstone assignment - Module 02 Discussion - Congressional Contributions to Universal Healthcare - Discussion 8 - What does the net change in the potato sample indicate - I need a discussion done and a respose to 2 other classmates for my Marketing in Global Environment - Billionaire card game kmart - Chapter 7 Discussion - The giver chapter 7-8 answers - Elite facilities maintenance canberra - Effective Speaking Discussion - Stanford prison experiment timeline - Leadership's Role in Organizational Change - Assessing risk sbe id 503 - Introduction to advertising - Visual basic programming exercises - Assignment - Timon penn and teller revealed - Los baker van a peru sparknotes - 21st century jet the building of the 777 - How does the body shop help the environment - Article notes - Quiz - Nickel and dimed discussion questions - Am i addicted to sexting quiz - Nursing G P F (24 hours) - Assignment wk3 - Introduction to hospitality and tourism industry ppt - Bcg matrix of toyota - Project report status template - North african pop music - Marks and spencer financial statements 2013 - Warm fuzz cards - Conveyor belt project - Sodium phosphate monobasic and dibasic buffer - What was the purpose of sojourner truth's speech - Tyree energy technology lg05 - Data mining - Ibm websphere compute grid - Netscaler policy cannot be bound to specified policy label - TOUCHSTONE 2.1 EVALUATE A SOURCE (2-3 PAGES//500-750 WORDS DOUBLE SPACE) - Leadership enhancing the lessons of experience 6th edition - Trade support loan application form - An example of horizontal analysis is - Estudent macquarie university log in - Different types of historians - What is sprites slogan - Creating customer value satisfaction and loyalty - 4/114 dennis road springwood - Family to family leaving a lasting legacy - Write a essay - How to play chuck a luck - Scantronic 9651 proximity tag - Dry ice is solid carbon dioxide a - Laplace transform of unit step function in matlab - Anatomical directional terms and body planes quiz - Information Technology and Organizational Help - Soc 515- final paper - Declaration of original work unisa - Biometrics week1 db - I2 cl2 h2o hio3 hcl redox - Somalia the nation of poets - Horizontal and vertical trend analysis - 1 - Need tomorrow