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 the similarities and differences of tqm, Describe the similarities ...

Describe the similarities and differences between TQM and Six Sigma quality-management techniques.

Explain expected learning curve, A time standard was set as 0.20 hour per u...

A time standard was set as 0.20 hour per unit based on the 50th unit produced. If the task has a 90 percent learning curve, what would be the expected time of the 100th, 200th, and

Describe some of the important factors new location, List and explain some ...

List and explain some of the important factors to be considered when selecting a new location for a hospital to be built from some potential site

Explain transportation problem, How many constraints are there in a transpo...

How many constraints are there in a transportation problem which has 5 supply points and 4 demand points?

Define conflicting need of the variety of stakeholder groups, If you were M...

If you were Monsanto's CEO, how would you best balance the conflicting needs of the variety of stakeholder groups that Monsanto must successfully engage?

Describe what role organizational structure plays, Discuss what role organi...

Discuss what role organizational structure plays in an organization's efficiency & effectiveness

Why the supply chain management such a topic of interest, Why is supply cha...

Why is supply chain management such a topic of interest lately, especially multifacility distribution?

Explain unethical behaviour proposed by saul gellerman, Of the four commonl...

Of the four commonly held rationalizations for unethical behaviour proposed by Saul Gellerman, which one do you thing gets use most often? Why?

Explain productivity compared to having imported cars, During the 1950s and...

During the 1950s and 609, Mr. T. Ohno of Toyota developed the k an n Production System. Subsequently many other Japanese automobile companies adopted it. The net result with the Ja

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