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

GETTING STARTED

1. Save the file SC_AC365_EOM5-1_FirstLastName_1.accdb as SC_AC365_EOM5-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. To complete this Project, you will also need the following files:

Support_AC365_EOM5-1_Mariam.jpg

3. With the file SC_AC365_EOM5-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 are developing forms to use for entering and reviewing the data. The Marketing Department occasionally conducts phone call surveys to gather information about members. Add a new field to the Members table after the PostalCode field. Use Phone as the field name and Short Text as the data type. Save the table and then add an input mask to the Phone field to display the field data in a format such as (503) 555-1234. Store the data without symbols. Save and close the Members table.

2. You and your staff want to easily identify TopStream media producers when you add or view their information in the ProducerEntry form. To prepare for modifying the form, add a new field to the Producers table after the MediaID field. Use Photo as the field name and Attachment as the data type. Save and close the Producers table.

3. Open the ProducerEntry form in Design View. Add the Photo field to the form below the MediaID field, and then resize the Photo field to a width and height of about 2" to enlarge the field contents. Remove the Photo field from the tab stop sequence since users need to double-click the field to add a photo. Save the form and then switch to Form View. Add the Support_AC365_EOM5-1_Mariam.jpg image file to the Photo field, and then confirm that your form matches Figure 1. Close the ProducerEntry form.

Figure 1: ProducerEntry Form in Form View

4. Open the MemberEntry form in Design View to add two missing fields. Add the RepeatMember field below the LastName field so that the check box is at the 2" mark on the horizontal ruler. Add the Phone field below the PostalCode field so that the left edge of the Phone text box aligns with the left edge of the PostalCode text box. Change the tab order so that the RepeatMember field follows the LastName field. Confirm that your form matches Figure 2, and then save and close the form.

Figure 2: MemberEntry Form in Design View

5. Open the MediaAndProducers form in Design View so you can improve its appearance. Delete the unnecessary Producers label for the subform. Resize the width of the subform so that the right edge is at the 7" mark on the horizontal ruler. Apply the Etched Special Effect property to the subform. Modify the form title by changing its font color to Dark Blue (4th column, 1st row in the Standard Colors palette) and the font size of the text to 24 point. Confirm that your form matches Figure 3. Save and close the form.

Figure 3: MediaAndProducers Form in Design View

6. You and your staff want to enter subscription and member information in a single form. Create a form based on the MemberSubscriptions query. Include all the fields from the query in the form. View the data by subscriptions as a form with a subform. Use a Datasheet layout for the subform. Use SubscriptionsAndMembers as the name of the form and use MembersSubform as the name of the subform.

7. Display the SubscriptionsAndMembers form in Design View and delete the unnecessary Members label for the subform. Change the label for the SubscriptionsAndMembers control in the form header using Subscriptions and Members as the text. Confirm that your form matches Figure 4. Save and close the form.

Figure 4: SubscriptionsAndMembers Form in Design 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.