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

Managing global operations, what are the key issues to be considered for ma...

what are the key issues to be considered for managing global operations

Explain national cattlemens beef association advertises beef, When the Nati...

When the National Cattlemens Beef Association advertises Beef, Its Whats for Dinner, it is trying to stimulate _____ demand. selective primary derived generic second

Explain the major risk factors of the disease, Select one chronic disease s...

Select one chronic disease such as diabetes or heart disease. Assume that you are working for a county public health department with staff nurses and physicians. You want to run a

Internal factors - factor affecting productivity improvement, Internal Fact...

Internal Factors - Factors affecting productivity improvement These are the factors which may be modified by the company and may, in themselves, be sub-divided into two catego

Analyzing layouts with computers, Analyzing Layouts with Computers Du...

Analyzing Layouts with Computers Due to the advent of computers and software faculties. Presently computers are used to design the facility layout. Digital computers are wide

Describe the difference among rationalist and incrementalist, Explain the d...

Explain the difference between rationalist and incrementalist strategy. Who are the main protagonists of the theories? How have the debates regarding these theories had implication

Line balancing, What happens if balance doesn''t exist

What happens if balance doesn''t exist

Explain government grants, Assume that the company received no government g...

Assume that the company received no government grants and that all the funding for the company has come from VCs. Add an earlier seed round to replace the government funds, and mak

Explain what is the value creation frontier, 1.Why does each generic busine...

1.Why does each generic business model require a difficult set of business-level strategies? Give examples of pairs of companies in: (a) the computer industry; (b) the electronics

Explain the term marketing and selling, Explain the term Marketing and Sell...

Explain the term Marketing and Selling. Marketing and Selling : The marketing theory is a management orientation which holds that the key task of the organization is to find o

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