• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 36. Access and the Web > Inserting a Spreadsheet in a Data access Page

Inserting a Spreadsheet in a Data access Page

A spreadsheet on a data access page is similar to an Excel spreadsheet. You can add data and perform calculations.

To add a spreadsheet:

1.
With the page open in Design view, click the Office Spreadsheet button on the toolbox (Figure 36.28).

Figure 36.28. The Office Spreadsheet button.


2.
Click the pointer where you want the upper left corner of the spreadsheet to appear.

The spreadsheet appears on the page (Figure 36.29).

Figure 36.29. The spreadsheet on the data access page.


3.
Add data to your spreadsheet.

4.
To add formatting and to change the design, right-click the spreadsheet and choose Commands and Options from the shortcut menu to open the Commands and Options dialog box. (Figure 36.30).

Figure 36.30. The Commands and Options dialog box.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint