Monthly Archives: September 2016

Records in FileMaker

In Chapter 3, “Exploring FileMaker Pro,” you became familiar with the FileMaker Pro application environment. You learned about the commands that FileMaker Pro provides and the various ways that you can access them.

In this chapter, you use what you learned to explore and work with the database you created. You change, add, and delete records; navigate through records and layouts; and much more. This chapter provides you a more thorough understanding of how to use a FileMaker Pro database.


Changing an Existing Record

When you created the Contacts database, FileMaker Pro automatically added the first record for you. With the exception of the First Name field, the record is empty. Let’s change that record by entering data in the fields.

  1. Click the Title field. A drop-down menu displays. Here, you can select a title. Select a value from the list. Notice that the field has a thin highlight around it. That’s how you can tell which field you are in.
  2. Click the First Name field. Enter your first name in the field.
  3. Click the Last Name field and enter your last name.
  4. Save the changes that you made to the record. In database terms, we refer to the act of saving changes to a record as committing the changes. To commit your changes, click anywhere in the content area of the window where a field or button isn’t present.


Adding a New Record

Let’s add a new record to the database. As you might have guessed, FileMaker Pro provides several ways to add records, including

  • Click the New Record button in the Status Toolbar.
  • Select the New Record command from the Records menu.
  • Use a keyboard shortcut. On a Mac, the shortcut is Command+N, and in Windows, it is Ctrl+N.

After you choose one of the previous methods, a new record is created. Again, with the exception of the First Name field, the fields are blank. Click the fields to enter some values.

Using Photos for Mac

It used to be that importing photos into a photo application was a big pain. Every different source of the photographs—hard drives, digital cameras, mobile phones—seemed to have a different, complex import process. With the latest version of Photos, Apple has simplified importing and, at least as far as devices go, after you know how to import from one source, you know how to import from the others.


Migrating an iPhoto or Aperture Library to Photos for Mac

If you have previously used iPhoto or Aperture and are switching to Photos, you need to know how to migrate your photo library into Photos.


Migrate a Library to Photos

  1. After launching Photos for the first time, click the Get Started button to open the Choose Library screen.
  2. From the list of iPhoto and Aperture libraries, select the one you want to migrate into Photos.
  3. Click the blue Choose Library button to open the Preparing Library screen that lets you know how much more of your old library needs to be migrated. This could take as little as a few minutes to over an hour depending on the size of your library. When it’s complete you’ll be taken right to the new Photos app.

Themes feature in Office

Microsoft introduced themes back in Office 2007, but sad to say, most people don’t understand themes today any better than they did back then. They could tell you that a theme has something to do with styles, formatting, and colors, but if you press them for details, you get averted eyes and foot-shuffling. Is a theme built into a document, or is it a separate file? Is a theme the same thing as a template? How do you share themes between applications? In this article, I hope to clear up some of the persistent confusion around what exactly a theme is and how it does its magic.


What is a Theme?

A theme is a named group of settings that you can apply to a document to change its appearance. At a minimum, it includes three elements: colors, fonts, and effects. (In PowerPoint, your choice of theme also affects a couple of other aspects of the presentation, such as background image and variants.) Themes have names, such as Facet, Integral, and Ion; these names are the same across Word, Excel, and PowerPoint, so you can use the same theme in each application for consistency.

A theme is not the same as a template. A template is an entire document file (or workbook, or presentation), but with a different extension to designate it a template rather than a regular document. It’s a full-fledged reusable sample. A theme, on the other hand, is just a collection of settings that can be applied to a document.

Is a theme a separate file? Well, it depends on what you mean by theme. The word can refer to the current theme settings in a Word, Excel, or PowerPoint document file, and in that sense, a theme is contained within the document to which it is applied. But theme can also refer to a file with a .thmx extension that stores theme settings independently of any data file