Username:
Password:
FileMaker Pro 10: Beginner Tutorials

Creating a Database / Templates pt. 1

Subtitles of the Movie

When you launch FileMaker Pro 10 or FileMaker Pro 10 Advanced, the first thing you see is the Quick Start screen. The Quick Start screen has 3 main areas, Create Database, Open Database and Learn More. We'll start off with Create Database, which has 3 options. And the first one is Create an Empty Database. And this is what seasoned developers use, they want a blank slate, they want to have an empty database so they can put their own personal touch on. They put all the fields in, all the tables, everything. It's kind of like opening up a word processing document. You have to type everything in yourself. Well, with an empty database you have to type in, create all the tables and the fields and everything. And this is what seasoned developers want, they want to put their own personal touch on it. Now if you have existing data, you can create a database from an existing Excel 95, 2004 workbook or .xls. Or if you have Excel 2007 through 2008, you can create a new database from the .xlsx type. You also have tabbed limited, which is a very common file format. You might get that from a mainframe or some other database or who knows where. And want to create a database with that data, comma separate is also a common format, merge file and then on the Macintosh operating system if your using Leopard and have Bento 2, you can import your Bento data into a brand new FileMaker database. Your third option is create a database using a starter solution or a template. And there are quite a few options here. The one we're going to use is a contact management. That's because in this tutorial, the Beginner tutorial, we're going to create a Contact Manager but we're going to do it from scratch using an empty database. However, I'm going to show you where we're going to go by creating the template first. It'll create everything for you and all you'll have to do is enter data. We're going to see where you want to go, what's the goal of this whole tutorial. And this will give you an idea. But before we do that let's move on to different sections, Open Database, here's recent files you can see all of the recent files that you've opened up, or at least that I've opened up. And if you want to add one of these to your favorites, when you go over there you'll see contacts is now there and you can add as many as you want here. And then you also have remote files. If you have a network set-up with a FileMaker server then all of those shared files will be there. These are files that multiple people can enter data into it at the same time. So we don't have a network set up so that's why it's blank. You can also browse files from here and this will simply just give you a view of your hard drive so you can open any FileMaker file you want. Now here's a section that most people who are just opening up FileMaker for the first time should go. This is uh, learn more section and the first section here, the see it section, allows you to watch very brief videos on the basics. It's an overview of how FileMaker works and it's great for somebody who has never used FileMaker before. The use it section gets a little bit more complicated, it actually has hands on screen shot visual tour and tells you what to do through these screen shots and you get to follow along and create your own database. After you've gone through that you can look at the learn it section which allow you to expand your skills with a PDF tutorial. So this is very lengthy and you really need the first 2 sections to get your skills up and then you can read through this PDF and really learn a lot more. And once your feeling really comfortable with FileMaker, you can go to the more section which connects you to a website and allows you to go to the resource center which has tons of stuff. There's going to be additional videos there, there are going to mailing lists links, there's going to be links to other websites, there's going to be the knowledge base. All kinds of things out on the web that will help you out.

Tutorial Information

Course: FileMaker Pro 10: Beginner
Author: John Mark Osborne
SKU: 33925
ISBN: 1-935320-18-1
Release Date: 2009-01-05
Duration: 15 hrs / 172 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
  • 81,350 Video Tutorials (20,800 free)
  • Video Available as Flash or QuickTime
  • Over 782 Courses
  • $30 for One Month Access
  • Multi-User Discounts Available