Would you like to create a questionnaire, sign-up form, quiz or other type of form that people can fill out on their computer? If so, here are some general instructions on how to create a form using Microsoft Word 2011 on your Mac. Once you’ve created the form you can distribute it as an email attachment or via a web site. The recipient could then complete the form on his or her computer and return it to you. Microsoft has instructions about how to create interactive forms in Word 2008, Word 2004 and Word X. Here are some pointers to how to create a form using Word 2011.

By default Word 2011′s Form Control features are hidden. To make them visible you have to enable the Developer tab on the Ribbon. Here’s how to do this:

• Open a new document in Word 2011.
• Click on the Word menu and select Preferences.
• Click the Ribbon button on the bottom row on the right-hand side.
• In the Customize section, scroll through the list and insert a check mark next to Developer.
• Click the OK button.
• Click on the Developer tab on the Ribbon and you’ll see the Form Controls as depicted below.

You can now use these controls in a document. Let’s look at how to use the Text Box, Combo Box and Check Box.

The Text Box lets the form-filler type in their own answer. Click the Text Box option to insert a Text Box into your Word document. Double-click on this Text Box to control its options. For example, you could set a Maximum Length for the recipient’s answer.

The Check Box lets you create a box that can be checked by the form-filler.

The Combo Box lets you enter a list of choices that will appear in a drop-down list. The form-filler can select only one choice. After adding a Combo Box to your Word document, double-click it to be able to enter the choices that you want to offer.

The Protect Form button is very important. After you’ve finished your document click the Protect Form button. This button locks the document so it can’t be edited. In other words, it turns the document into a fillable form. Once you’ve protected the form you’re ready to distribute it to others.

Below is a picture of a sample document which demonstrates the Text Box, Combo Box and Check Box.

Are you unable to install Office 2008 Update 12.2.9 because you’re told you have to quit Sync Services, but you can’t find SyncServices? Use this work around.

In order to get the 12.2.9 update install, I had to stop using Microsoft’s built-in auto-update feature and install do this installation by hand using these steps.

• Download the Office 2008 for Mac 12.2.9 update from Microsoft’s web site by clicking the Download button. The update should be placed in your Downloads folder if your Mac uses Mac OS X 10.5 or higher. It’ll be named Office2008-1229UpdateEN.dmg
• Close and save all open documents and quit all applications.
• Shut down the Mac.
• Safe Boot by holding down the shift key while you start the Mac up. Keep holding the shift key until the gray Apple logo appears on the screen. We’re using Safe Boot to ensure that Sync Services is not running. A Safe Boot takes longer than a normal startup, so please be patient.
• When your Mac has finished starting up double-click the Office2008-1229UpdateEN.dmg file located in your Downloads folder. (Or wherever it is located.)
• Double-click the Office 2008 12.2.9 Update.mpkg to start the installer.
• Follow the on-screen instructions which are displayed. Mostly you just need to click on the Continue and Agree buttons a few times. Eventually you’ll be asked to enter your Mac account’s username and password.
• The 12.2.9 update will be installed. Quit the installer after it has finished.
• Restart your Mac normally. In other words do not do another Safe Boot.

Congratulations. You’re done. The update is installed. You can confirm this by opening Word and then selecting “About Word” from the Word menu. You’ll see version 12.2.9 listed.

You can use Apple’s infrared (IR) remote control to control slideshows in PowePoint 2004, PowerPoint 2008 and PowerPoint 2011. Here are some instructions for getting this setup. PowerPoint 2008 and PowerPoint 2011 both include support for Apple’s remote. PowerPoint 2004 does not natively have this capability. Instead, you need to use one of the third party applications described in this other article. Personally, I’ve used the free iRed Lite.

First, here’s a little background. Starting in 2005, Apple started to ship remote controls with their iMac G5 computers. They then included it with MacBooks and MacBook Pros as well as the Mac mini. Apple’s intended users to use them to control FrontRow which lets user view movies (DVDs), photos and music. I think Apple must have realized that few people actually used the remote controls so they stopped including them with new Macs but they continue to sell the remotely separately for about $20. In 2009 they replaced the original white plastic remote and with a taller, thinner aluminum version. The remotes do have some uses beyond controlling FrontRow. Most commonly, I see them used to control PowerPoint slideshows. For a more thorough history of the Apple Remote check out this Wikipedia article. To learn about third-party products that allow the remote to control more applications and extend its capabilities in other ways, check out this article.

Here are instructions on how to setup the Apple Remote to control PowerPoint 2008:

• Hold your remote control a few inches from your Mac.
• Simultaneously, press the Menu and Next (right-point arrow) buttons for 5-10 seconds.
• Open your PowerPoint presentation and click the Slideshow button to put it into slideshow mode.
• Press the Forward and Back buttons to move through the slideshow. Pressing the Pause/Play button will also advance to the next slide.

