Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Open the Community database you worked with in the previous three modules 2 . Export the qryDonationsSeptemberOrLaterCrosstab query as an HTML document named
Open the Community database you worked with in the previous three modules Export the qryDonationsSeptemberOrLaterCrosstab query as an HTML document named Crosstab to the Access Case folder. Save the export steps. Export the rptPatronDonations report as a PDF document named PatronDonations to the Access Case folder. Include the document structure tags for accessibility, and do not save the export steps Explore Import the CSV file named Facility, which is located in the Access Case folder provided with your Data Files as a new table in the database Use the Short Text data type for all fields, choose your own primary key, name the table Temporary, and run the Table Analyzer Accept the Table Analyzer's recommendations which will be to create two tables. Rename the tables as tblStorage and tblFacility. HintUse the Rename Table button to the right of "What name do you want for each table? Make sure each table has the correct primary key. Hint: Use the Set Unique Identifier button to set a primary key if necessary Let the Table Analzyer create a query Do not save the import steps. Review the tbl Temporary query, review the tbl Temporary table it might be named tblTemporary OLD and then review the tblStorage and tblFacility tables. Close all tables Export the tblDonation table as an XML file named Donation to the Access Case folder do not create a separate XSD file. Save the export steps. Once saved, modify the description as Exported tblDonation table as an XML file. Modify the frmPatronDonations form in the following ways: a Add a tab control to the bottom of the Detail section and place the existing subform on the first page of the tab control b Change the caption for the left tab to Donation Data and for the right tab to Donation Chart Change the caption for the main form's navigation buttons to Donor and for the subform's navigation buttons to Donation d Add a chart to the second page of the tab control. Use the tblDonation table as the record source select the PatronID DonationValue and DonationDate fields, use the D Column Chart type, include a legend and use Donations by Patron as the chart title. e Change the chart to a Clustered Bar chart Close the Community database Open the Volunteer database which is located in the Access Case folder provided with your Data Files Create an application part called Volunteer with the description Volunteer information and do not include the data. Close the Volunteer database Open the Community database Create a table called tblPotential Volunteer using the Volunteer application part. Make a backup copy of the database compact and repair the database and then close it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started