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

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

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 Shelly Cashman Access 365 | Module 1: End of Module Project 1 TopStream, Inc. BUILDING AN ACCESS DATABASE TO MANAGE COMPANY DATA PROJECT STEPS 1. TopStream, Inc. is a new 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 are developing an Access database application to help manage and analyze company data. Open the Members table in Datasheet View and resize all columns to display entire field names and field values to make the datasheet easier to read. Save and close the Members table. 2. Create a new table in Datasheet View to store producer data. Change the ID field name to ProducerID and change its data type to Short Text. Add a field named FirstName with the Short Text data type, add a field named LastName with the Short Text data type, and add a field named MediaID with the Short Text data type. (Hint: The ProducerID field will be automatically set as the primary key field.) Save the table with the name Producers and then close the table. 3. Open the Subscriptions table in Datasheet View and add the new record shown in Table 1 for a new type of subscription. Close the Subscriptions table. Table 1: New Record for Subscriptions Table SubID SubDescription RegistrationFee MonthlyFee 6 Any three $25.00 $30.00 4. Open the Media table in Datasheet View and delete the record for MediaID M05 (Audio books) because the company no longer provides that type of media. Modify the MediaName value for the record with MediaID M03 (Recordings), using Podcasts as the more accurate MediaName value, and then close the Media table. 5. Create a new table in Design View to store employee data. Add a field named EmpID with the AutoNumber data type and set it as the primary key. Add a field named EmpFirst with the Short Text data type, a field named EmpLast with the Short Text data type, and a field named HireDate with the Date/Time data type. Save the table using Employees as the name and then close the table. 6. Create a new query using the Simple Query Wizard to list the registration and monthly fees for subscriptions. Choose the SubID, SubDescription, RegistrationFee, and MonthlyFee fields from the Subscriptions table, in that order. Show detailed data, title the new query using TotalFees as the name, open the query to view information as shown in Figure 1, and then close it. Figure 1: TotalFees Query 7. Create a new form based on the Members table using the Form tool to record member data. Save the form as MemberInfo and then display it in Form View. Confirm that the form matches Figure 2, and then save and close it. Figure 2: MemberInfo Form 8. Create a new report using the Report Wizard to list member information according to their media type. Choose the MemberID, LastName, City, State, and MediaID fields from the Members table. Do not add any grouping levels. Sort the records in ascending order by MediaID. Use a Tabular layout and a Portrait orientation. Title the report using MembersByMedia as the name, preview the report, a portion of which is shown in Figure 3, and then close it. Figure 3: MembersByMedia Report 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.