FileMaker Pro 13 for beginners
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
|Section 1: Getting Started In Database Development|
Course overview and getting started.
Developing a database analysis and requirements.
Analysis Outline Usage.
What is required for this course.
Where to find FileMaker Tools.
What type of skills are needed for this course.
Using the database Design Model.
The Database Proposed Deliverables.
Course Analysis and Development
|Section 2: Working with the FileMaker program Menus|
The FileMaker Menu usage.
The File Menu in Browse Mode.
The Edit Menu in Browse Mode.
The View Menu in Browser Mode.
The Insert Menu in Browse Mode.
The Format Menu in Browser Mode.
The Records Menu in Browse Mode.
The Scripts Menu in Browse Mode.
The Tools Menu in Browse Mode
The Window Menu in Browse Mode.
The FileMaker Help Menu in Browse Mode.
The Help Menu continued.
Using the FileMaker menus in the browse mode.
|Section 3: FileMaker Menus in the Layout Mode|
The Insert Menu in the Layout Mode.
The Insert Menu Continued in the Layout Mode.
The Format Menu in the Layout Mode.
The Layout Menu Layouts.
The Arrange Menu in Layout Mode.
The Script Menu in Layout Mode.
Using Program Menus, in Layout Mode.
|Section 4: Application Development, Using FileMaker Pro|
The Inspector, Data Tab.
The Inspector, Appearance Tab.
The Inspector, Appearance Tab.
The Inspector, Style Tab.
The Inspector, Position Tab.
The Inspector, Position Tab.
Working with the Layout Inspector
|Section 5: Developing the Example Database My Codebook Pro|
My Codebook Project, Add Tables.
My Codebook Project, Fields.
My Codebook Add Fields, App Info.
Codebook Database Fields, Code Library.
Codebook Project Fields. Code Data File.
Codebook Project Fields, Code Data Images.
Codebook Project Fields Code Data Samples.
Codebook Project Fields Developer List.
Codebook Project Fields Project Analysis.
Codebook Project Fields Proj. Database.
Codebook Project Database Requirements.
Codebook Project Fields Quiz.
|Section 6: Codebook Database Relationships, Overview and Development.|
Codebook Relationship Graph Overview.
Codebook Relational Link Logic.
Codebook Relationships for the Project Database.
Codebook Relational Links for the App. Information.
Codebook Relational Links Developer Listing.
Codebook Relationships. Setting Links
|Section 7: Developing Layouts.|
Codebook Layouts, Overview.
Codebook Layouts, Codebook Main Layout.
Codebook layouts, using layout parts.
Codebook Layouts, Project Database Layout.
Codebook Layouts, Database Analysis.
Codebook Layouts, Database Requirements.
Codebook Layouts, Application Info.
Codebook Layouts, Topic List View.
Codebook Layouts, Code Library Portal.
Codebook Layouts, Code Data Portal.
Codebook Layouts Code Images Layout.
Codebook Layouts, Externals_ Plug-ins Layout.
Codebook Layouts, Data file list view.
Codebook Layouts, Code LIbrary List View.
Codebook Layouts, Developer Listing.
Codebook layout design and development quiz
|Section 8: Special Bonus Lessons|
New lectures will be added based on student questions.
|Section 9: Bonus Lecture, Charts|
Bonus lecture 1, basic chart usage
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.
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Skill level All level
- Language English
- Students 250
- Assessments Self