Let's talk a little bit about how these tutorials are organized so you can make the most out of your experience watching them. First of all the tutorials are divided into three. One is for beginner. Ones for intermediate and one is for advanced. However, they are all connected with one solution. We will be creating an invoicing solution, which really starts out, as a contact manager in the beginner and that will translate over into intermediate and advanced because really to create a solution one tutorial is not enough. You really need to go through beginner, intermediate and advanced. And so even if you're an intermediate user you really want to watch the beginner because there's a whole bunch of stuff that's covered there. Even if you know most of it I'm sure there will be little tidbits of knowledge you will gain; plus it will set up what we're going to do in the intermediate and advanced tutorials. So we've chosen to use one solution so that everything is connected together. So you cannot only see what all the techniques are but how they tie together to create a whole solution. You can view the tutorials separately. Basically we include the work file after each chapter. So if we go through four or five tutorials for a chapter, what we've done in those four or five tutorials will be saved in a file so that you can come into any one of the chapters and review something or even just start there and have what we've done before in the previous tutorials. So this can be really helpful given that we've chosen to make it one solution throughout, not just a bunch of techniques. So you can actually if you want, I don't necessarily recommend it, but you can go in and pick and choose which chapters you want to watch and you will have the example work file that goes along with that. Let's talk a little bit about what the beginner tutorial covers. Essentially we're going to create a fully functional solution starting from the beginning. So we're going to start from scratch. There will be nothing there and we'll create everything. And while we're going to be ultimately creating an invoicing solution in the beginner tutorial we'll start off with a contact manager. And that will be integrated into the invoicing solution. And what we'll be covering in the beginner, data entry, how to create fields, how to create tables, how to create layouts, all the things that go along with layouts. We'll cover all the different modes like: Find and Browse and Preview and Layout Mode. We'll cover all the menus so you're familiar with just about every single choice under the menus. We'll cover Value Lists so you can make Popup Menus and Radio Buttons. We'll talk about Auto-Enter, Validating. We'll work with some Container Fields to import pictures and PDF documents. We'll print, obviously making a layout for printing and one for data entry. We'll show you how to do all that stuff, importing, exporting. We'll work with templates, little bit of scripting, little bit of calculations and even reporting - so quite a bit to do in the beginner tutorial. We'll start off slow and we'll kind of ramp it up towards the end. But if you've never worked with FileMaker before the beginner tutorial is designed for you to start with no knowledge at all and come up to an intermediate level so you can continue on with the tutorial series. When you get onto the intermediate tutorial, we will continue with the solution covering intermediate tasks. We'll those would be interface design, some thing more spectacular than what you can just do with the FileMaker tools. We'll start creating relationships - so that means we'll have multiple tables, which means we'll have multiple table occurrences. We'll work with security; you know accounts, privileges, extended privileges. We'll talk about multi-user stuff like record locking and how to work with it in a multi-user scenario. We'll take a stab at custom functions and inside custom functions we'll even go into Recursive custom functions. We'll talk about finding overdue invoices, which is writing a script, very cool thing. We'll work with the Script Debugger, the Database Design Report, plugins, deleting duplicates, dynamic scripting and advance validations and of course much more stuff that can be actually listed here; all in the context of an invoicing solution. So by the time you get done with the beginner, intermediate you'll almost have a complete invoicing solution. Once you get done with the advanced which we're going to next you will have a complete invoicing solution, just about everything you'd want in there. So the advanced tutorial completes the invoicing solution. And we'll cover things like the Ultimate Find, doing a Back and Forward button much like a web browser. We'll talk about how to save a found set of records for future retrieval and also allow users an easy interface they can choose which found set they want to retrieve and restore into their database. We'll do Recursive Phone filters, custom form letters. Now these are not the standard form letters that you're used to when you're working with just a layout. We're talking about form letters that can be modified by the user in Browse Mode, so a very, very advanced technique. We'll talk about text style manipulation with scripts and calculations. We'll show how to make it easier for new requests to be made by the user in fact they won't even realize their making a request. So one of the important things about advanced techniques is your trying to separate the user from having to know FileMaker, just have to know your solution. So if their comfortable with it they can actually do complex things like new requests or multiple requests without knowing that they are actually doing them and get the benefits from them. We'll talk about cross tab reports, filter portals, logging changes to your database in a separate database or inside the same one - lots of different approaches and even deployment considerations. Tons of stuff we're going to talk about. We'll get to all that through all these three tutorials and hopefully that will give you all that you need to be a FileMaker developer.