Tech Tip: Create Word booklet/Change Excel default currency/Use Access subdatasheets

by Guest Contributor | Dec 08, 2003 3:17:00 PM

Tags: Guest Contributor

Takeaway:

Word: Create and print a booklet

Word XP makes it easy to create and print a booklet. With just a few clicks of the mouse, Word does the page layout for you; you just have to give Word the number of pages and add the text and graphics.

Follow these steps to create an eight-page booklet that reads from left to right:

1. Open a blank Word document, click File | Page Setup, and click the Margins tab.
2. In the Multiple Pages drop-down list, choose Book Fold. Word will change the document layout to landscape mode and the page size to 8 1/2 inches by 5 1/2 inches.
3. In the Sheets Per Booklet drop-down list, select 8.
4. Change the inside and outside margins of each booklet page as desired, set the gutter size to accommodate the booklet binding, and click OK.

Enter text, graphics, headers, and footers. When completed, follow these steps to print the booklet:

1. Select File | Print.
2. Set your printer for printing on both sides of the paper. For nonduplex printers, select the Manual Duplex check box. For duplex printers, click the Properties button and choose the proper settings for your printer.
3. Click Print.

Nonduplex printers will print the front side of each sheet in your booklet and then prompt you to reinsert those sheets to print on the back of each.

Excel: Change the default currency

If your worksheet's formatting conforms to your regional settings, Excel's Currency button makes it easy to format currency values. This button uses settings from the Regional Options dialog box to set the default format. For example, if the Regional Options are set to English (United States), by default, the Currency button formats currency values for the United States.

Follow these steps to change the Currency button's default county/region settings by resetting them in Control Panel:

1. From the Start menu, open Control Panel, and double-click Regional Language And Options if using Windows XP. If you're working with earlier versions of Windows, double-click the Regional Options icon.
2. Select the country/region you want to use as the default from the drop-down Location list, and click OK.

The next time you start Excel, clicking the Currency button will format the cells in the new format.

In earlier versions of Windows, you may need to restart your computer for the changes to take effect. In addition, changing the region in Windows also changes the settings for time, date, and number formats to those used in that region.

Access: Use subdatasheets to view data in a related table

Subdatasheets let users view related records in two tables that share a one-to-many relationship. For example, in a library database, the Authors table and the Books table have a one-to-many relationship; in other words, each record in the Authors table can have more than one record in the Books table.

Follow these steps to insert subdatasheets to view the related records in these tables:

1. Open the primary table (in this example, the Authors table) and click Insert | Subdatasheet.
2. In the Subdatasheet dialog box, select the related table (in this example, the Books table).
3. In the Link Child Fields drop-down box, select the primary key for the Books table.
4. In the Link Master Fields drop-down box, select the primary key for the Authors table.
5. Click OK.
6. If asked, click Yes to establish a relationship between the two tables.

The subdatasheets are inserted in the Authors Table, which is indicated by a small plus sign displayed in the first column of each record. Clicking the plus sign will display the related records in the Books table.