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 sql commands that are used for data manipulation, What is the role ...

What is the role of structure query language (SQL) in database object creation and information management in a relational database? Identify three SQL commands that are used for da

Illustrate performance dimensions for operational strategy, Illustrate the ...

Illustrate the performance dimensions for operational strategy? Performance dimensions for operational strategy: • Quality for illustrations Marks and Spencer, Thornton’s,

Explain internal resources and capabilities, Analyze Procter & Gamble's (Ca...

Analyze Procter & Gamble's (Case 8) resources and capabilities as well as its structures and systems. Internal resources and capabilities. How should P&G's strengths be leverage

Explain another name for a cause-and-effect diagram, Another name for a cau...

Another name for a cause-and-effect diagram is which of the following? Histogram Run chart Check sheet Fishbone diagram

Explain unethical for advertisers to pitch products, Do you feel it's uneth...

Do you feel it's unethical for advertisers to pitch products to patients and students in this fashion? why?

Explain create problems for inventory management, To be more competitive, m...

To be more competitive, many fast-food chains began to expand their menus to include a wider range of foods. Although contributing to competitiveness, this has added to the complex

Linear trend equation, A cosmetics manufacturers marketing department has d...

A cosmetics manufacturers marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand and Foot Cream. We are given F sub

What are pros as well as cons of updating the product design, Since its rel...

Since its release in 2001, the iPod has become a music player phenomenon. In your opinion, how would the QFD approach have helped Apple in developing the iPod? What are the limi

Explain agreement by union and management, How does the threat of a strike ...

How does the threat of a strike (or actual strike) affect the negotiating process and its tendency to bring about conditions necessary for agreement by union and management?

Explain what are the privacy requirements under hipaa, What are the privacy...

What are the privacy requirements under HIPAA? Explain why confidentiality of health information has been a controversial public policy issue. Give a real world example. How can he

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