Word: Update your document's date automatically
When creating a template or form letter that should always be printed with the current date, insert the date as a field rather than as text to avoid having to retype it with each printing.
Follow these steps:
The date is inserted as a field. (To view the field code, right-click the shaded area and click Toggle Field Codes.) Each time you open or print your form letter, or create a new document from the template, the current date will appear automatically.
To make the date permanent, before saving the document, select the date and repeat Steps 2 through 4 above to clear the check mark from the Update Automatically check box.
Excel: Print worksheet column labels on every page
Multipage printouts of large worksheets are difficult to read when their column labels appear only on the first page. For example, suppose you have a 10-column, 1000-row worksheet and the labels for each column are contained in row one.
Follow these steps to have the column labels print on every page:
When you click Print, row one will print as the horizontal title for each page.
To print row labels on the left of each page, follow the steps above, except in Steps 2 and 4, select the collapse dialog box at the right end of the Columns To Repeat At Left text box and enter the range of columns that contain the row labels.
Access: Use an old form with a new record source
It isn't necessary to design a new form for each new table or query in your database. Just make a copy of an old form and change the record source so that it'll work with a new table or query.
Follow these steps to change the record source:
The form's field list now contains the fields in the new record source.
Access only allows one query or table per form. If you need the fields from two or more tables in the drop-down list, in Step 3, click RecordSource and click the Build button. This will open a query design screen from which a single query can be built from the desired tables. Once built, close the query design window, and click Yes to have the SQL code from the query entered as the RecordSource.