Explain computer and open the database using access, Operation Management

Assignment Help:

In Doc Sharing, you will find an Access database labelled Week 4 Discussion North wind. Save the database to your computer and open the database using Access. Answer the questions below. Please assist one another.

a. View the design of the database in the Database Tools-Relationships window. Describe some queries that would be useful to North wind Traders as it strives to increase sales, profits, or reduce expenses. Be specific, listing the tables, columns, and data that you would extract from the North wind Database. Also, indicate why such queries are useful from a business standpoint.

b. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document

c. Create a few queries that allow you to practice concepts from the Lab. Please, don't simply post queries from this week's lab assignment! Post a screenshot of the query design and the results set in a Word document. Also, describe how this query could help managers make a business decision.

d. Relying on the textbook, the lecture, or Internet research, describe query generation techniques that you haven't yet applied in this week's lab. Describe what the querying technique is and how it is useful. For example, you might research the concept of a parameter query, describe what it is, and then create such a query in the Northwind database. Post a screenshot of the query design and the query results as an MS Word document to this thread for discussion.

e. Assist your classmates in modifying their queries if they run into difficulties


Related Discussions:- Explain computer and open the database using access

Explain what is the agency problem, What is the agency problem? What steps ...

What is the agency problem? What steps can be taken to solve it? Why is it important for managers and organizations to behave ethically?

Describe what are the advantages of financing, In the %u201CWhat would you ...

In the %u201CWhat would you do?%u201D section of your text in Chapter 9, Pam Marrone of AgraQuest, Inc. tapped into Internet sources when she needed additional financing. Be specif

Network design, 1. What is meant by the level of threshold service of a lea...

1. What is meant by the level of threshold service of a least-cost system?

Explain how do projects drive accountability, How do projects drive "accoun...

How do projects drive "accountability"? Why would managers fear this particular terminology?

Explain what is cross-functional decision making process, What is cross-fun...

What is cross-functional decision making process, strategy model, and supply chain?

Explain units of output per dollar of input, A hamburger factory produces 4...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is the

What area of human services do you find the most interesting, There are a w...

There are a wide variety of exciting and interactive professions in the field of human services. As demonstrated in the video below and through your reading, do you think that musi

Explain three major important roles of entrepreneurship, Describe three maj...

Describe three major important roles of entrepreneurship in the American economy.

Design and management of an efficient operating system, Question 1: (a)...

Question 1: (a) Using appropriate examples, explain in details the different approaches that operations managers can use to reconcile capacity and demand. (b) Critically S

Explain teaching and medical care have many similarities, In many ways teac...

In many ways teaching and medical care have many similarities. This study of leadership style during innovation efforts has a lot to say about leadership in a time of change in hea

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd