- Before we get started with the tutorials, I just wanted to take a quick minute to explain to you how the Exercise Files work. If you have access to the Exercise Files, you'll note that they're stored in the same structure as I have mine onscreen. You'll notice that each chapter in this title has its own folder. So, for example, if you're interested in watching the movie in chapter 4, movie 3, you can go right to this Folder called 04, 03 and find the files inside of it and pick up right where the movie picks up.
So that way you don't have to worry about where you're starting. You can start in the middle, for example, 08, 02 and simply open up that file and that file will start right where the movie starts. So each of these Exercise Files was created to be within the context of the movie that you're watching. So feel free to start and stop at any different place or, more importantly, you can go back to different Exercises that perhaps you've watched already and be able to pick up right in the middle of the movie. And what we're going to be doing is really creating a database from scratch. So unlike in other videos where maybe you'll have only Exercise Files to work with, if you want to watch this video from start to finish, I encourage you to build the solution along with me onscreen and if you need some help, you can then treat the Exercise Files as Solution Files, the one's that are already completed.
So you can go back and look at them and compare them to the one that you're building. So now that we're all set with Exercise Files, let's get started with the tutorials.
Author
Released
5/12/2015- Comparing flat vs. relational databases
- Creating databases from starter solutions
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating and working with fields, including container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Working with layout themes
- Using layout parts and tools
- Formatting layout objects
- Finding and sorting data
- Creating value lists
- Printing and saving
- Building reports, including subsummary reports and quick charts
- Using the Calculation dialog
- Creating and triggering scripts in the Script workspace
- Working with script triggers
Skill Level Beginner
Duration
Views
Related Courses
-
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome57s
-
Touring the Launch Center6m 44s
-
Using the exercise files1m 25s
-
-
1. Getting Started
-
What is a database?2m 35s
-
Exploring the interface5m 35s
-
-
2. Solution Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 27s
-
5. Working with Fields
-
Understanding field types7m 50s
-
Defining fields8m 23s
-
Adding fields to layouts5m 33s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records3m 33s
-
8. Importing and Exporting
-
Importing data6m 25s
-
Exporting data4m 17s
-
-
9. Creating Layouts
-
Introducing layouts3m 18s
-
Working with layout themes5m 41s
-
-
10. Working with Layouts
-
Understanding layout parts6m 24s
-
Previewing the Inspector2m 23s
-
11. Formatting Layout Objects
-
Applying themes to layouts6m 35s
-
Applying screen stencils4m 2s
-
Applying gradients2m 43s
-
Understanding states7m 47s
-
Setting field behaviors4m 47s
-
Using the tab control feature12m 38s
-
Setting the tab order4m 9s
-
12. Finding Data
-
13. Sorting Data
-
Sorting with related fields2m 41s
-
Sorting using custom values2m 59s
-
Sorting using buttons4m 4s
-
14. Value Lists
-
15. Printing and Saving
-
Printing merge letters4m 52s
-
Saving as PDF or Excel1m 54s
-
16. Reports
-
Creating subsummary reports9m 35s
-
Adding charts to reports6m 54s
-
17. Calculation Essentials
-
Introducing calculations3m 26s
-
Using number functions6m 57s
-
Using text functions11m 50s
-
Using get functions5m 49s
-
Using logic functions12m 42s
-
-
18. Script Essentials
-
Touring the Script workspace5m 14s
-
Creating multiline scripts7m 56s
-
Using script parameters3m 48s
-
19. Script Triggers
-
Introducing script triggers1m 23s
-
Using object-based triggers9m 18s
-
Using layout-based triggers7m 26s
-
-
Conclusion
-
Goodbye1m 48s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using the exercise files