Shelly Cashman Access 365 | Module 10: End of Module Project 1 |TopStream, Inc.USING SQL | скачать в хорошем качестве

Shelly Cashman Access 365 | Module 10: End of Module Project 1 |TopStream, Inc.USING SQL |

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 #shellycashmanAccess365 | Module 10: End of Module Project 1 TopStream, Inc. USING SQL PROJECT STEPS 1. TopStream, Inc. is an online streaming platform for TV shows, movies, podcasts, music, and videos. As the new projects coordinator, you are in charge of introducing TopStream's services in the Pacific Northwest. You want to use the extended data management capabilities of Structured Query Language (SQL) to retrieve information from the database. Create a new query in SQL View based on the Subscriptions table. Use the asterisk (*) in the SELECT clause to add all fields from the Subscriptions table and be sure to end the SQL statement with a semicolon (;). Run the query and confirm that the results contain seven records. Save the query using SubscriptionTypes as the query name, and then close the query. 2. TopStream plans to run a promotion for members in Nevada. Open the NVMembers query in SQL View and add criteria to find all members located in Nevada (NV). Run the query and confirm that the results contain 12 records. Save and close the query. 3. Run the ProducerList query to note that the datasheet displays producer last names and media IDs, but not first names. Open the ProducerList query in SQL View and add the FirstName field to the query before the LastName field. Run the query and confirm that the results match Figure 1 with three columns and 19 records. Save and close the query. Figure 1: ProducerList Query Results 4. Open the WAMembers query in SQL View and restrict the selection to only those members who reside in the city of Seattle in the state of Washington. Run the query and confirm that the results contain four records. Save and close the query. 5. Open the ContributorSubscriptions query in SQL View and restrict the selection to only those contributors whose SubID is equal to or greater than 3. Run the query and confirm that the results contain eight records. Save and close the query. 6. Open the MediaProducersJoin query in SQL View. Add a WHERE clause that joins the Producers table and the Media table using the common MediaID field. Run the query and confirm that the results match those shown in Figure 2. The query returns 19 records. (Hint: Your records may be in a different order.) Save and close the query. Figure 2: MediaProducersJoin Query Results 7. Open the ORCount query in SQL View. Modify the SELECT clause to count the number of members located in Oregon (OR). Assign the name ORMembers to the function result. Run the query, resize the ORMembers column to its best fit, and confirm that the results match those shown in Figure 3. The query returns a count of 16 members. Save and close the query. Figure 3: ORCount Query Results 8. Open the ProducersSort query in SQL View and sort the records in ascending order by the MediaID field. Run the query and confirm that the results match those shown in Figure 4. The query returns 19 records and the last record is for ProducerID 127. Save and close the query. Figure 4: ProducersSort Query Results 9. Open the GroupByMedia query in SQL View. Add the MediaID field to the SELECT statement before the COUNT function. Group the records by the MediaID field and then sort the records by the MediaID field in descending order. Run the query and confirm that the results match those shown in Figure 5. The query returns three records. Save and close the query. Figure 5: GroupByMedia Query Results 10. TopStream regularly adds and edits member records. To make the updates more efficient, open the MemberEntry form in Design View and then change the tab order so that users tab to the MediaID field immediately after the MemberID field. Open the form in Form View to confirm the tab order change, then save and close the form. Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.