FileMaker Pro 13 for beginners

This is a complete top to bottom course to learn database information management using FileMaker Pro for a beginner.
3.8 (13 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
258 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 65
  • Length 12 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course Description

Develop professional database information solutions!

Ask yourself this question? "Have I ever used a database"? You may be surprised to realize that the internet is a database! Just about every part of your day to day activity is dependent upon databases. Your smartphones contain many databases.

You don't need to be a Information Technology Professional to get into database development. This course has 12 hours of video and hands on labs where you learn to be a professional database designer. It has 65 lessons covering FileMaker Pro usage.

In 2008, I designed database solutions for the iTunes Store. This resulted in a four-year gross sales of $150,000, and sales of over 5000+ databases sold worldwide. I also developed custom applications using FileMaker Pro for over 1200 custom databases for clients.

This course is unique in that it provides top to bottom knowledge to become a FileMaker Pro developer. There are no other courses that provide as thorough step-by-step and hands-on labs to instruct you in all aspects of the design of FileMaker database solutions.

Sections in this Course:

1: Master the basics of working with your clients to develop a database project.

2: Learn the FileMaker RIDE (Rapid Interface Design Engine) interface step by step.

3: Learn the "Data Inspector" to manage the appearance, style, and position of layout objects.

4: Add Tables, Fields, and prepare linking of tables in relationships.

5: Learn the basic to understanding how to work with the tables to connect the relational links.

6: Use labs to make the individual layouts used for the user interface.

7: Advanced user interface design is the last labs where you will cover the more advanced elements used in the My Codebook Pro interface design

What are the requirements?

  • A Mac or PC Windows Computer
  • FileMaker Pro, or FileMaker Pro Advanced
  • Optional iPhone or iPad
  • Optional FileMaker Go, iPhone or iPad

What am I going to get from this course?

  • This FileMaker Developer Course contains 12 hours of instructional lessons and 65 lectures providing top to bottom use of FileMaker Pro 13
  • you will learn the basics of database design and analysis
  • you will be able to define the database design requirements
  • you will be able to formulate a design cost and price proposal for your company or client
  • you will learn the usage of the FileMaker Pro program interface to design and develop database information solutions
  • you will learn hands on and lab techniques to design and develop working database projects
  • you will create a project “FM Codebook” to gain a full working knowledge to build your own project design codebook for future projects
  • you will learn how to use your database requirements to structure database tables
  • Using the database tables you will create the individual objects in the table that will be used to enter data into screen layouts
  • you will be able to set the table object types in the table setup to meet the design requirements
  • ou will be able to set the layout style for the type of device that will use that screen size
  • you will be able to set the layout theme for all objects and the screen elements
  • you will be able to add scripts at the table level of any layout objects that require default scripting
  • you will be able to edit field objects for formulas, calculations, optional input restrictions, and auto entry inputs
  • you will learn how to set relational design links that are used between tables
  • you will be able to define the settings of relational connections using the dialogs for editing relationships
  • you will be able to using FileMaker create the relational database structure to make your solution functional
  • you will be able to test the relational link design, and test for errors
  • you will be able to diagnosis and correct link errors in the database structure
  • you will be able to use the field scripting editor to develop scripts that control layout objects
  • you will use the scripting language to add any required formatting, or calculation in tables at the layout design level
  • you will be able to test layout scripts for errors and correct output errors
  • you will be able to use the layout inspector to mange changes in the layout objects
  • you will be able to use the field picker to add or edit layout objects
  • you will learn the layout design capabilities used to build the user interface
  • you will be able to work in the browse and layout modes to view and edit layouts
  • you will be able to set headers, and footer on the layout
  • you will using your database outline, organize the screens and layouts for navigation and custom buttons usage
  • you will using labs, design layouts for the screens in the example projects
  • using the RIDE (Rapid Interface Develop Engine) you will add drop down lists
  • using the RIDE you will add off screen edit layouts for drop down lists for the iPhone and iPad
  • using the RIDE lab you will add a layout tabbed interface
  • using the RIDE lab you will add a popover element
  • using the RIDE lab you will add content to Container fields
  • using the RIDE lab you will add a popup menu
  • using the RIDE lab you will add a guides and rulers
  • using the RIDE lab you will add a tab controls
  • using the RIDE lab you will add a portals
  • using the RIDE lab you will add a insert, photos, images, and text in layouts
  • using the RIDE lab you will add a picture slider in a layout
  • using the RIDE lab you will add a charts from a table or chart in a layout
  • using the RIDE lab you will learn about the menu builder
  • you will use the program menus to format, add graphics, and other screen elements to enhance the quality of the layout design
  • you will be able to add buttons and using the scripting screen add and edit scripts to make the buttons function
  • you will be able to save the database as a copy, for a backup, or for redesign while keeping the original project
  • you will be able to describe the full usage of the go to layout
  • you will be able to describe the full usage of the table layouts
  • you will be able to describe the full usage of the form layouts
  • you will be able to describe the full usage of the find layouts
  • you will be able to describe the full usage of the reports
  • you will be able to describe the full usage of the Browse mode
  • you will be able to describe the full usage of the menu designer
  • you will be able to describe the full usage of the Layout mode
  • you will be able to describe the full usage of the Find mode
  • you will be able to describe the full usage of the Preview mode
  • you will be able to find and use the program help to locate support, and scripting language help

What is the target audience?

  • Individuals who are starting a new career path.
  • Consultants who want to learn database design
  • Students who want to learn information management
  • Teachers who want to add database design to the curriculum
  • Current database designers who want to learn FileMaker Pro
  • Individuals who are learning IT Data Management
  • Employees in IT positions who want to add new capabilities in their firm
  • Small and medium size businesses who want to develop solutions for their company

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started In Database Development
09:04

The overview is a description of the course in general. This course is a top down full description of what a beginner using FileMaker Pro needs to know to develope a quality datbase solution.

11:05

This lesson will cover working with client's or users to analyze the database requirements. Requirements are used in the database design to formulate all of the content in the database development.

09:05

This lesson go to the next level of the analysis where you create a design outline based on your requirements. I will use the My CodeBook resource file to describe the analysis outline.

08:44

In this lesson I will describe what is required for this course. Lesson 2

19:34

In this lesson I will show you where to find FileMaker tools for developing database applications.

06:27

In this lesson I will describe the student skill levels required for this course.

19:29

This lesson will describe the database development and design process using a design model. The lesson covers the process from the analysis to the final testing of your database solution.

16:06

This lesson discusses the management of the database project, and the relationship of the client deliverables.

3 questions

What is required to design a FileMaker Pro database?

Section 2: Working with the FileMaker program Menus
12:33

In the Browse mode in Filemaker Pro you will step through the menu selections and you will learn the the usage of each selection option.

19:11

In this lesson we will continue covering the menu options from left to right in FileMaker in the browse mode. The file menu selections will be covered in detail, and a description of the options that are available within each dialogue will be covered.

04:50

This lesson is on the edit menu selections for the browse mode in the program menus. This is an important menu for the browse mode user because it controls many of the edit mode functions. The lesson will address each selection in detail.

19:50

The view menu in the browse mode controls the interface and program menus. In this lesson will cover all the dialogues and menu selections in detail.

11:16

In this lesson you will use the insert menu to add media and text data to the user objects.

01:22

This lesson for the Format Menu covers the text selection options to format the text.

16:14

The lesson on the Records Menu will cover the usage of the editing of database records in the browse mode.

11:26

The script menu can be limited to access of admin users to ensure that no one edits the scripts unless they have the rights to access them. Scripts and used to manage data entries and to change formatting. This subject will be expanded later in the course.

13:54

In this lesson I will be covering the tools menu where you will discover some of the advanced capabilities for building menus, runtime applications, and a discussion about the script debugger's. This is an advanced subject and will only be covered as an overview. In future courses this will be covered in detail.

04:29

This is a brief lesson on the Windows menu and the options on this menu. Be aware that this menu should be used only for your personal usage. If you're developing a database for a client, then all of the controls for the users should be in your layout interface. This is covered in this lesson.

10:47

Lesson 17 will be provided in 2 separate lessons, and lesson 18 continued will be the second portion to the length of the information to be covered. This might be one of the most important lessons in this section, because it covers such a large amount of information that is vital to using FileMaker.

11:23

Lesson 18 will continue the description of the help menu.

Using the FileMaker menus in the browse mode.
3 questions
Section 3: FileMaker Menus in the Layout Mode
11:11

We are now in the layout mode where the next series of lessons will cover menu options that are available in the layout mode. The first is the insert menu where the selections and options are expanded to include managing additional functions.

17:24

This is a continuation of lesson 19 on the insert menu, and lesson 20 recovering the balance of the insert menu options.

06:32

In lesson 21 we will be covering the format menu where managing layouts are the principal menu options. You will get a detailed look at each menu option in the dialogues that are associated with the formatting and management of layouts.

12:14

This lesson is one of the principal lessons for the layout menus. In this lesson you will learn how to create new layouts, to duplicate or edit or delete current layouts. Also covered in this lesson you will learn how to set up the different themes used in designing the user interface for layouts.

08:59

In this lesson you're going to continue learning about the management of layout objects. The arrange menu works in conjunction with the layout inspector to organize layout objects. In the labs in the next section this will become an important part of building the My Codebook application. As a beginner developer managing layouts and organizing layout objects is one of the principal things you do when building an application.

19:50

In this lesson will begin the process of learning how to manage scripting. To get started learning scripting you need to understand how to use the scripting menu and the supporting dialogues. This is the getting started portion of using scripts to manage fields, layout objects, calculations, and all other aspects of user interface scripting.

2 questions

In the layout mode, what menu would you use to add a web viewer object?

Section 4: Application Development, Using FileMaker Pro
15:27

In less than 25, this is a lab where you'll do hands-on data entry into the codebook example application. During the lab you will open the codebook that you are building, and you will be adding or editing data.

08:36

In lesson 26, this is a lab where you will learn about using the appearance tab in the inspector dialog. The lab portion of this lesson is where you will use your version of the codebook to duplicate editing the appearance Of objects on the layout. This will be taught in 2 labs lesson 26 and lesson 27.

08:37

In this lesson 27, we will do the second part of the appearance tab where we are editing text on the layout. In this lab you'll be doing hands-on editing using the inspector in the layout mode. You will follow along with the instructor to make changes in the example Codebook application.

05:47

In lesson 28, this is also a lab where you will be doing hands-on editing. Using the example Codebook, you will open the layout editor and observe how styles that you create can be saved and reapplied.

08:03

In lesson 29, we will be covering the inspector Position Tab where you will be using the Codebook example file as you follow along in the lab to set the position of objects on the layout. In the lab, have the example Codebook file displayed alongside your you Udemy lesson. This lesson is covered in two parts were lesson 29 and then 30 will conclude the inspector, position tab lesson.

13:51

In less than 30, this lab will continue from lesson 29 where we are working with positioning objects on the layout. Again we are working in the example Codebook application, and in this lab you will use the Codebook to do positioning of objects in the layout.

2 questions

In this quiz, you'll recall how the layout inspector is used to manage layout objects. The quiz is designed to check for understanding based on the information was provided.

Section 5: Developing the Example Database My Codebook Pro
09:37

In lesson 31, we will start assembling the example My Codebook Pro application by adding the database tables. In this lab you'll be doing hands-on entry of the tables for the my codebook Pro application. This lab will include creating a new database from scratch and adding the information from the example database provided in lesson one.

07:03

In less than 32, this lab you should have all the tables added at this point. Now we will continue developing the codebook by adding fields in each table. This lesson will get you started in that process to learn how to add fields to each table.

09:35

This lesson moves to the next table and adds fields in the fields tab for the Application Information table. This lab continues through the next tables.

05:20

In lesson 34, we will be adding the fields for the code library table in this lab. Be careful when you're doing your entry to get the correct spelling, and layout object type.

05:55

In lesson 35, we are adding fields to the code data file table. In this lesson lab, the instructor will ask you to identify the parent and child tables in the lab. You will do this by reviewing the example Codebook database. feel free to view the relationship graph to see how the tables are defined.

11:55

In lesson 36, your going to be adding field data to the code images table. In this lesson the lab will cover using the container fields to add, replace, and delete images in a container filled in the example Codebook database. Instructor also cover the theory of using container fields in a database application.

03:14

In lesson 37, you will be adding field data for the plug-ins and external tab in the application information table. The code sample data table provides information about plug-ins and externals that can be found on the Internet. In this lab I would like you to use Google to search for plug-ins. This search will provide additional information about how to add externals and plug-ins to your FileMaker solutions.

06:07

In less than 38, we will be adding fields to the developers list table. In this lab we will be working with the application information parent record where you will see how the developers list is used in its own separate layout to supply information to a drop-down list.

11:27

In lesson 39, we are adding fields to project analysis table. in the process of adding fields to the tables you might've noticed that the tables were not added in any logical order. Part of the reason for this is I wanted you to notice it before I mentioned it. It's not necessary that there in order only that you understand the logic for each table. This table is used to collect the analysis using requirements as the input. It's actually the first table logically it would be listed. See if you can figure out in this lab the order that you would put the tables in logically.

05:47

In lesson 40, wherein the adding fields to the project database table. This is the parent table for the project analysis portion of the database. This database is divided into two functional parts, the project database, and the application information where your codebook data, and images reside. I

05:58

In lesson 41, we will be adding fields to the last table in the project which is database requirements. In this lab your completing adding the fields to all the database tables. The next step is to clean up any calculations, and prepare the relationship graph to link tables.

3 questions

This quiz is used to evaluate the course for student understanding. The quiz is used to improve student retention of the lesson materials.

Section 6: Codebook Database Relationships, Overview and Development.
07:53

In lesson 42, wherein a begin the process of organizing the relationship graph and determining what table positions need to be moved on the relationship graph. Before we set up the relationship graph we will step through the process in an overview that will describe the Codebook table relationships. This may be the most important lessons in the course. Learning how to use relational linking may be the most difficult part of designing the database solution. You need to understand that each database design has its own set of issues when it comes to determining the relational logic. As a beginner developer it can be challenging to learn the relationship logic. Since we will be testing all the logic you can see how to identify any issues in your future database development.

14:21

In lesson 43, we are working on the my codebook application to define the relational links for the parent and child records. This lesson discusses the logic required where the layout will function based on the relational links. This particular lesson is using the codebook logic, in other layouts you will see variances based on your database design outline. Keep in mind that the functionality requires specific links in order to perform the way you want it to perform based on your design.

06:29

In lesson 44, this lab will concentrate on the first part of the my codebook project tables. In the next lesson will work on the application information portion of the relational linking. In this lab you will be using the example database, and your version with your name or you will be doing the relational linking.

06:45

In this lesson 45 lab, you will make the links for the Application Information table to the child tables. This will be followed by a special type of link in lesson 46 for a recursive link or also know as a self join.

10:25

In lesson 46 lab, really be doing something with the developer listing that is a unique type of relationship. In this lab I will be explaining how a recursive loop link is used. It's also being used in a unique way which I will explain in this lesson. This is more of an advanced developer usage, so you're going to get a preview of some of the topics being covered later in this course.

3 questions

In this quiz I'll be checking for understanding for section 6 of this course. This quiz is not to see if you get the question correctly answered, the quiz is used to check to make sure that the course information is providing the information required to manage relationship links in the Codebook application.

Section 7: Developing Layouts.
17:30

In lesson 47, in this lab will be covering the overview of the screen options, dialogs, and program interface tools in a review of some of the prior lessons and user options. At the completion of this lab you will be able to identify the features and functions required to manage and design your layouts.

18:48

In less than 48, we will be adding the Codebook Main layout elements. There are limited things that need to be done on this layout, so I will be doing some housekeeping where we will set up the manage layouts to organize all the layouts in the application.

10:36

In lesson 49, we will use the Codebook Main layout to discuss adding additional objects, and also discuss layout buttons in the program menu, and the individual parts in the layout itself.

19:02

In lesson 50, in this lab we will cover the development of project database layout construction. To allow the lesson to be covered in one step, the instructor will show you how to move whole layout from the example database to the development database you are working on.

18:25

In lesson 51, we are continue our labs for laying out the design for each of the tables in the solution. For the rest of the lessons in the database layouts, will repeat where I paste in the final layout and then just discuss the updates and changes that you need to make in the layouts.

07:23

In lesson 52, were doing the last database layout in the database project layouts. From here will be doing the application information portion of the database solution am the last series the videos in section 8. The goal of these lessons for the layouts is to introduce new information that will assist you in doing layout design. F

10:21

In lesson 53, restarting on the next section or segment of the codebook application. In this lesson we're going to develop the application information layout. In addition to that organist show how to import scripts from the original database and install them in the new codebook example database.

11:12

In lesson 54, this lab will be covering some new information on how to do list views. A list to layout is a multi-record format that shows all the records in the current selection. The current selection is determined by a find being performed to reduce the number of records in the current selection. The lesson will cover editing the layout and some housekeeping movement of data objects that were copied from the main application. Your portion of the lab is to complete the topic layout in the your name application.

15:18

In lesson 55, will be covering the code library portal where we will be adding it to the your name application. This lab is used to demonstrate how to move layouts from one application to another, and then set up the layout to make it fully functional. We will also see how to use the field picker to add fields to the layouts.

11:31

In lesson 56, were continuing to add the layouts to the codebook your name to build your custom application. Then repeat what we did on the last lesson by adding the layout elements and objects to the your name application. The next thing in the lab that working to do is to do some format work on the layout to include tooltips and setting colors of objects.

19:15

In lesson 57, were going to be using the code data image layout and moving it from the example database to your custom your name application. We will be covering container fields, and adding data to the container fields in this lesson.

19:04

In lesson 58, are going to cover grids and rulers, and layout design elements and concepts not covered in prior lessons. Your lesson lab assignment is to copy the externals and plug-ins layout and add it to your database codebook in the layout four externals and plug-ins portal. I will be covering object alignment and layout principles.

17:23

In lesson 59 will be adding, the Data file list view to your codebook project. In assigning the new layout to the your name application you will be using feel ticker to populate the list view.

07:15

In less than 60, we are going to re-create the code library list view similar to what we did in the last lesson. In this lab you will be moving the final list you over to your codebook project. Your note in the lesson description really be doing something special with the speak command script button in the layout. This is a new FileMaker 13 feature that has some special capabilities.

08:15

In less than 61, were covering a special layout format unique to my Codebook. this layout is designed to allow users on the iPad to edit scrolling lists. The field on the layout will scroll as it was designed for the iPad. But the user will be able to edit this field and contents in the drop-down using the special layout.

3 questions

Section 7 quiz questions on layouts, design and development. I

Section 8: Special Bonus Lessons
Article

The instructor will add additional bonus lessons based on student questions.

Section 9: Bonus Lecture, Charts
Bonus lecture 1, basic chart usage
12:04

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Vaughn Clement, Informations Systems Specialist

Received a bachelor of science degree in business and accounting in 1992 from the University of New Mexico.

  • I retired from the US Navy in 1981, and relevant experience of interest to Udemy is that I was an instructor for about 10 years teaching technical courses. I attended what would be a Masters level course on instructional systems development early in my career in the Navy.
  • In 1982 I took a position with the company named ESI, that later became a giant company called ISC international signal and control. Before I left the Navy I assisted in writing CBT courses for the Marine Corps through a civilian company. That led to this employment with ESI. My position in this company was the logistics and field support manager. I was responsible for all the technical training, manuals, and marketing literature that went out to our customers. Shortly after joining this company I used my experience in CBT courseware to start up a new department, named ISC Educational Systems. Our first contract was a million-dollar course for all high school math from basic numbers to trigonometry calculus and geometry. There were many other courses of technical nature that followed. In 1990 ISC was taken over in a hostile takeover. The company that took over ISC dissolved the company's in the corporate Circle.
  • Director of operations, responsible for software design, computer equipment integration, and production methods for a startup company doing short run color printing.
  • Sales and marketing manager, for 15 store retail computer business. Responsible for managing a store where my personal sales exceeded 365,000 each year for five years.
  • Account's receivable manager 2001 to 2006 for a civil engineering company in Sedona Arizona. Responsible for training project managers, managing accounts receivables, contracts, bid and proposal development, developed computer database management programs that move the company from a $1 million a year company, to accompany 15 1/2 million in five years.
  • In 2007 started my own business On Target Solutions LLC. My position as a part-time business owner was to develop database management systems. I use my experience to design and develop database management systems for business, and productivity solutions. I became an Apple developer for iOS in 2007, in my first four years I grossed $150,000 where I sold 4500 applications worldwide. As of 2015, I'm approaching 5000 applications sold, and I moved more toward doing custom software solutions for worldwide clients. This amounts to about 600 applications sold that are not included in the hundred and 50,000 sales for iTunes.
  • Almost by accident I learned about Udemy and its online instruction courseware. I had purchased a number of courses prior to deciding to throw my hat in the ring. My goal to be an instructor with Udemy was to provide training courses based on my work history. My first consideration was to create a course for FileMaker Pro advanced that is a database I been using for 18 years.

Ready to start learning?
Take This Course