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
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.
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.
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.
In this lesson I will describe what is required for this course. Lesson 2
In this lesson I will show you where to find FileMaker tools for developing database applications.
In this lesson I will describe the student skill levels required for this course.
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.
This lesson discusses the management of the database project, and the relationship of the client deliverables.
What is required to design a FileMaker Pro database?
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.
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.
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.
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.
In this lesson you will use the insert menu to add media and text data to the user objects.
This lesson for the Format Menu covers the text selection options to format the text.
The lesson on the Records Menu will cover the usage of the editing of database records in the browse mode.
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.
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.
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.
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.
Lesson 18 will continue the description of the help menu.
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.
This is a continuation of lesson 19 on the insert menu, and lesson 20 recovering the balance of the insert menu options.
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.
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.
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.
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.
In the layout mode, what menu would you use to add a web viewer object?
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
This quiz is used to evaluate the course for student understanding. The quiz is used to improve student retention of the lesson materials.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
Section 7 quiz questions on layouts, design and development. I
The instructor will add additional bonus lessons based on student questions.
Received a bachelor of science degree in business and accounting in 1992 from the University of New Mexico.