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

After working for 30 years, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did

Explain messages are transmitted from low speed terminals, Messages are tra...

Messages are transmitted from low speed terminals and arrive at a message concentrator at a Poisson rate of 600/hr. They are held in a buffer until a hi-speed trunk line is free to

Explain the case of the marginalized workers, The Problem: The Case of the ...

The Problem: The Case of the Marginalized Workers You have decided to sub-contract out your grounds maintenance work. You have solicited bids for landscaping, a revamped irrigat

MBA 2ND SEM, Q3. What do you understand by “line balancing”? What happens i...

Q3. What do you understand by “line balancing”? What happens if balance doesn’t exist?

Describe specific strategies, What challenges may arise if a U.S. project m...

What challenges may arise if a U.S. project manager moves to a foreign country to manage a project for 5 years? Discuss specific strategies that the U.S. project manager could use

Explain the elements of an organizations environment, Describe the elements...

Describe the elements of an organization's external environment. Why is it important to understand the external environment?

Explain how will learning managerial problem solving help, How will learnin...

How will learning managerial problem solving help you later in life in you job?

Explain expected learning curve, A time standard was set as 0.20 hour per u...

A time standard was set as 0.20 hour per unit based on the 50th unit produced. If the task has a 90 percent learning curve, what would be the expected time of the 100th, 200th, and

Ppc in mass and flow production system, PPC in Mass and Flow Production Sys...

PPC in Mass and Flow Production System Continuous  production  is the  specialized  manufacturing  of identical  articles on which  the equipment  is  fully  engaged. Continuo

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