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

GETTING STARTED

1. Save the file SC_AC365_EOM8-1_FirstLastName_1.accdb as SC_AC365_EOM8-1_FirstLastName_2.accdb

a. Edit the file name by changing “1” to “2”.

b. If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.

2. With the file SC_AC365_EOM8-1_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.

a. If the table does not display your name, delete the file and download a new copy.

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 are using an Access database to track and store company data for that region, and want to make it easy for users to access forms and reports. Users access the Members table frequently. Create a macro to open the Members table in Datasheet View and in Edit data mode. Save the macro using OpenMembers as the name and then close the macro.

2. Open the OpenForms macro in Design View and add a second submacro that opens the ProducerEntry form in Form View and Read Only data mode. Use OpenProducerEntry Form as the name of the submacro. Save the changes to the macro and close the macro.

3. Create a datasheet form based on the Media table so you can add the table to a Navigation Form later. Save the form using the default name Media as the form name. Close the form.

4. Open the Subscriptions form in Design View and create a UI macro that opens the SubscriptionsAndMembers form when a user clicks the SubID field. Set a temporary variable using SN as the name and [SubID] as the expression. Add an OpenForm action using [SubID]=[TempVars]![SN] as the Where condition, Read Only as the data mode, and Dialog as the window mode. The last action of the macro should remove the temporary variable. Confirm that your macro matches Figure 1. Save and close the macro and then save and close the form.

Figure 1: UI macro for the On Click event in the Subscriptions form

5. Open the Contributors table in Datasheet View and then create a data macro associated with the Before Change event for the table. The macro checks the Rating field. If the value in the Rating field is less than 1, the macro should set the value to 1. If the Rating field value is greater than 5, then the macro should set the value to 5. Save and close the macro and then save and close the Contributors table.

6. Create a Navigation form for the database using the Horizontal Tabs layout. Add the Subscriptions Datasheet form and then the Producers Datasheet form to the Navigation form in that order. Change the title of the form using Business Navigation Form as the new title and then save the form using Business Navigation as the name. Switch to Form View and confirm that your form matches Figure 2. Save and close the form.

Figure 2: Business Navigation form in Form View

7. Open the PreviewReports form in Design View. Add a command button to the form. Position the command button so that the top-left edge is at the 1" mark on the vertical ruler and the 2" mark on the horizontal ruler. The command button should run the submacro that previews the Producers by Media Report. Use Preview Producers by Media Report as the text for the button and use PreviewProducers as the name of the button. Confirm that your form matches Figure 3. Save and close the PreviewReports form.

Figure 3: PreviewReports form in Design View

8. Open the Members Navigation form in Layout View. Modify the form by adding the ContributorList form to the form and moving the Members form so that it appears first in the list. Switch to Form View and confirm that the form matches Figure 4. Save and close the Members Navigation Form.

Figure 4: Members Navigation form in Form View

9. Open the MemberSubscriptions report in Layout View and change the report layout to Stacked as shown in Figure 5. Save the change to the report and close it.

Figure 5: MemberSubscriptions report in Layout View

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.