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 which style did you find most effective, Think back to teachers you...

Think back to teachers you have had, and identify one each who fits a supportive style, directive style, participative style, and achievement-oriented style according to the path-g

Describe barcelona restaurant group quality, From the video "Barcelona Rest...

From the video "Barcelona Restaurant Group", determine how the same focus on quality demonstrated by the Barcelona Restaurant Group could benefit manufacturing operations. Provide

Explain when the doctor dictates a decimal such as point1, What do you do w...

What do you do when the doctor dictates a decimal such as "point 1"?

Explain matrix organization isn''t working, Your company's matrix organizat...

Your company's matrix organization isn't working; decisions are taking too long and it seems to you that instead of best solutions you're getting compromises. As CEO what would you

Explain how many hats should be in inventory, The Bryant Museum is open 360...

The Bryant Museum is open 360 days per year. On average, they sell 3 hounds tooth hats per day. Each hat sells for $16. The museum%u2019s holding cost is $1 / hat / month. Each ord

Explain what is your total cost for balls each year, You buy tow hitch ball...

You buy tow hitch balls in large lots for the tow tractors you manufacture. You estimate that it costs you approximately 20% of cost to store a ball for a year. Ordering cost is

Explain self-preservation is not the highest value, Are there situations in...

Are there situations in which self-preservation is not the highest value?

Explain what is the assembly line efficiency, An assembly line with 30 acti...

An assembly line with 30 activities is to be balanced. The total amount of time to complete all 30 activities is 42 minutes. The longest activity takes 2.4 minutes and the shortest

What is long-term profitability goals, Discuss the strategic importance of ...

Discuss the strategic importance of layout decisions. How important as these decisions in terms of a company's long-term profitability goals? What are some examples?

North west corner rule, North West Corner Rule: Step1: The  first  a...

North West Corner Rule: Step1: The  first  assignment is made in  the cell  occupying  the upper  left  hand ( north  west ) corner  of  the transportation  table. The maxim

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