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

Shelly Cashman Access 365 | Module 9: End of Module Project 1

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 9: End of Module Project 1 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. Besides using an Access database to track and store company data for that region, you need to perform basic database administration tasks to make sure everyone can use the database efficiently. If more than one person is using the database, it should indicate when significant changes occur. From the Info screen in Backstage View, add a custom property to the database using Status as the name, Text as the type, and Current Version as the value. Confirm that your custom property matches the one shown in Figure 1, and then close the dialog box. (Hint: Your database may contain other properties.) Figure 1: Custom tab in the Properties dialog box 2. Displaying a Navigation form when the database opens makes a database easier to use. In the Current Database category of the Access Options dialog box, change an option to display the Main Navigation form when the database opens. (Hint: When a Microsoft Access dialog box indicates you must close and reopen the current database for the specified option to take effect, click OK.) 3. Open the Producers table in Design View, and then create a single-field index on the LastName field to order the records more efficiently. The index should allow duplicate values. Save the changes to the table design and close the table. 4. Open the Contributors table in Design View, and then create a multiple-field index using ContributorName as the name of the index. Include the LastName field and the FirstName field in that order. Both the LastName and FirstName fields should be sorted in ascending order. Save the changes to the table design and close the table. 5. Open the Members table in Design View and modify the Address multiple-field index by changing the sort order for the State field to Descending. Save the changes to the table and then close the table. 6. Open the Media table in Design View, and then create a custom input mask for the MediaID field to make sure the field consists of one uppercase letter and two numbers. Save the change to the table design and then close the table. 7. Open the Subscriptions table in Design View and create a validation rule for the table requiring that the RegistrationFee field value is always less than or equal to the MonthlyFee field value. Use Registration cannot exceed monthly fee as the validation text. Save the changes to the table design. (Hint: When asked if you want to test the existing data, click No.) Close the Subscriptions table. 8. Open the OregonMembers table in Design View to modify the order of the records. Change a table property so that the records are displayed in order by LastName instead of by MemberID. Save and close the OregonMembers table. 9. Customize the Navigation Pane by adding a custom category using Producers as the category name. Then add two custom groups, one named Forms and the other named Reports, to the Producers category. 10. Switch to viewing database items by the Producers custom category. Add the Producers form to the Forms group and add the ProducersByMedia report to the Reports group. 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.