Access 2010 – Printing Labels

By Karen Williams | November 29, 2015 | | 3

Labels are necessary for every office whether it’s for labeling file folders or creating mailing labels fordirect mail campaigns. However, it can be tedious and time-consuming to re-type labels every time you need them. Microsoft Access provides a label creator that can be used to design labels for any use in an easy and efficient manner. Open the Access database containing the information you wish to include on your labels.[…]

PowerPoint Tip – Adding a Whiteboard to your Presentation

By Karen Williams | October 1, 2015 | | 7

During a live presentation, it might be necessary to take notes. Perhaps you are directing a brainstorming session to develop marketing ideas for new products. You’ve created a presentation that gives an overview of each product, and in the past, you’ve written the group’s ideas on a whiteboard or large notepad. Wouldn’t it be more convenient to take notes within the presentation? PowerPoint 2010 has a white board feature that[…]

Protected: Crystal Reports 2013 Tip: Using a Dynamic Array Variable

By Andy Weaver | September 12, 2015 | | 0

There is no excerpt because this is a protected post.

Outlook Tip – Delegate Email and Calendar Access

By Karen Williams | September 3, 2015 | | 1

Inevitably, there will be times you need to be away from your office. Sometimes these are planned events like vacations; other times they are unexpected such as medical or family emergencies. In either case, it may be necessary that one or more people have access to various functions in your Outlook account to ensure timely responses to internal and external clients as well as schedule management. Microsoft Outlook allows you[…]

Access Tip – Include Attachments in a Database

By Karen Williams | July 3, 2015 | | 1

There are times when it can be beneficial to add a file to your database such as documents, presentations and images. With Access, you can use attachments to store several files of various types in a single field. For example, if you manage a vendor database, you can attach the vendor’s logo as well as their pricing sheet. Add an attachment field in Design View To use attachments in Access,[…]

Crystal Reports: Set the Default Formula Language

By Sanjay Nasta | March 23, 2015 | | 1

Are you tired of setting the formula language you want to use every time you create a formula? The formula editor will use the Crystal syntax option by default. To change the language, select File > Options and then click the Formula Editor tab. Use the drop-down list at the bottom of the window to select your default formula syntax.

Word – Adding and Removing a Bottom Border

By Karen Williams | March 4, 2015 | | 2

When creating a document, borders assist in giving documents a professional edge as they clearly define the organization pattern. Word offers a handy option for inserting an automatic border before or after a paragraph. Type three hyphens on a blank line and press Enter. If the option is enabled, Word will replace the hyphens with a horizontal line. To remove the line, press Ctrl Z after Word inserts it. NOTE:[…]

Microast Excel Tip: Removing Duplicate Data

By Karen Williams | June 24, 2014 | | 4

It’s not unusual to have duplicate occurrences of data in a spreadsheet, and there are numerous reasons why they might need to be removed. More importantly, you want them removed quickly so you can start analyzing the data. Luckily, there are various methods of locating and removing duplicate data in Microsoft Excel. Note: Because you are permanently deleting data, it’s a good idea to copy the original range of cells[…]

Outlook 2010/2013 Tip: Insert a Screenshot in a Message

By Karen Williams | April 14, 2014 | | 14

A picture is worth a thousand words, so why not save yourself from typing a thousand words by inserting a screenshot instead? No need for extra programs to capture and crop your screenshots. You can easily e-mail a picture of a dialog box, browser screen, or anything else that appears on your desktop by following these simple instructions in Outlook 2010 or Outlook 2013. Begin by creating a new e-mail,[…]

Microsoft Word: Setting the Distance between Text and Borders

By Karen Williams | February 12, 2014 | | 4

One common formatting effect within Word is the application of borders around a paragraph. Word allows you to apply borders to all four sides of a paragraph—you can even have the borders be different from each other, if desired. After applying border formatting, you may decide that you need some more room between the actual border lines and the text within the paragraph. You can easily adjust this distance by[…]