Description
I wish to make the best articles for my clients,,how?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
hi, i can give you the tips.please let me know.
Completion Status:
100%
Review
Review
Anonymous
Really helped me to better understand my coursework. Super recommended.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
AB 299 Indiana University Purdue University Coffee Business Paper
Assignment 1: Choosing a Global SupplierIn order for Tim’s Coffee Shoppe to be successful, Tim will have to be sure he h ...
AB 299 Indiana University Purdue University Coffee Business Paper
Assignment 1: Choosing a Global SupplierIn order for Tim’s Coffee Shoppe to be successful, Tim will have to be sure he has a consistent and reliable supply of coffee beans.Research coffee bean producing countries on the Internet. Choose one country, along with a grower, that would have the greatest supplier potential to import beans for domestic sales with your distribution firm.View the map or view the explanation of the map. Most coffee grows within the equatorial band known as the Coffee Belt. This picture will help you decide where you want to start your research.Write your original, double-spaced expository essay in a minimum of 4 pages (which includes a Title and a References page) and use 12-point Times New Roman font. Your citations (minimum one (1), and maximum two (2) short scholarly citations) and references must follow APA format and citation style. Checklist: Address the following items in an expository essay and APA format and citation style: Choose a country and a grower for your supplier of coffee beans that you (as distributor) can then sell.What are the economic advantages of dealing with a vendor from this country?Does the country have environmental laws that align with those of our country? What are they?Will there be a marketing advantage by divulging the source of the coffee beans? Why or why not?Will sourcing the beans from the supplier you choose affect Tim’s bottom-line or not? Discuss your reasoning. Use a minimum of one and maximum of two short scholarly citations and references.Access the Assignment 1 rubricSubmit your response to the Assignment 1 Dropbox.
Recruitment and Hiring Practices
Case Study Analysis: Recruitment and Hiring PracticesThis case study analysis assesses the following outcomes:MT203-2: Exa ...
Recruitment and Hiring Practices
Case Study Analysis: Recruitment and Hiring PracticesThis case study analysis assesses the following outcomes:MT203-2: Examine the recruitment and selection process.PC-4.3: Apply concepts of multiculturalism and diversity to become an agent of change.You have read about recruiting and selection processes used in various companies as well as practiced with some of those concepts. Now you will apply your understanding of these concepts to a case scenario and then address the checklist items.To assist you with this and other case studies in this class, a document entitled “Case Study Analysis,” is in Course Documents and can be downloaded for your reference. This document, and many other invaluable writing resources, can also be found at the Writing Center.Case Scenario:A Silicon Valley recruiting firm recruits artificial intelligence (AI) and technology personnel. The recruits workplace could be located anywhere the company operates, depending on their skills and expertise, although the tendency is to hire in-country nationals in each respective country. The company uses technology-oriented magazines, the company website, and social media to recruit the candidates they need for their clients. They started up about a year ago and went from 3 recruiters to 50 overnight. Their recruiters are hired for their charm, communication skills, and industry expertise, however most of the recruiters graduated from Ivy League colleges in the U.S. and most are white males. Lately recruiting numbers have been slowing down drastically while general demand in the marketplace by employers for AI and technology personnel for the coming year is up 300%.The current recruiting practice involves hiring people via their website recruitment area. The potential candidate merely attaches their resume and includes a short note to the recruiter. These resumes are then screened using a data mining program looking for certain criteria and terminology in their resumes. Once screened, those candidates getting through the initial screening are then auto-contacted by email to tell them they need to complete the question/quiz accessed on the website using a particular password. If they pass this second screening they are given an individual interview via the company’s online conference room. Once completed, the final candidates are finally sent to the potential employer for the final interview and selection.Now however, the president is getting complaints from the EEO Commission and the Technology firms that they need to be hiring a more diverse workforce and that there are no ADA candidates, and the number of minorities and women is almost nil. He is now worried about losing clients and potential lawsuits as a result of their recruiting and selection processes. The company needs to address a diverse client base. Their clients are Northern European, African American, Indian, and Hispanic.Checklist: As the HR specialist of the company, you are tasked with overhauling the selection and hiring process to address the following:Identify problems with the potential candidate characteristics.Analyze the company’s recruitment and selection process and problems.What multicultural and diversity planning concepts would you apply at the company to make a positive change?Describe how you would make that positive change happen.Requirements:Complete a 2–3 page paper (not including the title and reference pages).Answer each checklist question thoroughly.Demonstrate your understanding of the information presented in the weekly reading assignments by defining terms, explaining concepts, and providing detailed examples to illustrate your points.Include at least two references from your reading assignments, or other academic sources, to reinforce and support your own thoughts, ideas, and statements using APA citation style. You can access help with APA by going to Course Resources and accessing the “APA Style Central” resources in Academic Tools.
10 pages
Project Analysis
➢ Customers- Purchasing of goods, demand for certain products, etc. ➢ Suppliers – Inflow of products from the manufa ...
Project Analysis
➢ Customers- Purchasing of goods, demand for certain products, etc. ➢ Suppliers – Inflow of products from the manufacturer, payment requests. ...
Post University Virgin American Case Study
For this question, review the Virgin America short case study at the end of Chapter 5. Prior to 2016, Virgin America was c ...
Post University Virgin American Case Study
For this question, review the Virgin America short case study at the end of Chapter 5. Prior to 2016, Virgin America was consistently rated as one of the top U.S. airlines. It served 20 destinations out of its main hub in San Francisco. Known for its leather seats, cocktail-lounge-style lighting, on board Wi-Fi, in-seat power outlets for electronics devices, full-service meals, and spacious legroom, the key competitive issue the company has been facing is that it is a niche player in a much larger industry where low-cost carriers such as Southwest Airlines and Jet Blue are putting constant pressure on prices and crowding out routes with multiple flights a day. After reviewing the full case, please answer the following questions. What was Virgin America’s segmentation strategy? Whom did it serve?Regarding its core segment, what did Virgin America offer its customers?Using the Porter model, which generic business-level strategy was Virgin America pursuing?What actions, taken at the functional level, enabled Virgin America to implement its strategy?
RTV 3511 CMU The Kinds of Camera Systems Used on The Programs Discussion
For this discussion post you'll need to do a little bit of research (shouldn't be much more than a few google searches). & ...
RTV 3511 CMU The Kinds of Camera Systems Used on The Programs Discussion
For this discussion post you'll need to do a little bit of research (shouldn't be much more than a few google searches). First, you will list your favorite live action feature film, feature length documentary, broadcast television show, and cable or streaming television show. For each of the four that you have list, find out what camera system each one of them was shot on as well as the cost of each one of the cameras.
Step 1: Identify four live-action feature film, documentary, broadcast or cable TV program, and streaming television program. (One in each category.)
Step 2: Research the kinds of camera systems used on each of the programs listed and the costs for those camera systems.
Step 3: Describe the similarities and/or differences between the camera systems used to produce these different kinds of media content.
Step 4: Post your list of programs, the associated camera systems and costs, as well as your observations by Thursday at 11:59 pm.
Step 5: Post a reply to at least one of your classmates posts. You can discuss the similarities/differences between your observations and a classmates as well as make another judgment about how some camera systems appear to be more likely associated with specific kinds of media content.
Reply:
Step 1: Identify four live-action feature film, documentary, broadcast or cable TV program, and streaming television program. (One in each category.)
The Lizzie McGuire Movie, The Social Dilemma, The Walking Dead, Money Heist.
Step 2: Research the kinds of camera systems used on each of the programs listed and the costs for those camera systems.
The Lizzie McGuire Movie: Panavision Panaflex Platinum rentals starts at $1,000 a day- insurance at $300,000-- around around $1M in Liability, Panavision Primo Lenses $500,000-$750,000 to purchase or $4000.00/day to rent. Panavision Panaflex Millennium $1,000 a day- insurance at $300,000-- around around $1M in Liability.
The Social Dilemma: Cameras RED Monstro $79,500 and Red Dragons $22,000 , Lens Sigma FF primes $24,799 and Cooke Anamorphic lenses $36,500
The Walking Dead: ARRIFLEX 416 Camera, Panavision Cameras rentals starts at $1,000 a day- insurance at $300,000-- around $1M in Liability, Panavision Lenses $500,000-$750,000 to purchase or $4000.00/day to rent , Zeizz Super Seeds MK Lenses EBAY used $58,000.
Money Heist: Arri Alexa Mini $58,760, Leitz SUMMILUX-C Lenses (Season 1-2) $39,200- $46,700.
Red Helium $49,500 and Leitz SUMMILUX-C lenses (Season 3-) $39,200- $46,700.
Step 3: Describe the similarities and/or differences between the camera systems used to produce these different kinds of media content.
The similarities between a lot of these camera is for the professionalism of camera use that they go for to use instead of buying so many. The Panvavisions are so elite that mostly you have to rent them out because they are IMAX material. The walking dead in the Lizzie McGuire movie uses the Panavision cameras and lenses creating a very professional and elite flagship camera. I have noticed a lot of movies and higher and TV shows are using these cameras because they are so good and are very universal. I have noticed that the Panavision lenses in cameras are very popular and it is cool to know that a lot of companies in the film crew are using them.
The differences in that I noticed are the amount of lenses that there are. I didn't realize how many different lines is there are cat movies and TV shows will use depending on the genre. The documentary didn't have to use as many cameras and lenses because it was mainly an interview style of documentary. Each of the media contents have their own specific style to camera systems and all the of the different style and brands of lenses that they use even down to the resolution has the style and the money they can afford.
BCIS 3610 University of North Texas Healthy Myles Fitness Center Excel Project
help with the project. I dont have any idea how to do this. Open the tblLocation table, and then delete the Downtown recor ...
BCIS 3610 University of North Texas Healthy Myles Fitness Center Excel Project
help with the project. I dont have any idea how to do this. Open the tblLocation table, and then delete the Downtown record (LocationID 335). Save and close the tblLocation table. (Hint: if a message warning that you are about to delete 1 record appears, click Yes.)Create a new query in Design View based on the tblClient table. Add the FirstName, LastName, BirthDate, and Gender fields, in that order, to the query. Save the query as qryClientBirthday, run it, and then close it. Create a new query in Design View based on the tblClient, tblBilling, and tblTrainer tables. Save the query as qryClientsAndTrainers, and then do the following:Add the LastName field from the tblClient table to the query.Add the LastName field from the tblTrainer table to the query.Add the StartDate, EndDate, Sessions, and Amount fields, in that order, from the tblBilling table to the query. Save and run the query, and then close it.Create a new query in Design View that uses the tblTrainer table, and then do the following: Add the LastName, Specialty, Certification, HireDate, and Minors fields, in that order, to the query design. Add criteria to the Certification field to select records that contain the value NASM. Save the query as qryTrainerNASM, run it, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainer2015, open it in Design view, and then do the following: Add criteria to the HireDate field to select records with contracts that begin on or after January 1, 2015. Hide the TrainerID field so it does not appear in the query results but remains in the query design. (Hint: Make sure you hide this field in Design View, not in Datasheet View.)Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNSCAMinors, open it in Design view, and then do the following: Add criteria to the query to select records with the Certification field value NSCA-CPT and the Minors field value Yes.Sort the records in ascending order by the LastName field.Move the Minors field so it appears to the right of the Certification field in the query design.Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNATAOrMinors, open it in Design view, and then do the following:Add criteria to the query to select records with the Certification field value NATA or records that indicate that the trainer accepts clients who are minors. Save and run the query, and then close it. Open the qryTrainerBilling query in Datasheet View. Change the font size for the datasheet to 12 pt.With the qryTrainerBilling query still open in Datasheet View, add a total row to the query datasheet. In the total row, use the SUM function to total the values in the Amount field, and use the AVG function to average the values in the Sessions field. Widen the Sessions field to display the result in the total row (approximate width 18.8) Save and close the qryTrainerBilling query.Create a new query in Design View that is based on the tblBilling and tblClient tables, and then do the following:Add the ClientID and LastName fields from the tblClient table to the query.Add the Sessions and Amount fields from the tblBilling table to the query.Add a total row to the design grid, and group the query results by the LastName field values.In the total row, use the SUM aggregate function to calculate the sum of the Amount field values. Set the caption of the Amount field to Total Amount. (Hint: Do not type the period.)In the total row, use the SUM aggregate function to calculate the sum of the Sessions field values. Set the caption of the Sessions field to Number of Sessions. (Hint: Do not type the period.)Save the query as qryClientTotals. Run the query, and then close it. Open the qryClientBilling query in Design View and update it as described below:Add a calculated field with the title SessionCost to the end of the query that calculates the cost per session. The formula will calculate the Amount field value divided by the Sessions field value. (Hint: The division symbol is the / symbol.) Use Cost per Session for the calculated field’s caption property.Format the SessionCost field as currency.Move the SessionCost field to the left of the FirstName field.Sort the records first in descending order by the SessionCost field values, and then in ascending order by the LastName field values.Save and run the query, and then close it.
Similar Content
Walden Accounting Worksheet
...
SEU Logistics Performance Priorities Albaik Fast Food Restaurant Chain Report
Logistics Management
Critical Writing
The purpose of this assignment is to identify and apply Logistics and Supply Chain M...
Answer Questions about behavioral patterns of leaders, management homework help
During the lecture, I discussed many behavioral patterns of leaders. 1- What do you think are the best behavioral patterns...
Help with Discussion
Discuss opinion of placing convicted felons on probation. What about sex offenders? Using APA format and citations. 250 w...
Project Management, business and finance homework help
I need the part in red answered. Only need to be a half page per question
...
Supply chain management class lectures_229519926-Supply-Chain-Segmentation-MIT
uploads/services/161584/Supply chain management class lectures_229519926-Supply-Chain-Segmentation-MIT.pdf...
Second Article
Amity Institute of Behavioral and Allied Sciences, Amity University, Lucknow 226010, India Correspondence should be addres...
Conflict Resolution Class Notes_98590110-50-Activities-for-Conflict-Resolution
uploads/services/161584/Conflict Resolution Class Notes_98590110-50-Activities-for-Conflict-Resolution.pdf...
Related Tags
Book Guides
Where'd You Go Bernadette
by Maria Semple
Of Mice and Men
by John Steinbeck
Tess of the DUrbervilles
by Thomas Hardy
And Then There Were None
by Agatha Christie
The Point of it All - A Lifetime of Great Loves and Endeavors
by Charles Krauthammer
Fear - Trump in the White House
by Bob Woodward
No Exit
by Taylor Adams
Anthem
by Ayn Rand
A Brief History of Humankind Sapiens
by Yuval Noah Harari
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
AB 299 Indiana University Purdue University Coffee Business Paper
Assignment 1: Choosing a Global SupplierIn order for Tim’s Coffee Shoppe to be successful, Tim will have to be sure he h ...
AB 299 Indiana University Purdue University Coffee Business Paper
Assignment 1: Choosing a Global SupplierIn order for Tim’s Coffee Shoppe to be successful, Tim will have to be sure he has a consistent and reliable supply of coffee beans.Research coffee bean producing countries on the Internet. Choose one country, along with a grower, that would have the greatest supplier potential to import beans for domestic sales with your distribution firm.View the map or view the explanation of the map. Most coffee grows within the equatorial band known as the Coffee Belt. This picture will help you decide where you want to start your research.Write your original, double-spaced expository essay in a minimum of 4 pages (which includes a Title and a References page) and use 12-point Times New Roman font. Your citations (minimum one (1), and maximum two (2) short scholarly citations) and references must follow APA format and citation style. Checklist: Address the following items in an expository essay and APA format and citation style: Choose a country and a grower for your supplier of coffee beans that you (as distributor) can then sell.What are the economic advantages of dealing with a vendor from this country?Does the country have environmental laws that align with those of our country? What are they?Will there be a marketing advantage by divulging the source of the coffee beans? Why or why not?Will sourcing the beans from the supplier you choose affect Tim’s bottom-line or not? Discuss your reasoning. Use a minimum of one and maximum of two short scholarly citations and references.Access the Assignment 1 rubricSubmit your response to the Assignment 1 Dropbox.
Recruitment and Hiring Practices
Case Study Analysis: Recruitment and Hiring PracticesThis case study analysis assesses the following outcomes:MT203-2: Exa ...
Recruitment and Hiring Practices
Case Study Analysis: Recruitment and Hiring PracticesThis case study analysis assesses the following outcomes:MT203-2: Examine the recruitment and selection process.PC-4.3: Apply concepts of multiculturalism and diversity to become an agent of change.You have read about recruiting and selection processes used in various companies as well as practiced with some of those concepts. Now you will apply your understanding of these concepts to a case scenario and then address the checklist items.To assist you with this and other case studies in this class, a document entitled “Case Study Analysis,” is in Course Documents and can be downloaded for your reference. This document, and many other invaluable writing resources, can also be found at the Writing Center.Case Scenario:A Silicon Valley recruiting firm recruits artificial intelligence (AI) and technology personnel. The recruits workplace could be located anywhere the company operates, depending on their skills and expertise, although the tendency is to hire in-country nationals in each respective country. The company uses technology-oriented magazines, the company website, and social media to recruit the candidates they need for their clients. They started up about a year ago and went from 3 recruiters to 50 overnight. Their recruiters are hired for their charm, communication skills, and industry expertise, however most of the recruiters graduated from Ivy League colleges in the U.S. and most are white males. Lately recruiting numbers have been slowing down drastically while general demand in the marketplace by employers for AI and technology personnel for the coming year is up 300%.The current recruiting practice involves hiring people via their website recruitment area. The potential candidate merely attaches their resume and includes a short note to the recruiter. These resumes are then screened using a data mining program looking for certain criteria and terminology in their resumes. Once screened, those candidates getting through the initial screening are then auto-contacted by email to tell them they need to complete the question/quiz accessed on the website using a particular password. If they pass this second screening they are given an individual interview via the company’s online conference room. Once completed, the final candidates are finally sent to the potential employer for the final interview and selection.Now however, the president is getting complaints from the EEO Commission and the Technology firms that they need to be hiring a more diverse workforce and that there are no ADA candidates, and the number of minorities and women is almost nil. He is now worried about losing clients and potential lawsuits as a result of their recruiting and selection processes. The company needs to address a diverse client base. Their clients are Northern European, African American, Indian, and Hispanic.Checklist: As the HR specialist of the company, you are tasked with overhauling the selection and hiring process to address the following:Identify problems with the potential candidate characteristics.Analyze the company’s recruitment and selection process and problems.What multicultural and diversity planning concepts would you apply at the company to make a positive change?Describe how you would make that positive change happen.Requirements:Complete a 2–3 page paper (not including the title and reference pages).Answer each checklist question thoroughly.Demonstrate your understanding of the information presented in the weekly reading assignments by defining terms, explaining concepts, and providing detailed examples to illustrate your points.Include at least two references from your reading assignments, or other academic sources, to reinforce and support your own thoughts, ideas, and statements using APA citation style. You can access help with APA by going to Course Resources and accessing the “APA Style Central” resources in Academic Tools.
10 pages
Project Analysis
➢ Customers- Purchasing of goods, demand for certain products, etc. ➢ Suppliers – Inflow of products from the manufa ...
Project Analysis
➢ Customers- Purchasing of goods, demand for certain products, etc. ➢ Suppliers – Inflow of products from the manufacturer, payment requests. ...
Post University Virgin American Case Study
For this question, review the Virgin America short case study at the end of Chapter 5. Prior to 2016, Virgin America was c ...
Post University Virgin American Case Study
For this question, review the Virgin America short case study at the end of Chapter 5. Prior to 2016, Virgin America was consistently rated as one of the top U.S. airlines. It served 20 destinations out of its main hub in San Francisco. Known for its leather seats, cocktail-lounge-style lighting, on board Wi-Fi, in-seat power outlets for electronics devices, full-service meals, and spacious legroom, the key competitive issue the company has been facing is that it is a niche player in a much larger industry where low-cost carriers such as Southwest Airlines and Jet Blue are putting constant pressure on prices and crowding out routes with multiple flights a day. After reviewing the full case, please answer the following questions. What was Virgin America’s segmentation strategy? Whom did it serve?Regarding its core segment, what did Virgin America offer its customers?Using the Porter model, which generic business-level strategy was Virgin America pursuing?What actions, taken at the functional level, enabled Virgin America to implement its strategy?
RTV 3511 CMU The Kinds of Camera Systems Used on The Programs Discussion
For this discussion post you'll need to do a little bit of research (shouldn't be much more than a few google searches). & ...
RTV 3511 CMU The Kinds of Camera Systems Used on The Programs Discussion
For this discussion post you'll need to do a little bit of research (shouldn't be much more than a few google searches). First, you will list your favorite live action feature film, feature length documentary, broadcast television show, and cable or streaming television show. For each of the four that you have list, find out what camera system each one of them was shot on as well as the cost of each one of the cameras.
Step 1: Identify four live-action feature film, documentary, broadcast or cable TV program, and streaming television program. (One in each category.)
Step 2: Research the kinds of camera systems used on each of the programs listed and the costs for those camera systems.
Step 3: Describe the similarities and/or differences between the camera systems used to produce these different kinds of media content.
Step 4: Post your list of programs, the associated camera systems and costs, as well as your observations by Thursday at 11:59 pm.
Step 5: Post a reply to at least one of your classmates posts. You can discuss the similarities/differences between your observations and a classmates as well as make another judgment about how some camera systems appear to be more likely associated with specific kinds of media content.
Reply:
Step 1: Identify four live-action feature film, documentary, broadcast or cable TV program, and streaming television program. (One in each category.)
The Lizzie McGuire Movie, The Social Dilemma, The Walking Dead, Money Heist.
Step 2: Research the kinds of camera systems used on each of the programs listed and the costs for those camera systems.
The Lizzie McGuire Movie: Panavision Panaflex Platinum rentals starts at $1,000 a day- insurance at $300,000-- around around $1M in Liability, Panavision Primo Lenses $500,000-$750,000 to purchase or $4000.00/day to rent. Panavision Panaflex Millennium $1,000 a day- insurance at $300,000-- around around $1M in Liability.
The Social Dilemma: Cameras RED Monstro $79,500 and Red Dragons $22,000 , Lens Sigma FF primes $24,799 and Cooke Anamorphic lenses $36,500
The Walking Dead: ARRIFLEX 416 Camera, Panavision Cameras rentals starts at $1,000 a day- insurance at $300,000-- around $1M in Liability, Panavision Lenses $500,000-$750,000 to purchase or $4000.00/day to rent , Zeizz Super Seeds MK Lenses EBAY used $58,000.
Money Heist: Arri Alexa Mini $58,760, Leitz SUMMILUX-C Lenses (Season 1-2) $39,200- $46,700.
Red Helium $49,500 and Leitz SUMMILUX-C lenses (Season 3-) $39,200- $46,700.
Step 3: Describe the similarities and/or differences between the camera systems used to produce these different kinds of media content.
The similarities between a lot of these camera is for the professionalism of camera use that they go for to use instead of buying so many. The Panvavisions are so elite that mostly you have to rent them out because they are IMAX material. The walking dead in the Lizzie McGuire movie uses the Panavision cameras and lenses creating a very professional and elite flagship camera. I have noticed a lot of movies and higher and TV shows are using these cameras because they are so good and are very universal. I have noticed that the Panavision lenses in cameras are very popular and it is cool to know that a lot of companies in the film crew are using them.
The differences in that I noticed are the amount of lenses that there are. I didn't realize how many different lines is there are cat movies and TV shows will use depending on the genre. The documentary didn't have to use as many cameras and lenses because it was mainly an interview style of documentary. Each of the media contents have their own specific style to camera systems and all the of the different style and brands of lenses that they use even down to the resolution has the style and the money they can afford.
BCIS 3610 University of North Texas Healthy Myles Fitness Center Excel Project
help with the project. I dont have any idea how to do this. Open the tblLocation table, and then delete the Downtown recor ...
BCIS 3610 University of North Texas Healthy Myles Fitness Center Excel Project
help with the project. I dont have any idea how to do this. Open the tblLocation table, and then delete the Downtown record (LocationID 335). Save and close the tblLocation table. (Hint: if a message warning that you are about to delete 1 record appears, click Yes.)Create a new query in Design View based on the tblClient table. Add the FirstName, LastName, BirthDate, and Gender fields, in that order, to the query. Save the query as qryClientBirthday, run it, and then close it. Create a new query in Design View based on the tblClient, tblBilling, and tblTrainer tables. Save the query as qryClientsAndTrainers, and then do the following:Add the LastName field from the tblClient table to the query.Add the LastName field from the tblTrainer table to the query.Add the StartDate, EndDate, Sessions, and Amount fields, in that order, from the tblBilling table to the query. Save and run the query, and then close it.Create a new query in Design View that uses the tblTrainer table, and then do the following: Add the LastName, Specialty, Certification, HireDate, and Minors fields, in that order, to the query design. Add criteria to the Certification field to select records that contain the value NASM. Save the query as qryTrainerNASM, run it, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainer2015, open it in Design view, and then do the following: Add criteria to the HireDate field to select records with contracts that begin on or after January 1, 2015. Hide the TrainerID field so it does not appear in the query results but remains in the query design. (Hint: Make sure you hide this field in Design View, not in Datasheet View.)Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNSCAMinors, open it in Design view, and then do the following: Add criteria to the query to select records with the Certification field value NSCA-CPT and the Minors field value Yes.Sort the records in ascending order by the LastName field.Move the Minors field so it appears to the right of the Certification field in the query design.Save and run the query, and then close it.In the Navigation pane, copy the qryTrainer query and paste it in the navigation pane, rename the copied query as qryTrainerNATAOrMinors, open it in Design view, and then do the following:Add criteria to the query to select records with the Certification field value NATA or records that indicate that the trainer accepts clients who are minors. Save and run the query, and then close it. Open the qryTrainerBilling query in Datasheet View. Change the font size for the datasheet to 12 pt.With the qryTrainerBilling query still open in Datasheet View, add a total row to the query datasheet. In the total row, use the SUM function to total the values in the Amount field, and use the AVG function to average the values in the Sessions field. Widen the Sessions field to display the result in the total row (approximate width 18.8) Save and close the qryTrainerBilling query.Create a new query in Design View that is based on the tblBilling and tblClient tables, and then do the following:Add the ClientID and LastName fields from the tblClient table to the query.Add the Sessions and Amount fields from the tblBilling table to the query.Add a total row to the design grid, and group the query results by the LastName field values.In the total row, use the SUM aggregate function to calculate the sum of the Amount field values. Set the caption of the Amount field to Total Amount. (Hint: Do not type the period.)In the total row, use the SUM aggregate function to calculate the sum of the Sessions field values. Set the caption of the Sessions field to Number of Sessions. (Hint: Do not type the period.)Save the query as qryClientTotals. Run the query, and then close it. Open the qryClientBilling query in Design View and update it as described below:Add a calculated field with the title SessionCost to the end of the query that calculates the cost per session. The formula will calculate the Amount field value divided by the Sessions field value. (Hint: The division symbol is the / symbol.) Use Cost per Session for the calculated field’s caption property.Format the SessionCost field as currency.Move the SessionCost field to the left of the FirstName field.Sort the records first in descending order by the SessionCost field values, and then in ascending order by the LastName field values.Save and run the query, and then close it.
Earn money selling
your Study Documents