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

Operation Management and POM QM sums , The assignment consists of 3 exercis...

The assignment consists of 3 exercises, and the marks for each question varies. Printouts provided with the prose solutions and explanation of the POM-QM solutions must be original

Formulate an integer programming model using excel solver, New fire station...

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into

Define which of the following are valid range names in excel, Which of the ...

Which of the following are valid range names in Excel? Total Profit TotalProfit Total_Profit All of these b and c only

Courtesy - customer satisfaction and service quality, Courtesy - Customer S...

Courtesy - Customer Satisfaction and Service Quality Involves politeness, respect, consideration and friendliness of contact personnel (including receptionists, telephone oper

Explain what is the union relations environment, What is the union relation...

What is the union relations environment today and what are the future trends in labour relations?

Explain total complaints represented by the two mos, See data table below: ...

See data table below: This is a 6 month period for a grocery store. Construct a Pareto analysis of the data and determine the percentage of total complaints represented by the two

Explain product in an overseas market, How would you go about establishing ...

How would you go about establishing your company and your product in an overseas market?

The best alternative is to build large wing, Chris Suit is administrator fo...

Chris Suit is administrator for Lowell Hospital. She is trying to determine whether to build a large wing on the existing hospital, a small wing or no wing at all. POPULATION TR

Explain graphic project report used in project management, Which of the fol...

Which of the following is a graphic project report used in project management?

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