Word: Change page orientation mid-document
Let's say you have a chart or table that you want to include in a document, but it's too wide to print across a standard sheet of paper. Using Word's Page Setup menu, you can print a chart or table horizontally across a page while printing the rest of the document vertically.
Follow these steps:
The rest of the document will now print in Landscape mode. To resume printing the pages vertically, follow these steps:
Use this method to apply any changes you make in the Page Setup dialog box to any section of your document.
Excel: Check for numbers stored in a text format
Excel can't perform calculations on cell values formatted as text, such as number values that you've imported as text from other databases into Excel. Excel 2002 includes a feature that alerts you to these cells and optionally converts them to numbers.
To activate this feature, follow these steps:
Now, when Excel finds a number in a cell formatted as text, it will place a green error indicator in the upper left corner of the cell. To convert cells to a number format, select the cell, click the Error Checking Options button displayed to the left of it, and select Convert To Number.
Access: Search for fields with no data
It's not uncommon for a field to have no data. A user may have skipped the field or left it blank because there was no value for the field at the record's time of entry. For example, phone numbers may be missing for some customers in your Customer table.
To find all customers whose phone number field contains no data, follow these steps:
When you run the query, the results will list all customers whose phone numbers are missing.
But suppose your salespeople need a list of all customers they can call for a special promotion. To create a list of all customers with phone numbers, follow the same steps.
But this time, enter Not Null in the Criteria cell. Access automatically replaces the entry with Is Not Null, and the query results will list all customers whose phone number fields are not blank.