Create spaces for online data entry
If you're creating a form that you want users to fill in after printing it, you can use the underline character or the [Tab] key to add fill-in line spaces to the document. But if you also plan to use the same form online, publishing it to the Web can move or overwrite your carefully placed spaces.
However, you can create fill-in line spaces that will work online. Follow these steps:
Word automatically adds the fill-in lines. To enter information in the line spaces, click above the line and begin typing. Press the down arrow to begin typing on the next line.
Use custom styles from other workbooks
If you've created custom styles in an Excel workbook, you can also use these styles in another workbook. However, you don't have to copy each style individually, which can be a time-consuming process.
Instead, you can use Excel's Merge Styles feature, and Excel will copy the styles for you. Follow these steps:
All of the styles in the existing file will now be available to the active document.
Add a subreport to an existing report
The easiest way to create a report that contains information from more than one table is to use Access' Report Wizard. But the process becomes more complicated if you need to add information from another table to an existing report.
For example, let's say you have an Authors report that lists the names and publishers of all book authors carried in your store. Beneath each author record, you want to list the information from the Books_in_Stock report for each author's books.
To add the Books_in_Stock report to the Authors report, follow these steps:
When you run the report, Access will list the information about the author's books from the Books_in_Stock report under the author information in the Authors report.