Create a query that will select customers

Assignment Help Management Information Sys
Reference no: EM131301529 , Length:

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to location picking or harvesting different crops, such as strawberries, grapes, watermelons, cantaloupe, oranges, grapefruit, and apples, among others. Unlimited Pickers has been in business for a few years, but has seen demand skyrocket in recent months (cf. recent legislation in Alabama to reduce the number of undocumented foreign workers). (All workers for Unlimited Pickers are either U.S. citizens or are legally authorized to work in the U.S.; Unlimited Pickers tries to help their workers complete the legal work-permit process.)

Customers, i.e., the farms who want to hire Unlimited Pickers teams, pay a small fee to the organization to reserve one or more teams of pickers. The workers are paid based on the quantity of the produce that they harvest, typically by the pound. (Note that some customers are large organizations, while others are quite small in the amount of produce grown.)

Unlimited Pickers would like for you to assist with the creation of a database program to help better manage their data and will include several queries. Some test data has been pulled from their paper-based business records and placed into a spreadsheet for you to use in designing and building the database. (The spreadsheet file is: HW 6 - Unlimited Pickers.)

Specifically they need for you to do the following:

1. Create the database, including loading the data from the spreadsheet into Access and establishing the Relationships. Label the database with your last name and HW#6

2. Create a query that will select records for customers who had their first pickup in July 2011. Sort into alphabetical order by Business Name. Save the query as July 2011 - First Picking Query.

3. Create a query that will select customers who had less than 10 pounds of produce picked for Grapes, Watermelons, or Strawberries. The query should include the Service Date, Customer Number, Business Name, Street, City, State, Zip, and the Weight fields from those attributes. Sort into ascending order by Customer Number. Save the query as Low Volume Query.

4. Create a query to determine the total weights of all produce picked for each customer (by type and total). This should include all produce for a customer. Sort by Business Name. Save the query as Customer Total Weight Query.

5. Create a query to calculate the payment for each picking for grapes and strawberries. Include the Business Name, Picking Date (ascending), and the Weight and value for both types of produce. Save the query as Produce Value Query.

6. Create a query and a report to calculate the total payment for apples and watermelon for each customer. Include the Business Name (ascending) and the payments. In the report, break it out by state.

Attachment:- Access hw.xlsx

Verified Expert

In this assignment a MS Access file is created from the Excel file. The data in excel file is imported into the access file. Three sheets in the excel file is imported into tables in the access file. Three tables are created in the access file are Customers, Picking records and pay scales. The data type of each attribute is updated to reflect the change. Th relationship between tables is established. Then 5 select queries are written namely, July 2011 – First Picking Query, Low Volume Query, Customer Total Weight Query, Produce Value Query and Total payment . These queries are written and stored separately in queries. The report is constructed for the total payment of apples and watermelon of each customer.

Reference no: EM131301529

Questions Cloud

The economics of labor markets : Develop a 15- to 20-slide Microsoft® PowerPoint® presentation to be presented to the CEO's executive committee that addresses how your chosen organization determines what quantity of labor to demand and what events could shift the demand and suppl..
Explain how the current situation with amelia has come about : Using the theory of psychological contracting, explain how the current situation with Amelia has come about. Explain the lessons the management of Femme Fashion should take from your analysis.
Electronic circuit by checking the level of water in tank : Designing a simple Electronic Circuit (Without Micro controller) to switch on /Off water pump(Motor) by checking the level of water in the overhead tank / Bottom Sump and also display the level of Water in the overhead tank
Government crowd outs market for loanable funds : Graphically illustrate and explain the conditions that arise when the government "crowd outs" the market for loanable funds. What does "crowd out" mean in this environment?
Create a query that will select customers : Create the database, including loading the data from the spreadsheet into Access and establishing the Relationships. Label the database with your last name and HW#6 - Create a query that will select records for customers who had their first pickup..
Discuss about the dental caries communities : Discuss about the Dental caries and dental care for children in underserved communities
Modern sector enlargement-modern sector enrichment : 1. Distinguish between economic growth by modern sector enlargement, modern sector enrichment and traditional sector enrichment. For each of the three cases, show what happens to absolute poverty and to relative inequality, using a precise measure..
How does executing this project make your company better : How does executing this project make your company better/different/special? What is the competition doing to solve this problem or add this capability?
Examine the report file and find the device utilization : Use the logic element (LE) device utilization percentage found in the compilation report to compare the size of the designs.

Reviews

inf1301529

12/12/2016 6:46:07 AM

Thanks for complete solution and mainly on time. I did not lose even a single number in this one. I know this is just because of experienced tutors. Can i ask to do some mistakes in it so i get %95 approx marks only :)

inf1301529

12/12/2016 6:44:51 AM

Access Homework 2 For this assignment please update the tables with types and size for entities. Marks will be taken off on the Access assignment. Can you please update the tables with types and size for entities.

len1301529

12/5/2016 6:01:19 AM

I will submit two documents. One with instructions (microsoft word). One with data (excel file). Below I copied information from the file with directions - Create the database, including loading the data from the spreadsheet into Access and establishing the Relationships. Label the database with your last name and HW#6

Write a Review

 

Management Information Sys Questions & Answers

  Discuss cloud computing how would you define it

Discuss cloud computing. How would you define it. What are its essential features. Give examples.

  Web-based networkshow have the internet intranets and

web-based networkshow have the internet intranets and extranets affected the types and uses of data resources available

  Explain iso 9000 and its role in supply chains

Explain ISO 9000 and its role in supply chains. Search the Internet for an example of a company that is ISO 9000 certified and search its website for any reference to why it became certified and/or what that means to its customers. Share your find..

  How many pounds of cargo will you need to carry to achieve

How many pounds of cargo will you need to carry to achieve this maximum? How much do the medical care expenses need to be (at least) for the employee to have to pay the maximum figure, as in the question above?

  Important information about information systemdetails the

important information about information systemdetails the owner was impressed with your presentation last week and are

  Show the impact of technology on customers

Technology Impact and Added Value - Based on assigned readings, other readings, or personal experience, discuss the impact of technology on customers

  Analyze the fundamentals of pki

Suppose you are the Information Security Director at a small software company. Analyze the fundamentals of PKI, and determine the primary ways in which its features and functions could benefit your organization and its information security departm..

  Identify potential sales and department store transactions

Evaluate all relationships of each entity within your database solution using the Crow's Foot notation. Include all data elements, entities, relationships (such as 1:M, 1:1, M:N), and cardinalities for the department store database in your diagram..

  Advantages and disadvantages of real time data

Advantages and Disadvantages of Real Time Data - why it is an advantage/disadvantage to businesses

  Globally expanded companyneed help finding a company that

globally expanded companyneed help finding a company that is not globally expanded and would like to have list of few

  Briefly introduce the company you have chosen to research

Briefly introduce the company you have chosen to research. Summarize the two articles you found in the CSU Online Library. Describe how these companies are using electronic media and e-mail.

  Identify network element that are interrelated and dependent

Isolate one (1) of the difficulties of communicating in the troubleshooting process and recommend one (1) way that the network troubleshooting engineer can do to overcome it. In your response, be sure to indicate the importance of communication at..

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