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

Breadth of supplier base - many or few suppliers, Breadth of Supplier Base ...

Breadth of Supplier Base - Many or Few Suppliers The traditional approach to supplier selection is to prepare a tender document and request a quotation from a range of suitabl

Evaluate website effectiveness, Choose any company website and evaluate its...

Choose any company website and evaluate its effectiveness. Write an essay of between 750-1000 words, double-spaced, focusing on such topics as the web site's attractiveness and the

Describe why your company needs to be socially responsible, You are the CEO...

You are the CEO of a factory that manufactures furniture. Explain briefly why your company needs to be socially responsible. Briefly comment on any two areas of social responsibili

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

Automated layout design programme, Automated Layout Design Programme or ALD...

Automated Layout Design Programme or ALDEP Here the closeness relationship between two department is used to build up layout . Computer selects randomly the first facility and

Describe what would be the total number of workers, In the precedence chart...

In the precedence chart to the right, times are in seconds. 1 Assume that the plant runs one 7.5 hour shift per day and the assembly line is designed with 5 stations (one worker pe

Explain decision making under uncertainty, Even though independent gasoline...

Even though independent gasoline stations have been having a difficult time, Susan Helms has been thinking about starting her own independent gasoline station. Susan's problem is t

Explain the e-activity, "Big Box" Please respond to the following: •From th...

"Big Box" Please respond to the following: •From the video, determine if it is the responsibility of an organization to pay its workers a "living wage." Explain your rationale. •Fr

Explain what additional steps should the quality assurance, A quality analy...

A quality analyst wants to construct a sample mean chart for controlling a packaging process. He knows from past experience that the process standard deviation is two ounces. Each

How performance based pay systems might be better designed, Is performance-...

Is performance-based pay effective? Why or why not? How performance based pay systems might be better designed to ensure optimal results

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