Create tables with the keyboard
You can use the Draw Table button on the Tables And Borders toolbar to create two side-by-side tables. However, there's a simple alternative.
You can use the keyboard to accomplish the same results. Press [+] to indicate the cell border, and press [-] to indicate the cell's width. For example, to create a two-column table side by side with a three-column table, follow these steps:
You should now have two one-row tables on the same line.
If this doesn't work, go to Tools | AutoCorrect Options. On the AutoFormat As You Type tab, select the Tables check box, and click OK.
To enable the Click And Type feature in Step 3, go to Tools | Options. On the Edit tab, select the Enable Click And Type check box, and click OK.
Add a data series to a chart with a few mouse clicks
You can use your mouse to quickly add a data series to an existing chart. For example, let's say you have a chart that shows sales for January and February. To add the data for March, follow these steps:
Excel automatically adds the data for March to the chart. Expanding the existing selection works well when the data you want to chart is in adjacent columns.
For nonadjacent cells, select the cells that contain the data, and click and drag the selection to the existing chart. Excel automatically adds the selected data series to the chart and a generic name to the legend.
To add the correct name of the series to the legend, activate the Chart Wizard, and follow the steps to add the new data series.
Number report records with a calculated text box
Numbering records in a report can make it easier to refer to individual records when you're discussing the report. This is a relatively easy task.
To number the records, follow these steps:
Access will increment the value in the text box by 1 for each record. For grouped data, you can number each group separately by setting the Running Sum property to Over Group.