Now that you’ve created a FileMaker Pro database file, let’s explore how the data is presented.
Your converted database file is displayed in what FileMaker Pro calls Table View, which looks a lot like your original spreadsheet, with similar rows and columns.
However, FileMaker Pro uses different words for these concepts:
Your spreadsheet as a whole has become a table. Tables consist of organized information that describes some category, such as people, activities, or transactions. The table you imported describes the customers of a landscaping business.
Rows are called records. Each record represents an instance of your table’s category. In the data you imported, each record represents an individual customer.
Columns are called fields. A field is a place to store a specific piece of data, like a text value or a number. In the data you imported, the Customer field contains the company name and the Manager field contains the manager’s name.
You can also think of a record as a collection of fields, a table as a collection of records, and your FileMaker Pro database file as a collection of tables.
But none of this data is any use unless there is a way for people to interact with it — to view and change it. In FileMaker Pro, you create a series of layouts, which are the different screens you use to work with the data.
You are currently viewing "Layout #2", which was created automatically when you converted your spreadsheet.
Navigate through the data within your new FileMaker Pro database file.
- Locate the Layout pop-up menu above the Customer No column.
- Choose the Layout #1 option from the menu.
Your screen switches to another layout that was created automatically as part of your file.
Currently, this layout is in Form View. It displays one row — or record — at a time, allowing you to view and work with records individually.
Right now you should be looking at the first record, Bryant Research Park:
- Click the arrows in the book in the upper left of the screen to go forward and backward through several different records.
See how the data changes as a result, showing information about each company, one record at a time.
- Drag the slider next to the book, which lets you move quickly to any record.
- Try typing a record number in the field above the slider and then press the Enter or Return key.
This takes you to the record in the position corresponding to the number you typed. For example, if you type 5 you’ll be taken to the record in the fifth position in the list.