Are you looking for a presenter for your next meeting?

We are Tampa-area hobby genealogists who also happen to work in the software industry. We have used our knowledge of software to present our own family research in various formats and forums. And we can show you how to do it too.

We offer a number of presentations and a book-related workshop. Most of our presentations revolve around using one or more Microsoft products to accomplish a genealogy-related task. Lately, we've been using lots of Google applications too.

So check out our presentation list and see if there's something we can do to help your members. When you find a presentation you're interested in, email us at info@technology-tamers.com.

Wednesday, May 8, 2013

Four Generation Chart in Word SmartArt...Using Chart and Resizing Boxes


Click here to see post 1 in this series--The Introduction.
Click here to see post 2 in this series--Layout Page and Insert SmartArt
Click here to see post 3 in this series--Altering the Chart
Click here to see post 4 in this series--Word 2003

Using the Chart
The point of having created the form is that you're going to want to use it repeatedly rather than having to create the chart every time you want to fill out one for a family. So you will want to save a copy of the chart you created under a new name prior to completing the chart.

Note: If you've created a form that only you will be using, you might want to complete the contact information in your master copy so that information is there when you open the chart.

To use the chart:
  1. Save a copy of the chart under a new name. 
  2. In boxes, double click placeholder text and type in the real information. As you fill the boxes with text, you'll notice that the text flows outside of the box. Don't worry. We'll fix this later.
  3. Save your chart and resize boxes. 

Resizing the Boxes
When you resize, you need to resize all of the boxes in a column at the same time. Resizing based on columns gives you a consistent display.

To select the boxes in a column:

  1. Click in the first box. The handles (circles and squares) appear. 
  2. Hold down the Shift key, and click in the border of the second box. The handles for the second box appear. You'll know you're clicking in the right spot because your cursor will change to a four-headed arrow. 
  3. Repeat step 2 until you have all of the boxes selected. Your screen will look similar to this one.

    Handles are the circles and squares inside the orange squares and circles. 
To resize boxes in a column: 

  1. When you selected the first text box, the SmartArt Tools tab opened on the ribbon. 
  2. Select the Format tab, and locate the Size group.
  3. In the Height field, click the up and down arrow beside the field to increase and decrease the height of the selected boxes.
  4. In the Width field, click the up and down arrow beside the field to increase and decrease the width of the selected boxes.
  5. When you have the arrangement you like, save (Ctrl + S). 

If you find that you can't adjust the height or width, it's most likely because the layout is getting cramped and Word isn't letting you make the adjustment. You might want to consider using abbreviations or otherwise altering the presentation of the information in boxes.

So good luck with resizing. I'm sure you'll do fine. It's easy...you just have to know the trick of how to select multiple boxes to apply the change to all of the boxes in a column.

I'll continue hacking around and seeing what additional functionality you might need.

Wednesday, May 1, 2013

Four Generation Chart in Word SmartArt...Word 2003 options


Click here to see post 1 in this series--The Introduction.
Click here to see post 2 in this series--Layout Page and Insert SmartArt
Click here to see post 3 in this series--Altering the Chart

I had a few minutes today on the computer where I have Word 2003 installed. So I went poking around. While you don't have as many choices as you do in more recent versions of Word, it's not as limited as I originally thought.

Here are the menu selections you make to get to the charts in Word 2003. Word automatically inserts the default organization chart.



In addition, Word displays the Organization Chart toolbar. If you click outside of the chart area, the toolbar closes. To open it again, click inside of the chart area. 


This chart works like all of the others I've been talking about. Click in a box and start typing text. 


Adding boxes in Word 2003 is different. You use options (Assistant, Coworker, Subordinate) from the Insert Shape drop-down list to add boxes in different locations.

If you want additional options for formatting, click the Auto Format button to display the chart style gallery. Pick a style from the gallery to see how it changes your chart.


Use options on the Layout drop-down to change the arrangements of the boxes. 

So there you have some of what you can do in Word 2003. I'll pick up writing about the Word 2007/2010 versions in my next post. 

Wednesday, April 24, 2013

Four Generation Chart in Word SmartArt...Altering the Chart


Click here to see post 1 in this series--The Introduction.
Click here to see post 2 in this series--Layout Page and Insert SmartArt

As noted in my last post, you can use two different methods to alter the graph.
  • Replace [TEXT] with the text you want.
  • Add text using a text dialog. 
