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 describe your findings as frequencies, Poll a small sample of class...

Poll a small sample of class members, work associates, or friends and ask them to answer the following in a paragraph or two: "What are your career aspirations for the next five

Ethical for organizational managers to try to get access, Do you belive it ...

Do you belive it is ethical for organizational managers to try to get access and scrutinize the Facebook pages of employees or job applicants?

Explain interest expenses and taxes, A company's net income depends on all ...

A company's net income depends on all of the following except a. amount of sales b. cost of goods sold c. interest expenses and taxes. d. inventory estimates

Describe assaults a waitress at a nearby restaurant, A company hires a file...

A company hires a file clerk but does not inquire into his criminal history. In fact, he has had several convictions for driving while intoxicated. On a lunch break, he gets drunk

Case study, After working for 30 years, Ramjee Somjee Dutt opted for VRS an...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busin

What are complexities and risks involved with supply chains, Given the comp...

Given the complexities and risks involved with supply chains, might it make sense for a business organization to vertically integrate and be its own supply chain? Why or why not?

Scheduling - production control, Scheduling Meaning and Definition ...

Scheduling Meaning and Definition Scheduling is the next technique of production control. In production control scheduling  means  the  arrangement of different operatio

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