Working With Spreadsheets in Access

What you might not realize is that you can add a spreadsheet to a data access page (Pages object) and use it to enter and edit temporary data.  To add a spreadsheet, first open the Pages object in Design View. If the Toolbox isn't open, click the Toolbox tool on the Page Design toolbar. On the Toolbox, find the Office Spreadsheet control (the third icon in the fourth row). Click the Office Spreadsheet control and then click inside the Pages object to insert a spreadsheet control. Next, enter any data and formulas directly in the spreadsheet. Once you publish this data access page to the Web, other users can change the data to update formulas.

Access Index

Main Index