Microsoft Office Tutorials and References
In Depth Information
2. Export the qryPropertiesByRate query as an HTML document to the Level.02\Case4
folder; do not use a template. Save the file as qryPropertiesByRate .Savethe
3. Import the XML file named Works, which is located in the Level.02\Case4 folder, as
a new table in the database named tblWorks . Save the import steps.
4. Export the qryPropertyReservations query as an XML file named
qryPropertyReservations to the Level.02\Case4 folder; do not create a separate XSD
file. Save the export steps.
5. Link to the Personnel workbook, which is located in the Level.02\Case4 folder,
using tblPersonnel as the table name. Change the name in the fourth record from
Edward Leary to Marie Leary .
6. Modify the frmGuestsWithReservations 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 Reservation Data and for the right tab to
Reservation Chart .
c. Change the caption for the main form’s navigation buttons to Guest and for the
subform’s navigation buttons to Reservation .
d. Add a chart to the second page of the tab control. Use the tblReservation table as
the record source, select the StartDate, PropertyID, and RentalRate fields, use the
Column Chart chart type, include a legend, and use Reservations as the chart title.
7. Open the qryGuestsAndReservations query, and create a PivotTable with RentalRate
as the detail field, StateProv as the column field, the Quarters component of the
StartDate By Month entry in the PivotTable Field List as the row field, and
PropertyID as the filter field. Add subtotals and a grand total of the RentalRate field,
and then hide the details.
8. Switch to PivotChart view. Display the legend, change the green color to yellow, and
then save the query.
9. Close the Vacation database without exiting Access, make a backup copy of the
database, open the Vacation database, compact and repair the database, close the
database, and then exit Access.
| Case Problem 5
Use the skills you
learned in this tutorial
to integrate and
analyze the data for an
Data File needed for this Case Problem: ACE.accdb ( cont. from Tutorial 7 )
Always Connected Everyday Chris and Pat Aquino want you to integrate the data in the
ACE database with other programs, and they want to be able to analyze the data in the
database. You’ll help them achieve these goals by completing the following:
1. Open the ACE database located in the Level.02\Case5 folder provided with your
2. Export the tblAccessPlan table as an HTML document to the Level.02\Case5 folder;
do not use a template or save the import steps. Save the file as tblAccessPlan .
3. Export the rptAccessPlanCustomers report as an HTML document to the
Level.02\Case5 folder; do not use a template or save the export steps. Use your
Web browser to open and review the HTML document.
4. Export the tblCustomer table as an XML file named tblCustomer to the
Level.02\Case5 folder; do not create a separate XSD file. Save the export steps.