Shelly Cashman Access 365 | Module 10: SAM Project A Connect Marketing Group скачать в хорошем качестве

Shelly Cashman Access 365 | Module 10: SAM Project A Connect Marketing Group

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6N... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@gmail.com We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English. Shelly Cashman Access 365 | Module 10: SAM Project A Connect Marketing Group PROJECT STEPS Connect Marketing Group is a national company that provides marketing services such as contact research, brand building, and merchandising to retail stores. As a sales analyst working with the company database, you want to use the extended management capabilities available in Structured Query Language (SQL) to retrieve information. Create a new query in SQL View based on the Services table as follows to list the services that Connect Marketing provides: Add all fields from the Services table to the new query using an asterisk (*) in the SELECT clause. Be sure to end the SQL command with a semicolon (;). Save the query using ServiceList as the query name, run the query to produce the results shown in Figure 1, and then close the query. Open the ProgramContactList query in SQL View to update the query. Add the LastName field to the SELECT clause after the FirstName field to include a missing detail about the program contacts. Run the query and confirm that the results match those shown in Figure 2. Save and close the ProgramContactList query. Open the AnnualBill query in SQL View, which is supposed to show both the monthly and annual bill amounts for each account. Modify the query as follows: Add a computed field to the SELECT clause after the MonthlyBill field that calculates the total annual bill amount by multiplying the MonthlyBill field by 12. Add an AS clause to use AnnualBill as the name (alias) for this computed field. Run the query and confirm that the results match those shown in Figure 3. (Hint: Your records may be in a different order.) Save and close the AnnualBill query. Open the CompanyCriteria query in SQL View. Add a WHERE clause to the query to retrieve only those companies where the number of retail stores is greater than 25. Run the query and confirm that the results match those shown in Figure 4, with 11 records meeting the criteria. Save and close the CompanyCritiera query. Open the CompanyRegions query in SQL View. The query currently selects companies in the Midwest, but you also want to retrieve companies in the Northwest. Add an OR clause to the WHERE clause in the query so that the query retrieves records in which the Region field is equal to Midwest or Northwest. Run the query and ensure that the results match those shown in Figure 5. (Hint: Your records may be in a different order.) Save and close the CompanyRegions query. Open the ContactCityState query in SQL View. The query currently retrieves records for contacts in California, but you want to review records only for contacts in San Jose, California. Add an AND clause to the WHERE clause in the query so that the query retrieves only those records in which the State field is equal to CA and the City field is equal to San Jose. Run the query, and then confirm that the results match those shown in Figure 6. Save and close the ContactCityState query. Open the NewYorkCount query in SQL View. The query currently displays the contact IDs for contacts in New York state, but you want to know the number of contacts in California. Modify the query as follows: Modify the SELECT clause to count the number of contacts by contact ID. Add an AS clause to the SELECT clause to set the alias of the function result to ContactCount. Modify the WHERE clause to select contacts in CA. Run the query, resize the column to its best fit, and then confirm that the results match those shown in Figure 7. Save and close the NewYorkCount query. Open the ProgramsContactsJoin query in SQL View. Modify the query as follows to join tables and show one contact for each program in the query results: Add a WHERE clause that joins the Programs table and the ProgramContacts table on the ContactID common field. Qualify the field names in the WHERE clause. Run the query and confirm that the results match those shown in Figure 8. (Hint: Your records may be in a different order.) Save and close the query. Open the ProgramLocations query in SQL View and clarify the contents of a column in the query results as follows: Use an AS clause to add a caption to the National field #samproject1a #samprojects #cengageassignments #SC_AC365_10a #SC_ACCESS #access_assignments #access_sam_projects #Module10SamProjecta #connect_marketing_group #shelly_cashman_access #SC_AC365_10a_FirstLastName_1.accdb #SC_AC365_10a_FirstLastName_2.accdb