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

Determine whether ability and motivation is more important, Determine wheth...

Determine whether ability or motivation is more important in selecting the right person for the right job. Explain your rationale.

Improve efficiency in service organisations, Lean" thinking was first devel...

Lean" thinking was first developed with manufacturing organisations in mind. Explain FIVE examples of ways in which these waste elimination principles may be applied to improve eff

Explain strategy is a common term in business, Strategy is a common term in...

Strategy is a common term in business. Is it a concept and/or a construct? Explain. Define it as a concept and/or a construct.

Examine netflix''s current strategy, Evaluate Netflix's current strategy an...

Evaluate Netflix's current strategy and determine if the strategy is sustainable. Identify a Netflix strength may be leveraged in the market place to ensure a competitive advantage

Explain old assembly line method, What changes in the work situation might ...

What changes in the work situation might account for the increase in productivity and the decrease in controllable rejects? What might account for the drop in absenteeism and the i

Compare human assets versus other organizational assets, The primary issue ...

The primary issue is that people want to be challenged. People want to be challenged, at least initially, in terms of their Assignments. They also want to be continuously challenge

Describe scenarios and contingency plans, Ok need a little help in arrangin...

Ok need a little help in arranging these in the right order 1-5 Select measures and targets Set strategic goals Hold operational reviews Implement single-use plan Define scenarios

Explain profits and time based competitiveness, Small businesses have been ...

Small businesses have been slower to integrate information technology into their operations than larger companies. Discuss the reasons for this state of affairs, identifying severa

Explain what type of noise was experienced, Choose a communication situatio...

Choose a communication situation you recently experienced at your workplace or other organization you are affiliated with. Use the human communication process described on pages 10

Steps in layout planning and design, Steps in Layout Planning and Design ...

Steps in Layout Planning and Design For a given product at a stated volume of production a process most appropriate must be determined. The process that is determined like any

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