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 that item as well as a few other items on the return, Tony taxpayer...

Tony taxpayer´s return has come up for audit by the Internal Revenue Service (IRS). He took some deductions this year for an office in his home. Amelio Auditor at the IRS has disal

Two handed process chart and multiple activity charts, Two Handed Process C...

Two Handed Process Chart and Multiple Activity Charts Two-handed process chart  For fixed-position manual processes such as the assembly of small devices, this type of ch

Develop your major negotiation temperaments, Today, you have a meeting with...

Today, you have a meeting with one of the Humanitarian workers (Latisha Jones) concerning raising awareness for drunk driving in your local community. This is the fifth time that y

Activities and advantage that providing facility to customer, Consider the ...

Consider the Gleneagles Hotel in Scotland - it is unique, not part of a chain. It is a six star hotel with world class sports facilities with two championship golf courses, which h

Discuss characteristics of a successful entrepreneur, Analyze the character...

Analyze the characteristics of a successful entrepreneur and determine if you have what it takes to start your own business. Provide specific examples to support your response.

Compute the probability that 5 stolen cars will be recover, According to po...

According to police sources a car with a certain protection system will be recovered 85% of the time. Find the probability that 5 of 7 stolen cars will be recovered.

Find breakeven as well as target profit volume, Happy Ten Produces sports s...

Happy Ten Produces sports socks. The company has fixed expenses of $80,000 and variable expenses of $0.80 per package. Each package sells for $1.60. 1. Compute the contribution mar

Quality control, How did Jim conclude that the process was not capable base...

How did Jim conclude that the process was not capable based on his first set of samples? 2. Does the second set of samples show anything that the first set didn’t? Explain what an

Describe project should be clearly explained, The "ends" of the project sho...

The "ends" of the project should be clearly explained, measured, and communicated, prior to the "means" being decided

Road transportation business, After working for 30 years, Ramjee Somjee Dut...

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 busine

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