Every FileMaker Pro database has two things in common: One, it stores heaps of information; and two, it gives you the tools to manage that information. Whether you start from one of FileMaker's templates (Section 220.127.116.11) or a completely blank slate (Section 1.2.1), your new database starts out data-free. It's an empty vessel waiting to be filled. (It would be nice if the program could figure out what data you want and enter it for you, but that probably won't happen until FileMaker Pro 8008.) You have to take care of the data entry yourself. At first, all you see in the window are the toolsbuttons, controls, and pop-up menusthat you use to fill the database up with data.
Every database window has the same basic structure. FileMaker provides a handful of special items around the window, as you can see in Figure 1-1.
1.1.1. Content Area
While some features like the status area, zoom controls, and Mode pop-up menu stay the same no matter which database you're using, what's inside the content area is the actual information (data) that makes each database unique.
When you create a new FileMaker database, you start with something that looks a little like Figure 1-1: plain and simple. That's because you haven't added any content yet. In Figure 1-2, you can see what your database will look like once you've started to fill it in. Depending on how you want to look at your information, you can use the controls described below to alter how your content appears onscreen.
1.1.2. Mode pop-up menu
This unassuming menu may not be the most prominent control in the window, but it's one of the most important. Each of FileMaker's four modes is a work environment unto itself, specially designed to help you view, edit, organize, or present your information in a specific way. Use this menu to switch modes depending on what you need to do.
To use the Mode pop-up menu, just click it and choose one of the four modes. Your FileMaker window instantly switches to the new mode. You can also glance at the pop-up menu to see which mode you're currently in. (The Mode pop-up menu is the most popular way to mode-hop, but there are plenty more; see the box on Section 1.2.)
18.104.22.168. Status area and the status area control
No matter what mode you're in, the status area (Figure 1-1, left) is your central command center. This slim panel lets you see how much information you've got in your database and your current position within it. It also has the controls you'll use most often for both adding information to your database and accessing it later. If you're like most people, at some point you'll come to resent the fact that the status area takes up so much space on your screen. Despite the fact that it usually contains just a few numbers and icons, it eats up a good inch of space along the entire left edge of every window. Luckily, you can easily conceal the status area when you don't need it, as shown in Figure 1-2.
|UP TO SPEED
A Tour of the Templates
FileMaker Pro's standard templates make it easy to perform routine tasks found in typical businesses, schools, and homes. Just choose a template and get right to work. Chances are one of the 40 templates built into FileMaker is set up to manage the kind of information you're working with, so you waste no time on setup. Here's an overview of the nine basic template categories:
22.214.171.124. Zoom controls
One of FileMaker's neatest features is the zoom control. No matter what you're doing, you can always zoom in for a closer look or zoom out for the big picture. This feature works no matter what mode you're ineven when you're previewing a printout.
To use FileMaker's zoom control, click the Zoom In button for a closer look (each click zooms in a little more). You can zoom in up to 400%, so that everything is four times bigger than normal. If you click Zoom Out, everything shrinks, as small as one quarter of its normal size. The Zoom Level shows your current level, and clicking it takes you back to 100%. Clicking the Zoom Level a second time returns you to the last zoom level you were viewing (see Figure 1-3).
Note: Since you probably don't need to examine the words and numbers in your database on a microscopic level, you'll probably use the zoom control mostly in Preview mode to fit the whole page on the screen, or to adjust the contents of your FileMaker window to the most easily readable size (depending on the resolution of your monitor).
126.96.36.199. Scroll bars
Every window has horizontal and vertical scroll bars that appear whenever you have more content than the window can display. (For an example, see Figure 1-3.) If everything in the content area fits in the window, you won't see scroll barsafter all, you don't need them. FileMaker's scroll bars work just like the ones in any other program, and you can use your keyboard to scroll up and down as well. Press Page Up to scroll up one screenful. Page Down scrolls the other direction. To scroll all the way to the top or bottom, use the Home and End keys respectively. (Don't toss out your mouse yet, though. There's no way to scroll right or left with the keyboard.)
If your mouse has a scroll wheel, you'll notice that it works a little differently in FileMaker. What you scroll through varies based on where you put your mouse cursora feature called contextual scrolling. The wheel scrolls through the window when the cursor is inside the content area of the window. It scrolls through the records in your database if you run the cursor over the Book icon in the Status area (Section 188.8.131.52). And if you put your cursor over a field that has a scroll bar (Section 184.108.40.206), the scroll wheel scrolls through the text in the field.
Note: Don't be alarmed when the menus across the top of your screen change a bit when you switch modes. That's just FileMaker being smart. Some commands aren't useful in some modes, so the program doesn't clutter up your screenor your brain spacewith menus when you don't need them. For example, the Insert and Format menus change from black to gray (meaning unavailable) when you enter Find mode. The Request menu, though, appears only in Find mode.
|UP TO SPEED
Switching between FileMaker's four modes is such a common task that the program actually gives you four ways to do it. The Mode pop-up menu (Section 1.1.1) is just one way. You can also use the Mode tabs in the status area (shown here at left), or pick a mode from FileMaker's View menu (right).
The keyboard shortcuts are speediest of all:
If you ever forget these shortcuts, check the View menu to refresh your memory.
FileMaker also gives you several ways to find out which mode you're in. The Mode pop-up always displays the current mode, and since it's always visible, it's the easiest place to check your mode. But the Mode tabs also reveal the current mode, and the View menu indicates the current mode with a checkmark. So when you return to FileMaker after checking email, you've got plenty of ways to reorient yourself.
Part I: Introduction to FileMaker Pro
Your First Database
Organizing and Editing Records
Building a New Database
Part II: Layout Basics
Advanced Layouts and Reports
Part III: Multiple Tables and Relationships
Multiple Tables and Relationships
Advanced Relationship Techniques
Part IV: Calculations
Introduction to Calculations
Calculations and Data Types
Part V: Scripting
Part VI: Security and Integration
Exporting and Importing
Sharing Your Database
Part VII: Appendixes
Appendix A. Getting Help