Order Now

Access database creating queries | Information Systems homework help

Uncategorized

Shipping Efficiency Query

You will create a query to calculate the number of days between the date an order was placed and the date the order was shipped for each order. The result of your work will be a list of orders that took more than 30 days to ship. The salespeople will be required to review the records and report the source of the delay for each order. The CEO feels there may be issues with one of the shipping companies, and would like data to back that up.

  • a.Create a query using Query Design. From the Customers table, include the fields CompanyName, ContactName, ContactTitle, and Phone. From the Orders table, include the fields OrderID, OrderDate, and ShippedDate.
  • b.Run the query and examine the records. Save the query as Shipping Efficiency.
  • c.Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: The expression will include the OrderDate and the ShippedDate; the results will not contain negative numbers.)
  • d.Run the query and examine the results. Does the data in the DaysToShip field look accurate? Save the query.
  • e.Add criteria to limit the query results to include only orders that took more than 30 days to ship.
  • f.Add the Quantity field from the Order Details table and the ProductName field from the Products table to the query. Sort the query by ascending OrderID. When the sales reps contact these customers, these two fields will provide useful information about the orders.
  • g.Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the results. Adjust column widths as necessary.
  • h.Save and close the query.

Order Summary Query

The CEO is considering the financial impact of discounts. She asked for a query showing the employee name, number of orders they have taken, and the total discount amount they have given customers. She hopes to see if there is a correlation between the discount offered and the number of sales.

  • a.Create a query using Query Design and add the Orders, Order Details, Products, and Customers tables. Add the fields OrderID and OrderDate from the Orders table. Set both fields’ Total row to Group By.
  • b.Add a calculated field in the third column. Name the field ExtendedAmount. This field should multiply the quantity ordered (from the Order Details table) by the unit price for that item (from the Products table). This will calculate the total amount for each order. Format the calculated field as Currency and change the caption to Total Dollars. Change the Total row to Sum.
  • c.Add a calculated field in the fourth column. Name the field DiscountAmount. The field should multiply the quantity ordered, the unit price for that item, and the discount field (from the Customers table). This will calculate the total discount for each order. Format the calculated field as Currency and add a caption of Discount Amt. Change the Total row to Sum.
  • d.Run the query. Examine the results. Most customers should have a discount of 10% of the total dollars, but some customers will have no discount. Save the query as Order Summary. Return to Design view.
  • e.Add criteria to the OrderDate field so only orders made between 1/1/2016 and 12/31/2016 are displayed. Change the Total row to Where. This expression will display only orders that were placed in 2016.
  • f.Run the query and view the results. Adjust column widths as necessary. Save and close the query.

Order Financing Query

The CEO would like the salespeople to discuss financing with customers. In order to do so, she would like you to create a query showing the impact on price for prior orders. This way, the reps can give customers a comparison with an order they have already placed. For the moment, she is considering a 5% interest rate, paid over 12 months. She would like you to leave the results as negative numbers.

  • a.Create a copy of the Order Summary query named Order Financing.
  • b.Open the Order Financing query in Design view and remove the DiscountAmount field.
  • c.Add a new field using the Expression Builder named SamplePayment. Insert the Pmt function with the following parameters:
    • •Use .05/12 for the rate argument (5% interest, paid monthly).
    • •Use the number 12 for the num_periods argument (12 months).
    • •Use the calculated field [ExtendedAmount] for the present_value.
    • •Use the value 0 for both future_value and type.
  • d.Change the Total row to Expression for the SamplePayment field.
  • e.Change the Format for the SamplePayment field to Currency.
  • f.Run the query and examine the results. Adjust column widths as necessary. The results appear as negative numbers, as requested. Save and close the query.

Order Summary by Country Query

The company is planning on opening up some shipping centers internationally. The previous CEO had been considering Brazil, Denmark, and Germany as potential shipping center locations, but he was working from older data. You will provide a list of total shipment value by country for the year before the current CEO started to best inform her decision making.

  • a.Create a copy of the Order Summary query named Order Summary by Country.
  • b.Open the query in Design view. Replace the OrderID field with the Country field from the Customers table.
  • c.Run the query and examine the summary records; there should be 21 countries listed.
  • d.Switch to Design view and change the sort order so that the country with the highest ExtendedAmount is first and the country with the lowest ExtendedAmount is last.
  • e.Run the query and verify the results. Note the ExtendedAmount field has a caption of Total Dollars, so this is the field the query will be sorted by.
  • f.Save and close the query.
Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

