Archive for October, 2005

Next Page »

“Freezing” Rows and Columns in Excel

October 21st, 2005

When you are editing a large spreadsheet, you may want to lock the row or column headings into place so that they don’t scroll when you scroll the other cells in the worksheet. Excel calls this freezing panes. You can freeze any number of rows at the top of the screen or any […]

Changing the Default Font in Word

October 21st, 2005

To change the default font for all future blank documents:

Select a font in the Format | Font dialog box.
Click the Default… button.
Word will warn you that you are about to make a change in the Normal Template.
OK.

All documents created with the NORMAL.DOT template (the standard template) will use the new default font.

Excel Quiz Question

October 21st, 2005

2 + 3 * 4 =
Which is the correct answer?
a.) 24
b.) 20
c.) 14
If you were paying attention in junior high school math class, you know about the Order of Operations, which dictates that formulas evaluate multiplication and division before addition and subtraction.
Therefore, Excel reads this formula as 2 + 12, not 5 […]

Create a Photo Album Presentation in PowerPoint

October 19th, 2005

Have you ever wanted to use PowerPoint to show a collection of pictures? PowerPoint contains a Photo Album feature exactly for this purpose. There’s no need to insert the pictures one slide at a time. PowerPoint will even take the pictures directly from your digital camera!
Here’s how:

If you want to create […]

Black Out or White Out the Screen during a PowerPoint Presentation

October 19th, 2005

If you want to pause during a PowerPoint presentation for a break or for a discussion, you can black out the screen by pressing the B key. Press it again to return to the presentation.
In a light room, you can white out the screen by pressing the W key. Press it […]

Create a PowerPoint Presentation with the AutoContent Wizard

October 19th, 2005

You can use the AutoContent Wizard to create a new PowerPoint presentation if your content is close to one of the AutoContent options, such as a marketing plan, a project overview, or an employee orientation package.
The AutoContent Wizard prompts you for information and then creates a complete presentation based on your responses. The presentation […]

Compacting and Repairing a Database

October 19th, 2005

As you work with a database, it can become fragmented so that it uses disk space inefficiently. Compacting the database rearranges the way the database file is stored on the disk so that it takes up less disk space and works more efficiently.
In addition, it’s possible that your database can become damaged or […]

Four Important Tips for Designing Databases in Access

October 18th, 2005

Here are some general tips for designing and maintaining databases from one of our experts:

When developing forms and reports, focus on functionality first. Once things are working correctly, then you can make them look pretty.
When designing tables to hold contact information, try to break information down into its parts.
Separate name into FN, MI, LN, and […]

“Splitting” a Database

October 18th, 2005

When database development is finished, split the database, putting tables in the “back-end” database, and forms, reports, queries, etc in the “front-end”.
Just open the database and go to Tools>Database Utilities>Database Splitter, and follow the instructions.
Splitting improves speed, reliabilty, and convenience, especially in a multi-user environment.

Editing Images with Photoshop from within Dreamweaver

October 16th, 2005

If you like to edit images on your Web site with Photoshop, it’s easy to make Dreamweaver use it as the default image editor.
First, you have to select Photoshop as your primary image editor for jpgs (and gifs, etc.). To do so:

Select Edit | Preferences.

From the Category list, select File Types/Editors.
Select the file […]

Next Page »