In addition, you can use the text dialog to add new text boxes to the chart and rearrange text boxes to alter the display.

Default Hierarchy Chart

Template You Want to Create
The double arrows that you click to open the text dialog are circled in this graphic.

To replace [TEXT]: 
  1. In the chart, click [TEXT] in the first text box. 
  2. Type the following text:
    --Name, and then press the Enter key.
    --b. DatePlace, and then press the Enter key.
    --d. DatePlace, and then press the Enter key. 
This method is fine as long as you don't want to add boxes or adjust the display. To do that you need to display and use the text dialog. 

To use the text dialog:
  1. Click anywhere inside the chart but not in a [TEXT] box.
    --The chart frame appears, with double arrows on the left side of the frame.
    --The SmartArt Tools tab opens on the ribbon with two tabs: Design and Format. 
  2. Click the double arrows and the text dialog opens. The double arrows are circled in the graphic above.
  3. In the text dialog, click the first [Text] entry and type the following text:
    --Name, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace.
    You may have already completed this step above when you replaced [TEXT] directly in the graphic. 
  4. Click the second [Text] entry and type the following text:
    --FatherName, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace
  5. Click the third [Text] entry and type the following text:
    --Grandfather, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace
  6. Click the fourth[Text] entry and type the following text:
    --Grandmother, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace
  7. Add a new [Text] entry to create a parent entry for the paternal grandmother.
    --Press the Enter key. Word adds a [Text] entry below the Grandmother text entry.
    --On the SmartArt Tools tab, click the Design tab.
    --In the Create Graphic group, click Demote to move the [Text] to the fourth column position.

  8. Type the following text:
    --GreatGrandfather, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace
  9. Press Enter to add a new [Text] entry, and then type the following text:
    --GreatGrandmother, and then press the Shift + Enter combination.
    --b. DatePlace, and then press the Shift + Enter combination.
    --d. DatePlace
  10. Add the great grandparents for the grandfather.
    --In the chart, click once in the Grandfather text box. In the text dialog, Word moves your cursor to the Grandfather text entry.
    --Be sure to click your cursor at the end of d. DatePlace.
    --Press the Enter key. Word adds a [Text] entry below the Grandfather text entry.
    --On the SmartArt Tools tab, click the Design tab.
    --In the Create Graphic group, click Demote to move the [Text] to the fourth column position.
    --Complete the GreatGrandfather entry.
    --Press the Enter key. Word adds a [Text] entry below the GreatGrandfather text entry.
    --Complete the GreatGrandmother entry. 
  11. Repeat steps 7 to 10 to add more [Text] entries and text boxes and use the Demote (or Promote) buttons to arrange and rearrange text boxes in columns one, two, three, and four. 
You might need to fuss with the Demote and Promote buttons to move text boxes around in the graphic to get the four column display that you see in the samples above. 

As long as you have the text dialog open, each time you press Enter, Word adds a new text entry and a text box to the graphic. If you close the text entry dialog (click the X in the upper right corner of the dialog), you can click in a text box and press Enter as you add text to the box. However, you should notice that you affect the spacing in the text boxes. 

In these instructions, I've had you add text using the text box as we went along. Another option you have is to use the text dialog to add and arrange all of the text boxes you need in the graphic, and then close the text box and click in each text box to create your template...clicking Enter after each entry or Shift + Enter, depending on the spacing you want.

The other thing you should notice is that each entry has one word placeholder text; for example, DatePlace. When using the form, you just double-click the one word and start typing. The text dialog opens automatically. You can use it or ignore it and type only in the text boxes. 

Any of the hierarchy charts that you pick will work the same way as the one you've completed for this post. In subsequent posts, we can look at additional things you can do. For example, you might need to resize text boxes to accommodate your text.  

Sunday, April 21, 2013

Four Generation Chart in Word SmartArt...Layout Page and Insert SmartArt

Click here to see post 1 in this series--the introduction.

I'm going to walk through the steps for creating the four generation chart template. After you have the template, you can complete it to create four generation charts for families. 

