maryannrichardson, Author at TechRepublic

maryannrichardson

Latest from maryannrichardson

Software

Use Excel to calculate the hours worked for any shift

With Microsoft Excel, you can create a worksheet that figures the hours worked for any shift. Follow these step-by-step instructions.

Software

How to transfer data from Word forms to an Excel worksheet

Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard, you can quickly step through the process.

Software

Copy hundreds of rows of Excel formulas in three steps

Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock out the task for you.

Software

Use the Access Office Links tool to convert a report to an Excel worksheet

Here's a quick and easy trick for getting your Access report data into Excel - organized just the way you want.

Software

Add sounds to your Access form events

Your forms don't have to be silent and boring -- Access lets you play a sound for any form event. Here's a quick look at how you can set up Access to play a sound each time a user opens or closes a form or clicks on a form control.

Software

Prevent Excel from turning fractions into dates

Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem.

Software

Automatically fill in Access text boxes based on a combo box selection

You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user chooses that person's last name from a list.

Software

Move text to the next column permanently

Word may not be a full-featured layout program, but it does offer some tools that let you control the position of text on the page. See how to use a column setting to get that text where you want it (and keep it there).

Software

Clear an Access combo box for entering the next record

You can have Access clear the selection from a combo box in a data entry form so that the user starts fresh with each new record. See how to make this user-friendly tweak.

Software

Add data to an Excel worksheet from a Word table

If you have a workbook containing data that originates in Word, you can keep the data current with the help of Excel's Import External Data wizard. Here's a look at how to put this handy feature to work.

PURPOSE This Media disposal policy from TechRepublic Premium provides specific instructions for ensuring organization data is properly protected when disposing of old storage media. From the policy: POLICY DETAILS When disposing of damaged, unusable, obsolete, off-lease, decommissioned, old, or end-of-service-life equipment and media, the organization requires that the guidelines outlined herein be followed: Hard drives, ...

PURPOSE To take some of the effort out of writing (and rewriting) emails to share with company staff and executives, TechRepublic Premium has assembled basic templates to handle the most common types of communications. Simply copy the text into your favorite word processor and customize it to fit your needs. Then, paste it into an ...

PURPOSE The purpose of this policy from TechRepublic Premium is to provide guidelines for developing mobile applications from a security, procedural and best practices standpoint. While it contains technical guidelines, it is not intended to serve as a programming guide but as a framework for operations. This policy can be customized as needed to fit ...