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 corporate structure in relation to its strategy, Which company do y...

Which company do you know of that successfully has been able to successfully or not manage its corporate structure in relation to its strategy? Explain you're rational. Cite all yo

Described in the initial kickoff meeting for a project, Which of the follow...

Which of the following would be the first item to be discussed in the initial kickoff meeting for a project? Answer Understanding of the requirements Understanding of the

Case let, 1. What modification would you suggest in enhancing the existing ...

1. What modification would you suggest in enhancing the existing logistics system?

Practice Question.., 4. (32 points) You and your roommate are planning to o...

4. (32 points) You and your roommate are planning to open “Pizza In The Dorm” to make and distribute fresh pizza from your dorm room. You plan to provide 100% fresh, high quality p

Explain what is the status of the internet contract, Beth advertised her 20...

Beth advertised her 2005 Corvette for sale on the Internet. In her advertisement, she falsely stated that the vehicle had only been driven 60,000 miles when in fact it had been dri

Explain the various classifications of stakeholders, An Organization: Its M...

An Organization: Its Mission and Strategic Intent In this assignment, you will decide on a company's strategic intent, its mission, and the role of stakeholders in developing an

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?

How reduce the safety stock, The annual demand for a product is 15,600 unit...

The annual demand for a product is 15,600 units. The weekly demand is 300 units with a standard deviation of 90 units. The cost to place an order is $31.20, and the time from order

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