Layout Your Page

  1. Open Word. The default Normal template displays automatically. Remember that this template is the lowest level template with just a few styles...the starting point for lots of documents.
  2. Select File, Save As, and name the document Four Generation Chart.
  3. Display the Page Setup dialog.
    --Word 2003: Select File, and then Page Setup.
    --Word 2007/2010: Select the Page Layout tab and locate the Page Setup group. Click the small arrow in the lower right of the group (group launch button).
    The dialog appears with the Margins tab displaying by default.
  4. In the Margins group, enter .5 for the top, bottom, left, and right margins. Since this document is a chart, you are going to want to use as much of the surface area of the page as possible.
  5. In the Orientation group, select Landscaped.
  6. Click OK, and then save your document. 
Inserting SmartArt

  1. From in Insert menu, click SmartArt to open the SmartArt dialog.
  2. Select Hierarchy, and then select Horizontal Hierarchy
  3. Click OK. The graphic opens in your Word document. 
  4. Save the document. 

Doesn't look like much at the moment does it? In my next post, we're going to replace [Text] with entries that create a template and we're going to rearrange and add boxes. Depending on what you are doing, you'll use two different methods to affect what appears in the graphic. 

So stay tuned for upcoming posts.

Update 
I included Word 2003 in the page layout instructions above. However, Word 2003 options for this process are very limited. You have only one hierarchy chart that you can use. I'm going to have to work with it to see what you can do with it to make a template. 

Saturday, April 13, 2013

Four Generation Chart in Word SmartArt




  1. Click here to download a copy of this four generation chart (Word 2010).  SkyDrive opens. 
  2. Select File, Save As. A Download button appears.
  3. Click the Download button and complete the download to your system.
  4. If the SkyDrive Enable Editing button appears, click it to begin using the form. 
  5. To complete the form, double-click placeholder text and replace it with your personal text. 
Over the past few weeks, I've been trying to create a generational chart as a fillable form and bombing. When you find that you can't do a task one way, it's worth stepping away from the keyboard for a break. Sometimes, you get struck with inspiration.

I don't have occasion to use SmartArt very often. I just don't use that sort of thing in my professional or personal life. However, there are hierarchy charts that bear a striking resemblance to the charts that genealogists use. So I started playing around and I've discovered you can use SmartArt to produce a number of different types of charts, including the one above, which you can download if you're using Word 2010.

Here are a few more charts that I created using SmartArt on the fly.



So now I'm on a learning curve, trying all of the buttons that turn up on the Design and Format tabs of the SmartArt Tools context sensitive tab. I'll try to share what I'm hacking my way thru in an orderly fashion. I'm also going to have to look at how clipart can be used in conjunction with SmartArt

To display these charts, open an MS Word document and make the following selections: Insert, SmartArtHierarchy. A preview of the pre-formatted charts opens. Select one to begin using it. 

Completing one of these charts is kind of a fun mindless task that I'm doing while watching TV. 

Tuesday, April 9, 2013

Date Calculator...in Windows 7...Way Cool...

In the Facebook group, Technology for Genealogy, Michelle de la Chevrotiere-Eber pointed out that the calculator that's built into Windows 7 is genealogy friendly. I got curious and started clicking and Michelle has unearthed an interesting little item. So here are the instructions.

To display and use the date calculator:
  1. Click the Start button, and select All Programs, Accessories, and then Calculator.  The Standard calculator displays.
    Other option...Click Start. In the Run field, enter calculator, and press the Enter key. 
  2. Click the View tab. 
  3. Select Statistics in the first group, and Date calculation in the third group. The calculator updates with a date calculation pane to the right. 
  4. In the From field, enter the date mm/dd/yyyy or click the drop-down arrow and pick the date from the electronic calendar (button to the right of the field). 
  5. In the To field, enter the date mm/dd/yyyy or click the drop-down arrow and pick the date from the electronic calendar (button to the right of the field).
  6. Click the Calculate button. The system returns:
    --the difference in years, months, and weeks
    --the difference in total number of days

Today is my birthday and I've been alive 22,646 days...62 years. Since it's a computer, I'm assuming leap year days are included.

To return to the Standard calculator, select Standard and Basic from the View tab.

Alas, now I'm going to be clicking all night to see what else is there...

Wednesday, April 3, 2013

Pin4Ever...Pinterest Backup




Success always brings spinoff businesses. Thus we have the launch of Pin4Ever, which is a backup service for Pinterest. You create an account, run a backup, and you're done. Click here if you're interested in trying this free trial. If you like the free trail, the service is moderately priced ($19.99 per year).

