Once you become familiar with the FileMaker application and how it's set up, there's a couple different ways that you can start creating databases. Of course, you can create them by scratch, which we will be talking about for the remainder of this title, but there are also a couple different ways to get a quicker start. You will notice when you first open the FileMaker application that you have got some options over here on the left that allow you to either Create a New Database and start from scratch or Convert Existing Files or use that's called a Starter Solution. You can select the Use a Starter Solution from the Quick Start screen or when you are already in FileMaker you can go under the File menu and choose New From Starter Solution. FileMaker updated its Starter Solution viewer window in FileMaker 12, and it lists all the different Starter Solutions that are available to you, and you will see that they are also grouped logically in sort of business units, for instance, of the 16 here are the ones that are General, ones that are related to People & Assets, and so on. But if you're looking at All Solutions, you can scroll through these and they're pretty self-explanatory for the most part. You'll see, for example, if you choose the Contacts option and then hit Choose, it's going to ask you where you would like to save this. We will hit Save, and now it opens up the Starter Solution.
So the first thing you will notice is that there's really not much development that's necessary, the layouts are already created. If you take a peek into the Database you will see that there's a contact Table and a series of Fields. So a lot of this stuff is already programmed for you, there are some routines and Scripts already built-in. And it's ready to start creating new data. You can hit New Record and instantly start working with the Database. But more importantly you should know that in addition to being able to add your own data to the Database, you can also go into Layout mode and manipulate the database, change some of the fields and the way things look and really customize it for exactly how you need it go look. So you don't have to just settle on the way that they're built already for you, the idea is you can tell by their name is that these are intended to get you started. And the Starter Solutions are also a great way for you to see how different functionality works. Like, for example, here is something that's called Web Viewer, and it displays the addresses that are listed in these fields. And this is a great way for you to see how these Web Viewers actually work. But also you'll see that there are some layouts that are pre-built. You will notice that in each of the Starter Solutions they've got iPad and iPhone layouts already created. Each of these layouts conform to Apple's touch screen guidelines, so making things like buttons and some of the touch areas larger so that they'll be ready to be viewed on any device without any modification whatsoever. So in addition to being able to work with the data or add your own data you'll also be able to view this information on the various different Apple devices. One thing I should mention about Starter Solutions is that if you happen to be using a 30-day trial version of FileMaker, keep in mind that that's just a 30-day trial for the application. The Databases that you create or the Starter Solutions that you create and modify, they don't have a 30-day limit on them.
So feel free to go ahead and poke through all the different Starter Solutions in the Starter Solution Viewer and see if there's maybe something that's already built in here, and that'll let you get started as quickly as possible. Starter Solutions are a great way to get familiar with FileMaker without having to do any programming. So I encourage you to go ahead and take a look at a couple of different ones, download them, and play around and see which one suits you best.
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
-
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
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: Creating databases from templates