Shelly Cashman Access 365 | Module 6: SAM Project A | Connect Marketing Group | скачать в хорошем качестве

Shelly Cashman Access 365 | Module 6: SAM Project A | Connect Marketing Group |

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 #Module6SAMProjectA #connectmarketinggroup PROJECT STEPS 1. Connect Marketing Group is a national company that provides marketing services such as contact research, brand building, and merchandising to retail stores. As a sales analyst working with the company database, you need to be able to create professional reports for employees and for people outside the company. Import the data from the file Support_AC365_6A_Programs.txt, and then append the records to the Programs table to add two new programs to the table. The text file is a delimited file with a comma separating each of the five fields in the Programs table. Do not create a new table, and do not save the import steps. 2. Open the ServiceList report in Design View, and then modify the report as follows to add the date and time and resize the report: a. Add the current date and time to the Report Header section. b. In the Date and Time dialog box, select the second date format (e.g., 01-Aug-29) and the second time format (e.g., 4:19 PM). c. If necessary, resize the report so that the right boundary of the report is approximately at the 8" mark on the horizontal ruler. Save the report without closing it. 3. With the ServiceList report still open in Design View, set properties for a report section as follows to fine-tune the display of the data: a. Select the ServiceType Header, and then display the Property Sheet for this section. b. Change the Repeat Section property to Yes. c. Change the Force New Page Property to Before Section. Save and close the report. 4. Modify the ContactsByCompany report as follows to add a missing field: a. Open the ContactsByCompany report in Design View. b. Open the field list for the report. c. Add the LastName field to the CompanyID Header section of the report so that the left edge of the control is at the 6" mark on the horizontal ruler. The left edge of the label is just to the right of the CompanyName control. (Hint: You may need to reposition and resize the LastName control and its label after inserting it into the report.) Confirm that the arrangement of the controls matches Figure 1, and then save the report without closing it. 5. With the ContactsByCompany report still open in Design View, format the Detail section and its controls to emphasize the contact information: a. Select the ContactID, FirstName, LastName, City, and State controls (text boxes and labels) simultaneously. b. Group the controls. c. Bold the controls. d. Resize the Detail section so it is only as tall as necessary to accommodate its controls (approximately 1.25" tall). Confirm that the report matches Figure 1, and then save and close the ContactsByCompany report. Figure 1: ContactsByCompany Report in Design View 6. Modify the BillingsByState report as follows to format a calculated control: a. Open the BillingsByState report in Design View. b. Change the Text13 label in the Page Header section using Late Fee as the new label name. c. Format the text box control in the Detail section containing the =[MonthlyBill]*0.05 calculation so that it is displayed with the Currency number format and two decimal places. d. Align the top of the Late Fee text box with the tops of the other controls in the Detail section. Save the BillingsByState report, switch to Report View, confirm your report matches Figure 2, and then close the report. Figure 2: BillingsByState Report in Report View 7. Open the BasicContacts report in Design View, and then change the Alternate Back Color property for the Detail section to No Color to simplify the design. Save and close the report. 8. Open the CompanyAccounts report in Design View, and then use the Subform/Subreport Wizard as follows to add a subreport: a. Add the subreport below the Stores label in the Detail section, at approximately the 1.25" mark on the vertical ruler. b. Use the Accounts table as the source of the subreport. c. Select the AccountNumber, MonthlyBill, and AnnualBill fields (in that order) from the Accounts table to add to the subreport. d. Ensure that the Choose from a list option button is selected, and accept the default link Show Accounts for each record in Companies using CompanyID for the subreport. e. Save the subreport as Accounts subreport (which is the default name). f. Delete the label associated with the subreport. g. Align the left side of the subreport with the left side of the Stores label. Save the CompanyAccounts report, switch to Report View, confirm your report matches Figure 3, and then close the report. Figure 3: CompanyAccounts Report in Report View 9. Open the ContactsByState report in Design View, and then modify the report as follows to arrange the controls more logically: