Username: 
Password: 
FileMaker Pro 9: Beginner Tutorials

Creating a Database / New Empty File

Subtitles of the Movie

[00:00:00.0] The goal of these tutorials is to teach you how to be a FileMaker developer. Anybody can create a template. All you have to do is go to the File menu and choose New Database and choose a template and you're done. What you want to become is a developer, somebody who can create a file from scratch. Take nothing and make it into something. So that's the goal here, so we're going to go up to the File menu and choose New Database, and you can also choose New Database from the tool bars, but I've actually turned them off. If you want to turn the tool bars on and off, you go to Toolbars and usually ones that's set is standard, and this is probably what you have available right now. There are other tool bars and they change depending on what mode you're in, and we'll get into the modes and you'll see those different tool bars that are available. But a lot of people like these tool bars, I turn them off Ôcause I personally don't like them, I like the menus better. But a lot of people like them and to do a new database, you can just go to this icon right here, and if you hover over it, it'll say New Database. So we can click on that, and that's exactly the same thing as going up to the File menu. All we have to do is choose Create Empty Database, everything dims out, click OK, and now you get this dialog that we showed you in the previous tutorial when we turned off the Quick Start screen. So if you want to turn the Quick Start screen off and just go directly here, well it might be a good idea if you're going to create all of your files from scratch. So eventually down the line, I think you'll get bored of the Quick Start screen and want to turn it off. So you'll remember that's in Preferences. Now, it's very important to choose your name of your file carefully. There are several reasons for that. One is, it's possible to create calculations that reference the name of your file, so if you don't name it properly and you end up changing it, well, then you're going to go ahead and find every reference to it in your database. Now, a lot of references in the database don't really require you to have the same file name, but some do. In addition, if you have multiple files, you can create a one file solution in FileMaker, you know, put all your tables into one file. But if you decide to have multiple files, and a lot of people do that, well, if you change your file name, then you have to change all your references between the files, and that's not that difficult, but really you should plan on deciding what the name is. Do that in your planning stage and stick with that name. So, we're going to call this Contacts.FP7 and save it to our desktop. The dialog you're going to get is the Define Database or Manage Database dialog, it used to be called Define Database in previous versions, now it's called Manage Database, and you'll find it under the File menu, under Manage, and it'll say Database. And, but when you first create your new empty file, it shows you this dialog because there's nothing in here, there's no structure, no schema in here. So you can come back here anytime you want by going to the File menu, Manage, and then off that will be Database, but you really needed to start here, and that's why FileMaker brings you here. And what you have are your tables, your fields, and your relationships, so we're going to cover how to create tables, how to create fields, and how to create relationships all in the following tutorials, so we'll focus in on this particular dialog for quite a while in the upcoming tutorials.

Tutorial Information

Title: FileMaker Pro 9: Beginner
Author: John Mark Osborne
SKU: 33783
ISBN: 1-933736-95-X
Release Date: 2007-07-26
Duration: 12.5 hrs / 145 lessons
Work Files: Yes
Captions: Available on CD and Online University
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

VTC Sign up & Benefits

  • Unlimited Access
  • 70,000 Video Tutorials (14,250 free)
  • Video Available as Flash or QuickTime
  • Over 650 Courses
  • $30 for One Month Access
  • Multi-User Discounts Available