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 what would you recommend the company, What would you recommend the ...

What would you recommend the company (Rochem Ltd) should do?

Activities relating to analysis and control of activities, Activities relat...

Activities relating to analysis and Control of Activities The next problem after the designing of the production system is the analysis and control of the production system. It

Describe methods to diagnose employee stress, Discuss methods to diagnose e...

Discuss methods to diagnose employee stress and the specific OD (organizational development practitioner) interventions aimed at alleviating it in the workplace.

Explain how is job analysis performed in a company, 1. Compensation systems...

1. Compensation systems vary from company to company, but tend to be similar in design and overall cost within a specific industry. Why would you think this is so? 2. Why is a well

Explain interpret the meaning of the p-value in this problem, Initially, th...

Initially, the mean turnaround time for a stress test was 68 hours. After incorporating changes into the stress-test process, the quality improvement team collected a sample of 50

Explain typical complaints, Do results from the survey illustrate typical c...

Do results from the survey illustrate typical complaints about teams and specifically about team incentive rewards?

Explain virtualization to support pandora''s business growth, Assess the us...

Assess the use of virtualization to support Pandora's business growth while helping the environment.

What is really being marketed in golf equipment, What is really being marke...

What is really being marketed (want satisfied), and who is the target market? 1. Golf equipment 2. College textbook 3. Beauty salon 4. Mouthwash

Supply chains using the order-up-to inventory model, Demand for Caruso's Fr...

Demand for Caruso's Frozen Pizza (CFP) is normally distributed. The demand for CFP averages 400 per day with a standard deviation of 200. Weekly demand (5 days) averages 2,000 unit

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