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

Stepping stone method, what advantage and disadvantage stepping stone metho...

what advantage and disadvantage stepping stone method?

Explain optimization technique and a heuristic to solve, What is the differ...

What is the difference between using an exact optimization technique and a heuristic to solve a problem?

Explain what is the flow time for the glove, A manufacture of women's desig...

A manufacture of women's designer gloves has employed a team of students to redesign her manufacturing unit. They gathered the following information. The manufacturing process cons

Explain what laws are applicable to this fact pattern, Marie wrote Ray a ch...

Marie wrote Ray a check for landscaping her front lawn. Marie paid Ray in advance. The check was dated for five days later than the date of issuance. Ray was supposed to start land

Explain one attribute or capacity of servant leadership, Write a 500-750-wo...

Write a 500-750-word paper analyzing emerging leadership theories. Address the following questions and concepts 1) Describe one attribute or capacity of servant leadership an

Explain lead directly to performance but is moderated, Stephanie the CEO of...

Stephanie the CEO of XYZ Inc., is trying to increase the level of effort and therefore performance in her company. Based on expectancy theory on motivation she knows that effort do

Explain what are the objectives of work-center scheduling, 1) What are the ...

1) What are the objectives of work-center scheduling? 2) Distinguish between a job shop, aGT cell and a flow shop?

Explain object oriented database model, The relational database model gaine...

The relational database model gained popularity and many proponents during the 1980's and 1990's, a period of time in which IT organizations were seeking to consolidate data from m

Process design in operations managment, when asked to critically discuss ma...

when asked to critically discuss main factors that influence process design within a familiar organisation, does this mean a breakdown of the company''s design process or an analys

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