Shelly Cashman Access 365 | Module 6: SAM Critical Thinking Project C скачать в хорошем качестве

Shelly Cashman Access 365 | Module 6: SAM Critical Thinking Project C

Please contact us if you need this project or any other project in any subject to be completed. Whatsapp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 #ShellyCashmanAccess365 #Module6SAMCriticalThinkingProjectC #ConnectMarketingGroup Shelly Cashman Access 365 | Module 6: SAM Critical Thinking Project C Connect Marketing Group ADVANCED REPORT TECHNIQUES 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 text file Support_AC365_CT6C_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 save the import steps. 2. Modify the ServiceList report as follows to add the date and time and resize the report: 3. Set properties for the ServiceType Header section in the ServiceList report as follows to fine-tune the display of the data: 4. Modify the ContactsByCompany report by adding the LastName field to the CompanyID Header section 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. Confirm that the arrangement of the controls matches Figure 1, and then save the report without closing it. 5. In the ContactsByCompany report, format the Detail section and its controls as follows to emphasize the contact information: 6. Modify the BillingsByState report as follows to format a calculated control: 7. Modify the BasicContacts report by changing the Alternate Back Color property for the Detail section to No Color to simplify the design. Save and close the report. 8. Add a subreport to the CompanyAccounts report using the Subform/Subreport Wizard as follows: 9. Modify the ContactsByState report as follows to arrange the controls more logically: 10. Modify the ContactList report as follows to make the report easier to read and to remove extra white space: 11. Modify the AccountBillingList report as follows to organize the data more effectively: 12. Create a new blank report in Design View as follows to list program information: a. Set the Record Source for the report as the Programs table. b. Save the report with the name ProgramList, but do not close the report. c. Add the ProgramID, ProgramTitle, StartDate, and National fields to the report and then reposition them so that the left edges of the four controls are at the 2" mark on the horizontal ruler. d. Add the title Program List to the Report Header section. e. Add page numbers to the report at the Top of Page (Header) position, using the Page N of M format and Right alignment. f. Reduce the height of the Detail section to 2". Confirm that the report matches Figure 7, and then save and close the ProgramList Report. Figure 7: ProgramList Report in Design View 13. Group the ProgramContactList report by the State field, and then sort the report by the ContactID field in ascending order to organize the records. Do not add any other grouping or sorting options to the report. Save and close the ProgramContactList Report. 14. Modify the AccountServices report as follows to add a calculated control: a. Add a text box control to the Report Footer section. The left edge of the text box is at the 6.5" mark on the horizontal ruler. b. Convert the text box control into a calculated control that sums the ContractTotal field. c. Format the control so that it displays values using the Currency number format and zero decimal places. d. Change the label using Total as the new label name. Confirm that the report in Design View matches Figure 8, and then save and close the AccountServices report. Figure 8: AccountServices Report 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.