Tech

Guides

Business Applications ▪ Database Management ▪ Disaster Recovery ▪ Enterprise Servers & Storage ▪ IT Security ▪ Java ▪ Microsoft Office Suite ▪ Network Admin ▪ Open Source ▪ SMB ▪ SOA ▪ Tech Management ▪ Software/Web Development ▪ Windows Server ▪ Wireless Tech

Microsoft Office Suite TechGuides

Create a Table of Contents from any keyword

By Mary Ann Richardson, TechRepublic
Thursday, February 09, 2006 02:59 PM

When you're creating a Table of Contents for your Microsoft Word document, it's easy to get muddled down into many complicated steps. However, find out how easy it is to create a TOC from any keyword or phrase in your document.
Microsoft Word

Create a Table of Contents from any keyword or phrase in your Word document

Your document does not need to have formatted Headings in order for Microsoft Word's Table of Contents feature to work. Word can build a Table of Contents from any phrases or keywords in your document.

For example, you might place an italicized phrase before each paragraph in your document and would like to use them to create a Table of Contents. To do so, follow these steps:

Select the first phase. Press [Alt][Shift][o].
Click the Mark button.
Scroll to and select the second phase. Click the Mark button again. Repeat these steps until all phrases are marked.
Click the Close button.
Click where you want to insert the Table of Contents in your document.
Go to Insert | Reference | Index And Tables.
Select the Table Of Contents tag, click the Options button, and then select the Table Entry Fields check box.
Click the OK button twice.

Word inserts the new Table of Contents based on your own marked phrases at the insertion point.

Microsoft Excel

Use Excel's Autofill to generate a series of dates

Microsoft Excel 2002 and 2003's Smart Tag feature makes it easy to insert a series of dates into a worksheet. For example, suppose you want to keep track of the total daily donations that come into your organization during the work week. You can generate a series of dates that includes weekdays only by following these steps:

Enter the beginning date of 10/3/05 in Cell B3.
Drag B3's Fill handle while pressing the right mouse button to B50.
Click the Smart Tag and select Fill Weekdays.

You can also use Autofill to generate a series of dates for entering total donations on a monthly basis--just choose Fill Months after clicking the Smart Tag.

To track donations on a weekly basis, say every Friday, follow these steps:

Enter the date of the first Friday of the month (e.g., 10/7/05) into cell B3.
Enter the formula =B3+7 into B4.
Drag B4's Fill handle down to B50.

You'll be amazed by how much time (and work) Autofill will save you over the course of a month.

Microsoft Access

Link a picture to your Access form

There may be times when you want to add an unbound picture (such as your company logo or product image) to your Microsoft Access form. It's easy to add pictures to forms with the Image control. However, an embedded form object can take up a huge amount of space in your database.

To save space, try linking the image to the form, rather than embedding it. Here's how to link a picture to your form:

Open the form in design mode.
Click the Image button in the toolbox.
Click and drag to insert the image on the form.
Navigate to the image file containing the picture you want to link to, select it, and click the OK button.
Right-click the image and select Properties.
Click the Picture Type drop-down arrow and select Linked.

Note that the image file must be available in the Samples folder when the form is running; otherwise, the image will not be displayed.