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 breakeven point in dollars of sales, A firm is selling two products...

A firm is selling two products, chairs and bar stools, each at $50 per unit. Chairs have a variable cost of $25 and bar stools $20 Fixed cost for the firm is $200 a. if the sales m

Explain graph based layout construction method, Is the Graph based layout c...

Is the Graph based layout construction method always produces maximally Planar Graph & Maximally Planar weighted graph?

What are the factors to effect capacity levels, What are the factors to eff...

What are the factors to effect capacity levels? Factors effecting capacity levels are as follows: • Resources accessible for example, labour and skills, machine time and

Resource allocation and Contingency planning, What are those topics all abo...

What are those topics all about? Can you give me a summary of that in a clear and understandable explanation. Thank you so much!

Define helping the organization achieve its strategic intent, HR planning s...

HR planning should be focused on helping the organization achieve its strategic intent, which derives from its vision. These strategies need to both service the short-term, operat

Explain this in relevance to uncertain events, Imagine the difficulties of ...

Imagine the difficulties of an employer whose decision context is choosing a new employee from a set of applicants whom he will interview. What do you think the employer's objectiv

Explain marketing to stakeholders and stockholders, What is the value of ma...

What is the value of marketing to the consumer, the stakeholder and stockholder and a. the value of your place on marketing b. the value of marketing to customers and consumers c.

Can someone help describe what to do, I feel like there is not enough infor...

I feel like there is not enough information to even start. Can someone help explain what to do? Maybe if I can start, then I can do the rest on my own.

MGT, #queDiscuss an example of a work-related project that is able to be br...

#queDiscuss an example of a work-related project that is able to be broken down into structure, tasks, subtasks, and work packages, and why project management in the form of a CPM/

Difference between business and operations strategy, What is the difference...

What is the difference between business and operations strategy?  Answer: There is a hierarchy of strategic decision making, each focused on a different time horizon and at vary

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