If you ever want to unpair your Mac from a given remote you can go to the Apple menu, select System Preferences and then Security and click the Unpair button.

I should also mention that the IR receiver is on by default in all Macs. This means that other people could walk up to your Mac, pair a remote with it and start to control it. This isn’t the worst thing in the world, but it could cause confusion. What really causes confusion is when there are multiple Macs in the same room and one person suddenly starts to use one of Apple’s IR remotes. The remote starts to control all of the Macs simultaneously. I assume this only happens if the Macs have previously been paired with another Apple remote. In these situations it’s useful to know that the Security System Preference pane mentioned above lets you check a box to disable the IR receiver in your Mac.

Have you received a file whose name ends with .docx or .xlsx and been unable to open it on your Mac? These files were created by either Word 2007 and Excel 2007 for Windows or Word 2008 and Excel 2008 for Mac. Thus, one way to open these files is using Office 2008. If you owned this then you wouldn’t have questions about how to open these files, and you wouldn’t be reading this article. Here’s information about two other ways to open .docx and .xlsx files.

Option 1 – Use Microsoft’s free OpenXML Converter. It requires you to have an updated copy of Office 2004 as well as Mac OS X 10.4.3 or higher. This option is the focus of this article. See below for details.

Option 2 – Use Apple’s Pages or Numbers application. They are part of iWork. I believe iWork ’07 or newer is required.

To determine which version of Mac OS X you’re using, you can go to the Apple menu and select About This Mac. The version will be listed in the window that appears.

Go to your Applications folder to see if you have Microsoft Office 2004 installed. Look for the Microsoft Auto Update application as well. Run this application repeatedly until it indicates that all updates have been installed.

Finally, download the OpenXML Converter using this link. On this page, click the yellow “Download Now” button. Then on the next page, you’ll need to select which language version you want from the drop-down menu. After the disk image (.dmg) is downloaded on your Mac, you’ll need to open the disk image and then run the installer package (.pkg) file. Once you’ve finished installing this converter simply double-click on a file whose name ends in .docx, .xlsx or .pptx and the OpenXML converter will automatically be invoked in the background to open the file in Word, Excel or Powerpoint.

Do you have occasional shredding needs that are too much for the shredder that you have in your office or at home? If so, you might like to know about Datasite’s residential shredding services This is an excellent service for Puget Sound small office and home office customers.

[Update May 2012: US Archive and Imaging offers shredding services. Their drop-off center is in Issaquah.]

[Update Jan 2011: I recently learned that most OfficeMax stores offer a drop off shredding service. A press release shows that OfficeMax teamed up with Shred-It to offer this service about a year ago. In my local OfficeMax store I was told that they charge $.59 per pound of paper. You can drop off paper and they'll store it in a secure storage bin. A truck visits their store weekly to pick up the contents of the storage box and hauls it to Shred-It's shredding facility. For small shredding jobs this is the best value I've found. For larger shredding jobs DataSite's drop-off residential shredding service is an even better value.]

[Update Nov 2010: Sip & Ship offers a drop off shredding service. They charge $1 per pound of paper or $10 per bankers box. You can drop off paper at either their Ballard or Greenwood location. The shredding is done at their Greenwood location. I've been a long-time user of Sip & Ship's services which I discuss in this Tech Tip.]

Below are some excerpts from their web site that were current as of early 2010:

DataSite’s Residential Shredding Service meets the needs of the self-employed as well as serving the occasional shredding needs of any resident of the King – Snohomish County area. We recommend shredding your unnecessary bank statements, invoices, utility bills and miscellaneous private information. Clients collect information in a container either provided by DataSite or one of their own choosing.

Our customers may either drop off the collected material at one of two DataSite facilities, or schedule an on-site shredding appointment.

How much does it cost?

For drop-off service there is a minimum charge of $30.00. This is for up to 7 standard letter legal size records boxes (about the size of a copier paper box) or the equivalent.  Additional boxes are charged at $4.00 per box with additional discounts applied for larger volumes.

Document Destruction Boxes DataSite’s new Document Destruction Boxes may be purchased 3 for $25.00.  This includes the shredding once the containers are full.

Once they’re filled simply drop them off at DataSite for shredding.

On-site shredding is available with a minimum service charge of $75.00.

Where are you located?

DataSite has two convenient drop-off locations

Seattle: 9401 Aurora Ave North

Bellevue: 12000 N.E. 8th, Lower Level

How does it work?

Simply bring your sensitive materials to a DataSite facility and come into the office.  A DataSite staff member will bring a mobile locking tote to your vehicle or for larger volumes a pallet.  We do all the heavy lifting.  These materials are staged for shredding later in the day.  You will be issued a Certificate of Destruction for your records.

Do I have to remove staples and paper clips?  Can you destroy computer media?

No – our state of the art shredding equipment handles staples and paper clips with ease.  Report covers, hard bound books and even x-rays are no problem.