July 1, 2023
    

 

Use the Internet and / or the Strayer Learning Resource Center to research aspects of biology.

Select an article from a magazine or newspaper that has something in it that pertains to biology. This will serve as the “target article” for this assignment. For instance, you can select an article about medicine, invasive species, nature, conservation, genetic technology, ecology, or any other topic that is related to biology. One purpose of this assignment is to help you become aware of how biology is related to your everyday life.

Write a one to three (1-3) page paper in which you:

  1. Summarize the article in one (1) or more paragraphs, using your own words. Be sure to identify the article using an in-text citation in the body of the paper, as well as a reference in the reference section. 
  2. Explain how the article relates to this course. Identify which biological concepts from the course and / or text are relevant to the topic covered in the article. Citing the course text, discuss the ways in which this course does (or doesn’t) provide background information to help you understand the article and the larger issues surrounding it. 
  3. Explain why the article caught your attention. Relate the article to your life and to issues that are important to you. Discuss how or if the scientific knowledge about the topic covered in the article affects you directly or indirectly.
  4. Discuss your opinion on how research on this topic should be funded. State whether you think taxpayer monies should support research on this topic or whether such research in this area should be funded by the private sector. Rate the importance of research on this topic, relative to other areas of research. 

In addition to the target article, you should use at least one additional resource, such as your textbook or another article. You must have a reference section which contains an APA reference to your chosen article and all other sources. Additionally, you must provide in-text citations (in APA format) to your references in the body of the text. Integrate all sources into your paper using proper techniques of quoting, paraphrasing and summarizing, along with your in-text citations.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Use technology and information resources to research issues in biology.
  • Write clearly and concisely about biology using proper writing mechanics.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills. 

Click to view the grading rubric.

*This is the topic i am using* https://www.sciencedaily.com/releases/2018/01/180118084554.htm

default image
July 1, 2023
    

 

Use the Internet and / or the Strayer Learning Resource Center to research aspects of biology.

Select an article from a magazine or newspaper that has something in it that pertains to biology. This will serve as the “target article” for this assignment. For instance, you can select an article about medicine, invasive species, nature, conservation, genetic technology, ecology, or any other topic that is related to biology. One purpose of this assignment is to help you become aware of how biology is related to your everyday life.

Write a one to three (1-3) page paper in which you:

  1. Summarize the article in one (1) or more paragraphs, using your own words. Be sure to identify the article using an in-text citation in the body of the paper, as well as a reference in the reference section. 
  2. Explain how the article relates to this course. Identify which biological concepts from the course and / or text are relevant to the topic covered in the article. Citing the course text, discuss the ways in which this course does (or doesn’t) provide background information to help you understand the article and the larger issues surrounding it. 
  3. Explain why the article caught your attention. Relate the article to your life and to issues that are important to you. Discuss how or if the scientific knowledge about the topic covered in the article affects you directly or indirectly.
  4. Discuss your opinion on how research on this topic should be funded. State whether you think taxpayer monies should support research on this topic or whether such research in this area should be funded by the private sector. Rate the importance of research on this topic, relative to other areas of research. 

In addition to the target article, you should use at least one additional resource, such as your textbook or another article. You must have a reference section which contains an APA reference to your chosen article and all other sources. Additionally, you must provide in-text citations (in APA format) to your references in the body of the text. Integrate all sources into your paper using proper techniques of quoting, paraphrasing and summarizing, along with your in-text citations.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Use technology and information resources to research issues in biology.
  • Write clearly and concisely about biology using proper writing mechanics.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills. 

Click to view the grading rubric.

*This is the topic i am using* https://www.sciencedaily.com/releases/2018/01/180118084554.htm

default image
July 1, 2023
    

 

Use the Internet and / or the Strayer Learning Resource Center to research aspects of biology.

