Join Cris Ippolite for an in-depth discussion in this video Reviewing how FileMaker works, part of FileMaker Pro 12 Essential Training.
We have talked about why you would want to use a relational database to manage your database…over the other flat file options, but I'd like to show you a couple of reasons why FileMaker…Pro is such a great application for developing those relational databases.…First off, you can see here onscreen that we can store information or application much like we do with the spreadsheet…or other applications. I've got information here on Customers, but I can also store information…on Products or Invoices or whatever other information fits our needs. But in addition,…we can easily create new records, as you see here, by just simply hitting this New Record…button on the top of the screen, or delete records very easily from our database.…
We can even search for records by going into a certain Find mode and entering in some type…of search criteria--in this case, the State of California--and within about a second,…FileMaker is going to show me all the different records that match that criteria that are…stored inside my database. This is something that's usually very challenging to do inside…
Author
Released
5/29/2012- Comparing flat vs. relational databases
- Creating databases from templates
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating fields
- Using new FileMaker 12 container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Managing layouts and layout objects
- Applying new FileMaker 12 themes to layouts
- Finding records and working with found sets
- Building reports and charts
- Authoring calculations
- Creating and triggering scripts
- Working with relationships in scripts, calculations, and charts
Skill Level Beginner
Duration
Views
Related Courses
-
FileMaker Pro: Relational Database Design
with Cris Ippolite2h 40m Intermediate -
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Appropriate for all -
FileMaker 13 New Features
with Cris Ippolite3h 56m Appropriate for all
-
Introduction
-
Welcome1m
-
Using the exercise files1m 7s
-
-
1. Getting Started
-
What is a database?2m 49s
-
Exploring the interface8m 10s
-
-
2. Database Creation Essentials
-
Adding tables by importing3m 10s
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields4m 19s
-
5. Working with Fields
-
Defining fields7m 22s
-
6. Working with Container Fields
-
7. Working with Records
-
8. Importing and Exporting
-
Importing data9m 8s
-
Exporting data5m 10s
-
-
9. Creating Layouts
-
Introducing layouts4m 51s
-
-
10. Working with Layouts
-
Understanding layout parts6m 31s
-
Previewing the new Inspector1m 22s
-
11. Formatting Layout Objects
-
Applying Screen Stencils4m 3s
-
Applying gradients2m 25s
-
Understanding object states2m 18s
-
Setting field behaviors3m 58s
-
Using the Tab Control feature11m 17s
-
Setting the tab order5m 1s
-
12. Finding Data
-
Saving find requests5m 55s
-
13. Sorting Data
-
Sorting with one criterion4m 40s
-
Sorting with related fields2m 23s
-
Sorting using buttons4m 31s
-
-
14. Value Lists
-
Introducing control styles5m 40s
-
-
15. Printing and Saving
-
Printing merge letters5m 20s
-
16. Reports
-
Adding charts to reports10m 23s
-
17. Calculation Essentials
-
Introducing calculations2m 46s
-
Using number functions10m 29s
-
Using text functions12m 35s
-
Using get functions5m 26s
-
Using logic functions11m 39s
-
-
18. Script Essentials
-
Creating multi-line scripts8m 39s
-
Using the New Window script step10m 58s
-
Using script parameters4m 28s
-
19. Script Triggers
-
Using object-based triggers10m 49s
-
Using layout-based triggers6m 40s
-
20. Using Relationships
-
Using related fields6m 32s
-
-
Conclusion
-
Goodbye1m 16s
-
- 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: Reviewing how FileMaker works