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

What must an organization do to prepare for such a risk, Product contaminat...

Product contamination is a catastrophic event, both for the organization at fault and for the victims. Cases of product contamination frequently make the news. Find an example o

Wlan standard is compatible with what other wlan standard, The 802.11g WLAN...

The 802.11g WLAN standard is compatible with what other WLAN standard? a. Bluetooth b. 802.11a c. 802.11b d. HomeRF

Explain job evaluation, Explain Job Evaluation. A combination of short ...

Explain Job Evaluation. A combination of short statements which describe both the necessary requirements of the particular job and the work to be performed is termed as Job Eva

Explain general strategies in the business buying decision, Describe the ei...

Describe the eight general strategies in the business buying decision process

Evolutipn of operation management, discuss the evolution of operations mana...

discuss the evolution of operations management in the last 10 years

What are advantages of using delegated sourcing strategies, What are the ad...

What are the advantages of using delegated sourcing strategies? Advantages of using delegated sourcing: a. Expertise of outsourcer as an example of core skills the organi

Explain the essence of project management is risk management, Consider the ...

Consider the following statement: "The essence of project management is risk management." What does it mean in terms of completing a project successfully? Support your response wit

How marketing consultant brought in to help a company, Imagine you are a ma...

Imagine you are a marketing consultant brought in to help a company who has a product that is so successful they cannot keep up with customer demand. What questions would you as

Assignment, #question.Opration system of the garments manufacture of bangla...

#question.Opration system of the garments manufacture of bangladesh.

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