Select an article from a magazine or newspaper that has something in it that pertains to biology. This will serve as the “target article” for this assignment. For instance, you can select an article about medicine, invasive species, nature, conservation, genetic technology, ecology, or any other topic that is related to biology. One purpose of this assignment is to help you become aware of how biology is related to your everyday life.

Write a one to three (1-3) page paper in which you:

  1. Summarize the article in one (1) or more paragraphs, using your own words. Be sure to identify the article using an in-text citation in the body of the paper, as well as a reference in the reference section. 
  2. Explain how the article relates to this course. Identify which biological concepts from the course and / or text are relevant to the topic covered in the article. Citing the course text, discuss the ways in which this course does (or doesn’t) provide background information to help you understand the article and the larger issues surrounding it. 
  3. Explain why the article caught your attention. Relate the article to your life and to issues that are important to you. Discuss how or if the scientific knowledge about the topic covered in the article affects you directly or indirectly.
  4. Discuss your opinion on how research on this topic should be funded. State whether you think taxpayer monies should support research on this topic or whether such research in this area should be funded by the private sector. Rate the importance of research on this topic, relative to other areas of research. 

In addition to the target article, you should use at least one additional resource, such as your textbook or another article. You must have a reference section which contains an APA reference to your chosen article and all other sources. Additionally, you must provide in-text citations (in APA format) to your references in the body of the text. Integrate all sources into your paper using proper techniques of quoting, paraphrasing and summarizing, along with your in-text citations.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Use technology and information resources to research issues in biology.
  • Write clearly and concisely about biology using proper writing mechanics.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills. 

Click to view the grading rubric.

*This is the topic i am using* https://www.sciencedaily.com/releases/2018/01/180118084554.htm

default image
Essay (any type)
August 22, 2022
    

They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.

 

default image
Customer #32567
Zoology, 8 Pages
Case study
August 22, 2022
    

Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.

default image
Customer #30093
Biology (and other Life Sciences), 6 pages
Presentation/PPT
August 22, 2022
    

The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.

default image
Customer #37612
Computer science, 8 pages
Journal article
August 22, 2022
    

My third using this writer and absolutely amazing work! Very punctual and very understanding.

default image
Customer #34820
Agriculture, 4 pages
Article
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #17907
Technology, 5 pages
Thesis/Thesis chapter
August 22, 2022
    

I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!

default image
Customer #32146
Economics, 9 pages
Research paper
August 22, 2022
    

It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.

default image
Customer #22371
Ecology, 5 pages
Lab Report
August 22, 2022
    

Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again ❤️

default image
Customer #13712
Nursing, 6 pages
Outline
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #267302
IT, Web, 6 pages
Essay (any type)
August 22, 2022
    

Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!

default image
Customer #14472
International Trade, 8 pages
Essay (any type)
August 5, 2021
    

You are making my life so much easier! I am a single mom that works and goes to school. You guys are helping me with my projects so I can have more free time with my son.

default image
customer #13832
Tourism, 3 pages
Annotated Bibliography
August 5, 2021
    

I was sure it can fit in a single page but the next time I will add one more page because I am impressed with your professionalism and quality. Will use many more times till I graduate.

default image
customer #12008
Management, 7 pages
Essay (any type)
August 5, 2021
    

Simple registration and quality services. I just ordered one paper, and it was good enough to pass the exam. That is what I need the most. Good job.

default image
customer #16257
Communication, 4 pages
Research Proposal
August 5, 2021
    

I couldn’t finish my freaking essay, and I was very desperate. A friend of mine sent me a link, and that is how I found out about you guys. Thank you for professional tips and editing. Now, I understand how to write it properly.

default image
customer #17128
Law, 5 pages
Reflection
August 5, 2021
    

I’m so grateful to you since you managed to complete my term paper in one day! You are definitely the best company ever!

default image
customer #16528
Public Relations, 7 pages
Essay (any type)
August 5, 2021
    

I am sure on your ability to provide any type of paper I will order. I wish I could develop that skill your writers have to be able to have a flow of ideas and excellent sequencing of thoughts in writing.

default image
customer #19552
Medicine, 5 pages
Coursework
August 5, 2021
    

I ordered a thesis paper and was satisfied. All the guys were polite and highly professional, even when I wrote to them several times per day. Thanks for your passion!

