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

Typical financial performance measures, Typical Financial Performance Measu...

Typical Financial Performance Measures  Profitability - Profit margin, return on capital invested, return on equity Liquidity - Current ratio, cash position, working ca

What is grapevine, What is Grapevine? Ans: Grapevine is an informal ...

What is Grapevine? Ans: Grapevine is an informal communication system.

How to evaluate targets for acquistion, What do you think are the criteria ...

What do you think are the criteria a firm should use to evaluate targets for acquistion and how should a company plan and undertake its merger acquistion strategic initiatives?

Define performance appraisal, Define performance appraisal. Performanc...

Define performance appraisal. Performance Appraisal:   It is a systematic and impartial assessment of an employee's performance on the job, along with a view to discovering ho

View of the cell used by jobs - process design, View of the Cell Used By Jo...

View of the Cell Used By Jobs - Process Design This figure gives a close-up view of the cell used by Jobs 1 and 2. Notice that neither of the jobs uses all of the processes in

Explain the skills of an engineer and an engineer manager, Compare the skil...

Compare the skills of an engineer and an engineer manager

Calculate a tracking signal for months, The following are monthly actual an...

The following are monthly actual and forecast demand levels for May thru December for units of a product manufactured by the N. Tamimi Pharmaceutical Company: Month Actual Deman

Explain the concept of globalization many businesses operate, Based on the ...

Based on the concept of globalization, many businesses operate and compete in a global environment. Describe the additional factors that affect/impact global supply chains.

Goldratt - theory of constraints, Goldratt - Theory of Constraints 1 i...

Goldratt - Theory of Constraints 1 identify the systems constraints  2 exploit the systems constraints  3 subordinate everything else to the above decision  4 elevate

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