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 activity immediate predecessor normal time, The Scott Corey account...

The Scott Corey accounting firm is installing a new computer system, and several things must be done to make sure the system works properly. The following table provides informatio

Explain what do you think needs to be improvement, B. Using the IT Savvy fo...

B. Using the IT Savvy four types of the CIO (page 146 IT Savvy), choose a type for each of CIO or IT leaders for all of the cases we have reviewed in this class. Give example of w

Demerits of a phased system roll-out for bombardier, 1) In your opinion, ho...

1) In your opinion, how does the visioning phase of the Bombardier ERP project impact the rest of the project? 2) What organizational outcomes did Bombardier expect with a succe

Explain introduction to optimum design, Why are there no solutions for Intr...

Why are there no solutions for Introduction to Optimum Design textbooks?

Explain develop an aggregate production plan, ABC Company, a manufacturer o...

ABC Company, a manufacturer of roofing supplies, has developed monthly forecasts for roofing tiles. The forecasted demand and the expected production days for months March to Augus

Explain what both the plaintiff and defendant must do, What are the procedu...

What are the procedural steps necessary to sue a person or company for business law dispute? Discuss and illustrate what both the plaintiff and defendant must do.

Accounting, describe the element that makeup TQM as amoderv philosophy and...

describe the element that makeup TQM as amoderv philosophy and quality mangementsamodern

Explain what charles schwab & pfizer works, Read the Ask Chuck & a New Kind...

Read the Ask Chuck & a New Kind of Structure Case Applications on pages 283 & 284. Describe what Charles Schwab & Pfizer Works are doing. Discuss what role organizational structure

Explain what ethical considerations your response, Please explain in detail...

Please explain in detail what you would do for the following scenario: A good friend of yours from college who had a wild reputation is applying at your company. The HR manager cat

Explain focuses on the customer relationship, Choosing which processes are ...

Choosing which processes are core to a firm's competitive postition is a key strategic decision. For example, Nike, a popular sports shoe company, focuses on the customer relations

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