Computers & Software

Sorted by:  

Going External with References in AutoCAD 2006

In AutoCAD, an xref, or external reference, is a reference to another, external file — one outside the current drawing — that you can make act as though it's part of your drawing. Technically, a reference [more…]

Using Absolute and Relative References in Excel 2007 Formulas

You can use three types of cell references in Excel 2007 formulas: relative, absolute, and mixed. Using the correct type of cell reference ensures that formulas work as expected when you copy them to another [more…]

Understanding Excel 2007's Formula Error Values

If Excel 2007 can’t properly calculate a formula that you enter in a cell, the program displays an error value in the cell as soon as you complete the formula entry. Excel uses several error values, all [more…]

How to Use the Fn Key on Your Laptop

To make up for a lack of keys, early laptops came with a special function key, the Fn key. This was used in combination with other keys like a Shift key, giving those keys multiple purposes. [more…]

Creating a New User in Oracle9i

Creating a new life is a big responsibility — you have to feed it and change it every day for years. Creating a new user in Oracle9i also carries some responsibilities, but generally the user won't wake [more…]

Getting a Look At Web Services

Web services promise to be the next major frontier in computing. Up until the advent of Web services, interoperability and integration (the exchange of data among computer systems) were extremely limited [more…]

Integrating Access 2003 with Other Microsoft Office Applications

Visual Basic for Applications (VBA) isn't a programming language for Microsoft Access 2003 alone. It's a programming language for all application programs that support Automation. [more…]

How to Set Leader Tabs in Word 2007

There’s only one task that must be done in the Word 2007 Tabs dialog box that you cannot do with the Ruler: Set a leader tab. But what is a leader tab? [more…]

Meeting the Tools in the Visual Basic Toolbox

When you write a Visual Basic program, you first have to design the user interface. Essentially, a Visual Basic user interface consists of objects that you place on the screen and arrange in some semblance [more…]

How to Disable the Infrared Port on Your Laptop

According to computer security experts, some mysterious software out there can tunnel into your laptop via the infrared (IR) port. To stop this from happening, you can disable your laptop’s infrared port [more…]

Working with Code in Visual Basic 2008

Of the programs you create with Visual Studio, most of what you want the user to see are the controls and the forms. But you will be spending most of your time working with code. Fortunately, Visual Studio [more…]

How to Add Titles to Excel 2007 Charts

You can add titles to a chart to help describe its purpose. By default, titles are not added when you create a basic chart, but you can add them later manually. In addition to a main chart title that is [more…]

How to Find Your Laptop’s MAC Address in Windows XP

If you access WiFi networks from your laptop, these networks may sometimes want to know your laptop’s MAC Address. Some wireless networks restrict access to only those computers they know, so the network [more…]

Adobe Creative Suite: Getting Started with InDesign cs

InDesign CS is similar to other Adobe products when it comes to workspace layout and functionality. InDesign works with graphics and word processing programs so that you can use content that's created [more…]

Making a Scene in Google SketchUp

Making a scene in SketchUp is not like taking a snapshot of your model. If you create a scene to save a view, then do some more modeling, and then return to that scene, your model will [more…]

Formatting a Pivot Table in Excel 2007

Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]

Creating and Using Guide Layers in Flash CS3

A guide layer is a layer that's invisible in the final, published Flash animation. You can use guide layers for several purposes: [more…]

Photoshop cs Timesaving Technique: Adding Bevels and Embossing

Photoshop's Layer styles are really fabulous. With a few clicks of the mouse, you can add drop shadows, bevels, textures, patterns, strokes, and more to any layer, type layer, or vector shape on a shape [more…]

How to Move or Copy Files to Another Folder

Moving files and copying files to another folder are straightforward operations. When moving a file, you delete it from its original location. When you copy a file, you duplicate it in another location [more…]

Managing Range Names in Excel 2007

If you’ve created a number of range names in an Excel 2007 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [more…]

Back Up Your Computer

Face it: Hard drives eventually die. To make sure your files, photos, and other important documents are safe, you need to back up your computer to another source [more…]

Components of a Server Computer

The hardware components that a typical server computer comprises are similar to the components used in less expensive client computers. However, server computers are usually built from higher-grade components [more…]

How to Charge a Laptop Battery

You must charge your laptop battery to keep it operational. You charge your laptop battery by plugging the laptop into a wall socket. You can recharge your battery whether the battery is fully drained [more…]

How to Add an Excel 2007 Macro to the Quick Access Toolbar

You can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker access to a macro than using the Macro dialog [more…]

Free Software: Image-Editing with GIMP

GIMP, which stands for GNU Image Manipulation Program, has all the major features of Adobe Photoshop but is available for free under the GNU General Public License. With the GIMP, you can create or open [more…]

Sign Up for RSS Feeds

Computers & Software