If you're in business and want to have a backup of your pins, $19.99 is a drop in the bucket. If you're a casual pinner, I can't see where you'd be all that interested. You can always create a PDF of your boards but that requires more than the one-click Pin4Ever solution.

Click here to see the post on creating PDFs of Pinterest boards.

Thursday, March 28, 2013

Fillable Ancestor's Chart

I'm still messing around with fillable forms. The latest one I've been messing with is an ancestor's chart.

You can set it up easily enough but filling it out is a bit weird because your cursor moves from field to field in row sequence. I'm not sure that I like that sequence.

The form works like the previous form you may have downloaded from this blog.

  • Click Tab to move your cursor to the next field.
  • Click Shift + Tab to move your cursor to a previous field. 
The Form
If you download this form, you'll download a fully functioning MS Word 2010 document that is protected, which prevents editing of the form layout but lets the person who is using the form complete the name, place, and date fields.

Here's what a person trying to use this form would do:

  • Download the form; for example, the person might download an email attachment--the form--from an email you sent to the person.
  • Open the form and add names, dates, and places to the form. Because the form is protected, the person completing the form won't be able to change anything else in the form other than the names, dates, and places.
  • Save the form under a new name. 
  • Return the form by attaching it to an email. 
The entire exchange of information is electronic.

If you, as the owner of the form, want to make changes to the form, you need to stop protection. Click here to see the post on this blog that talks about enabling and disabling protection.

The password to stop protection is form.

If you happen to mess up the form while editing, download another copy and try working with the form again.

Getting the Form
Click here to download a protected copy of the form. I've loaded the form on my SkyDrive to make it easy to deploy. However, that still means I have to make the right choices when creating the link. Email me (info@technology-tamers.com) if the link doesn't work well.

After the form opens in your browser, select File, Save As, and then click the Download button. Save the form to a location on your PC or laptop.

I'm liking my SkyDrive for deploying documents but I'm still in a bit of a learning curve. So please bear with me.

I hope you find this form useful. If you have a suggestion for a form, please send it along. I'll be happy to take a stab at creating it for you. You just need to give me a bit of time to play around with it.

Update...A Variation...

Hmmm...If I make the font smaller and put the fields in columns rather than a table, anyone filling in the form has their cursor move thru columns rather than rows.

Click here if you want to download a copy of this version of the ancestor chart.

Update to the Update...A Variation...
 
 
This version uses five columns, which should mean that you fill it out in order; that is, person, father, mother, and so forth. 

Click here if you want to download a copy of this version of the ancestor chart.

Thursday, March 7, 2013

Fillable Family Group Sheet

When I check the statistics on this blog, there seem to be lots of queries for these types of forms. As a convenience, I have set up a download from my SkyDrive account for the form I created for an earlier set of posts--a fillable family group sheet.

To download the form:
  1. Click here to open a copy of a fillable family group sheet. The SkyDrive navigation page displays.
  2. Select File, and then Save As. A big Download button displays on the right.
  3. Select Download, and save the form to a location on your system. 
  4. When you open the file, click the Enable Editing button at the top of the page. 
The Form
The form you downloaded to your system is a fully functioning MS Word 2010 document that is protected, which prevents editing. Most forms you find online are PDFs that you can't edit.

If you would like to edit the document, you need to stop enforcing protection. If you need help, click here to see the post that talks about starting and stopping protection.

The password to stop protection is form.

Suggested Use
Confirm that the form is protect from editing. Fill in the fields at the top of the form with your project name and contact info. Save the form and attach it to an email you are sending to a person who you want to have fill out the form. In your email, you might want to include instructions. For example:

The attached form is an electronic fillable form. Save a copy of the form to your system, triple click in the first field to start using the form, complete all of the fields you can, and email the completed form back to me. Thank you for your time and attention to this request.

Post a comment if you have a problem and I'll try to help.

P.S. If you happen to mess up the form while editing, download another copy and try working with the form again.

This sample shows the multi-page form that you can download.

Sunday, March 3, 2013

Genealogy Research Log in Excel

Here are the links to the handouts from the Excel Research Log class yesterday.

Excel 2003
Handout
Sample Spreadsheet

Excel 2007/2010
Handout
Sample Spreadsheet

Hope you find this info helpful.