Order Now

Go16_ac_ch02_grader_2g_as- concerts and sponsors | Information Systems homework help

Uncategorized

1

Start Access. Open the downloaded file named go_a02_grader_a3_Concerts_Sponsors.accdb, and then enable the content.

0

2

Using Sponsor ID as the common field, create a one-to-many relationship between the Sponsors table and the Concerts table. Enforce referential integrity and enable both cascade options. Create a relationship report with normal margins, saving it with the default name. Close all open objects.

10

3

In the last record of the Sponsors table, change the Sponsor ID from SPONSOR-108 to SPONSOR-100, and then close the table. (The related records in the Concerts table will automatically update.)

1

4

Copy the Concerts $1000 or More Query to create a new query with the name Jan-Apr Concerts Query. Redesign the query so that the following fields display in the order given: Date, Concert Name, Concert Location, and Box Office Receipts. Sort the records in ascending order only by the Date field. Do not restrict the results by Box Office Receipts. Set the criteria so that when you run the query only those records display for a date between 1/1/19 and 4/30/19. Run the query (five records display). Close the query, saving the changes to the query.

10

5

Create a query in Query Design view based on the Concerts table. Add the following fields to the design grid in the order given: Date, Concert Name, Concert Location, and Box Office Receipts. Sort the records in ascending order by the Date field. Set the criteria so that when you run the query only those records display for a concert location of Georgetown Community Theater or Austin City Center and for box office receipts that have an amount that is greater than 1000. Run the query (four records display). Save the query as GCT OR ACC Over $1000 Query, and then close the query.

10

6

Create a query in Query Design view based on both tables. Add the following fields to the design grid in the order given: Sponsor Name, Concert Name, and Concert Location. Sort the records in ascending order by the Concert Location field. Set the criteria so that when you run the query only those records display for a sponsor name that has radio anywhere in its name and for a concert name that ends in festival. Run the query (two records display). Save the query as Radio Festivals Query, and then close the query.

10

7

Create a query in Query Design view based on the Concerts table. Add the following fields to the design grid in the order given: Concert ID, Concert Name, Concert Location, Sponsor ID, and Date. Set the criteria so that when you run the query only those records display that are missing the date. Run the query (two records display). Save the query as Missing Concert Date Query, and then close the query.

10

8

Create a query in Query Design view based on both tables. Add the following fields to the design grid in the order given: Concert ID, Sponsor Name, and Box Office Receipts. Sort the records in ascending order by the Concert ID field. In the fourth column of the design grid, create a new field named Sponsor Donation that will calculate and display the donation amount when the Sponsor donates an amount equal to 50 percent (0.5) of each box office receipts amount to the Music Department. Run the query (the second record—EVENT-102—has a Sponsor Donation of 287.5).

10

9

Display the query in Design view. In the fifth column of the design grid, create a new field named Total Donation that will calculate and display the total donation when the box office receipts amount is added to the sponsor’s donation amount. Run the query (the second record—EVENT-102—has a Total Donation of $862.50).

3

10

Display the query in Design view. Use the Property Sheet to format the Sponsor Donation field as Currency with 2 decimal places, and then close the Property Sheet. Run the query, apply Best Fit to the fields, save the query as Sponsor Donation Query, and then close the query.

6

11

Create a query in Query Design view based on the Concerts table. Add the following fields to the design grid in the order given: Concert Location and Box Office Receipts. Sort the records in descending order by the Box Office Receipts field. Sum the Box Office Receipts field. Use the Property Sheet to format the Box Office Receipts field with 0 decimal places, and then close the Property Sheet. Run the query (for the Concert Location of Georgetown Community Theater, the sum of the box office receipts is $7,850). Apply Best Fit to the fields, save the query as Receipts by Location Query, and then close the query.

10

12

Use the Query Wizard to create a crosstab query based on the Concerts table with the Sponsor ID field as row headings and the Concert Location field as column headings. Sum the Box Office Receipts field, and name the query Sponsor and Location Crosstab Query. Display the query in Design view. Use the Property Sheet to format the last two columns with 0 decimal places. Run the query, apply Best Fit to the fields, save the query, and then close the query.

10

13

Create a query in Query Design view based on the Concerts table. Add the following fields to the design grid in the order given: Concert Name, Concert Location, Box Office Receipts, and Sponsor ID. Sort the records in ascending order by the Concert Name field. Set the criteria so that when you run the query you are prompted to Enter the Sponsor ID in the format SPONSOR-###. Run the query, and when prompted, enter SPONSOR-101 as the criteria (six records display). Display the query in Design view and hide the Sponsor ID field from the results. Run the query again, entering SPONSOR-101 when prompted. Save the query as Sponsor ID Parameter Query, and then close the query.

10

14

Be sure that all database objects are closed, open the Navigation Pane, and then close Access. Submit the database as directed.

0

 

Total Points

100

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