default image
customer #20376
Nursing, 6 pages
Discussion Essay
August 5, 2021
    

I turned to the service twice, and my papers always were beyond the expectations. To tell the truth, I was ready to find some grammar errors or something like that. However, everything was neat and tidy.

default image
customer #18529
Marketing, 1 page
August 5, 2021

My friend recommended Doctor My Essay to me. It is convenient! Now we both turn to the service periodically coz wanna save some time and use it more effectively. I know that while I’m developing my startup, an expert is working on paper. Time management in work!

default image
Research Paper
August 5, 2021
    

I write all paper works by myself but have some problems with literacy. Actually, I have enormous problems because English is not my native language. However, with proofreading from Doctor My Essay, I can relax and don’t be ashamed of mistakes.

default image
customer #12924
Business, 7 pages
Argumentative Essay
August 5, 2021
    

Your ability to write concisely is a finding. The paper has a solid argument. It’s clear that the writer understood central claim about the topic. He also presented original ideas to consider.

default image
customer #19304
Management, 3 pages
Coursework
August 5, 2021
    

That paper got the highest grade in my class and the professor thinks I’m the smartest student. Lol.

default image
customer #12387
Accounting, 6 pages
Essay (any type)
August 5, 2021
    

I was convinced that paper writing services are the fiction for naive students. But when it came to my research paper that was to be composed in 72 hours, I had no other options. I made the right choice when I ordered it from you!

default image
customer #12924
Ethics, 4 pages
Business Plan
August 5, 2021
    

I was also satisfied with the service. Usually, I write everything by myself, but this time ( I have no idea how it happens!) I missed the deadline. My writer was very responsible, wrote the essay quickly, and kept the instructions. Nice to know that such experts exist!

default image
customer #15677
Marketing, 10 pages
Annotated Bibliography
August 5, 2021
    

It is really affordable! The prices start from 9$, which is an excellent proposal on the market. Recently I worked with another service that took much more money and provided lower quality papers.

default image
customer #11234
Sociology, 9 pages
Research proposal
August 5, 2021
    

I am absolutely satisfied. I am first timer here. Revision was made quickly, and the author met my expectations. Thanks a lot. Paper is phenomenal.

default image
customer #15327
Economics, 5 pages
Essay (any type)
August 5, 2021
    

Having heard a lot of negative reviews about such services, I was a bit skeptical. However, our cooperation with Doctor My Essay was without pitfalls. I made two comments about the final work, and they re-wrote some parts very promptly. I am satisfied and will turn to them in the future.

default image
customer #17823
Human Resource Management, 2 pages
Research paper
August 5, 2021
    

It was my first experience in online ordering, and I was a bit nervous. However, this was for nothing. I’ve got a high mark!

default image
customer #12372
Public Relations, 3 pages
Dissertation
August 5, 2021
    

I understand that buying essays is a doubtful thing. You don’t put effort, don’t represent your ideas… However, I don’t perceive Doctor My Essay as a standard service. They don’t sell papers. They share high expertise!

default image
customer #12376
Journal article, 20 pages
Coursework
August 5, 2021
    

According to my previous experience, this service is really the best. They support the client and have competitive writers. I give them a perfect score!

default image
customer #19266
Political Science, 6 pages
Admission Essay
August 5, 2021
    

Nice service! It is cool that you can use the calculator on the main page and understand the price policy. For me, it is a huge plus!

default image
customer #11437
Tourism, 1 page
Discussion Essay
August 5, 2021
    

Thanks to God I found this service! If I didn’t send my research to the teacher on time, he would eat me. I tell you! However, with doctor my essay service, I met the deadline, and I am still alive.

default image
customer #12692
Philosophy, 5 pages
Report
August 5, 2021
    

Your service is excellent! Convenient and not expensive. Thanks for that!

default image
customer #10923
Psychology, 4 pages
Essay (any type)
August 5, 2021
    

If you have problems with time management, just like me, you need to cooperate with Doctor My Essay. Once you registered and made the order, you understand how easier it makes your life! Everything is online: ordering, communication… You can control the process everywhere and be sure that an expert will provide a high-level paper.

default image
customer #17823
Business, 8 pages

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more