file maker for yap
TRANSCRIPT
Filemaker as fast as I canA gentle introduction
for the Yap State Department of Education Federated States of Micronesia
what is where and what is what
medium - high view of the moving parts: layouts vs. databases
modescycling through as a flow for
development
table view vs. list view vs. form view
find is flexibleand “sticky”
use control key j to remove the search filter
day one; task onemake database!
take a look a page 79 for instructions to create a database
add a fieldInstructions on page 82
Notice the different types of fields: text, numbers, dates, etc.
add some datapage 85
let the computer count for you
the computer can assign numbers for you – this may not seem useful now but it will be
open the database managerfile -> manage -> database
use the ‘field’ tabselect options
and look at the ‘serial number’ section
first pass at validation
open the database managerfile -> manage -> database
use the ‘field’ tabalso a brief look at the inspector
view -> inspector
Calculations – adding math to FileMaker
This could be used for keeping a running number of students assigned to a classroom
Set-upOpen FileMakerPro12MM_Ch04_missingCD in
the FileMakerPro12MM_missingCD folder and open Ch04_LeaseAgreement_START.fmp12
Take a stab at the example on page 122back to the database manager
file -> manage -> database
Lunch?just in case we all forgot
Overview of relational databases
What is this “relational” stuff? Why bother?
part 1: creating your own
relationSet-up
Open FileMakerPro12MM_Ch04_missingCD in the FileMakerPro12MM_missingCD folder
and open Ch04_LeaseAgreement_START.fmp12
and turn to page 129
we will create serial-number to database(if you are curious, the reading starts on page 127)
part 2: creating your own
relation
Still using Ch04_LeaseAgreement_START.fmp12turn to page 132
turn to page 134
create a new table
create a relationship
part 3: creating your own
relationShowing the data via portal
Still using Ch04_LeaseAgreement_START.fmp12turn to page 137
Hey Eric, what’s a portal?
Enough for today?What did we do?
created tables and looked at interfacesadded fields and altered how they work (validation and serial number)
managed relationships and how to view them with portals
Where to find more?
help menu
support
online & offline resources
Introduction to scripting