Share this Page URL

Chapter 12. Access and the Web > Hosting Office Web Components on Data Access P... - Pg. 453

Access and the Web 453 19. 20. With the data access page displayed in Page view, you can use the Spreadsheet component's toolbar to work with and manage the data. You can sort and filter data, export the data to Excel, and format the data. The Spreadsheet component includes additional worksheets as well, which you can display using the Sheet tab at the bottom of the spreadsheet. On the Access toolbar, click the View button again to open the page in Design view. Right-click the Spreadsheet component, and then click Commands And Options. Click the Protection tab, as shown here: 21. 22. 23. 24. You can set options on the Protection tab of the Commands And Options dialog box so that users of the data access page can do more with the Spreadsheet component. For example, you can allow them to delete or insert columns or rows. After inserting a row, a user could then use the AutoSum button to add subtotals to the expense data. In the Sheet area, under the label At Run Time, Allow, select the options Insert Columns, Insert Rows, Filter, and Sort. Click the View button on the toolbar to open the page in Page view. Right-click one of the column headings in the spreadsheet, and then click Sort Ascending, ExpenseType. Right-click in the row following the last row in which Advertising is listed as the expense type, and then click Insert Rows. In the new row, click in the column for AmountSpent, and then click the AutoSum button on the Spreadsheet component's toolbar. Press Enter, and you've created a category subtotal, as shown here: