120 likes | 233 Views
Filemaker Pro in The Guidance Office. Laura J Cohen Advanced topics for the counselor with Filemaker Pro Experience. Database mantra. Never type anything that has ever been typed before! Student Names Student Ids Addresses Test scores Teacher Names. View: Form vs. Table.
E N D
Filemaker Pro in The Guidance Office Laura J Cohen Advanced topics for the counselor with Filemaker Pro Experience
Database mantra • Never type anything that has ever been typed before! • Student Names • Student Ids • Addresses • Test scores • Teacher Names
View: Form vs. Table • Look at records one at a time in form view. • Look at many records at once in table view.
VIEW: Four Options • Layout: DESIGN your database • Find: SEARCH your database • Browse: Edit, Review your database • Preview: How will it LOOK when you PRINT?
Special Finds • Find Similar • Extend Find • Constrain Find
Tips for Using School Reports • Use the excel button at top of screen • Best bet: Save as CSV • Student ID, change to custom 0000000000 • Change course number to custom 00000000
Importing Data • Two types of import: new import or add to data • Matching fields • Arrow vs. equal
Creating Subsummaries • Count, total • Subsummary part when sorted by… • Layout of only a subsummary part • Adding page # to subsummary (##) • Adding date printed to subsummary (//)
Field Options • Adding a scroll bar • Adding value lists • Radio button vs. checkbox • Drop down calendar field • Field borders • Field textures (embossed, engraved)
Creating Simple Buttons • Button to Change Layout • Button to sort • Button to view as list • Button to replace • Buttons to perform scripts
How to learn more • Go to BEEP! • Click on Atomic Learning. • Go to tutorials • View filemaker pro tutorials!