Instructor: Vicki Weidler Assistant: Joaquin ObietaĢ Overview Enter data automatically and set validationsĬreate calculation fields Create a value list and change the default tab orders Learn to move and resize fields Learn to add custom text and graphics to the layout Create and print layouts for reports, form letters, and mailing labels What is a database? A collection of data organized in some way to make it more useful Examples: Phone book, library card catalog system, LIAS CAT, Training registration system When do you use a database? Large collection of data To be organized in different ways based on multiple criteria Make it more useful by breaking it into smaller subsets of information Example: Admissions Office may want to view all University Park Penn State juniors from Pittsburgh 3 Types 1) Flat File – spreadsheet (show example) Relational Stores info in tables Tables can be joined many different ways using a primary key Benefits over flat files: Increases efficiency Reduces redundancy/duplications Improved performance 3) Object-Oriented Uses Java, C++, etc. 1 FileMaker Pro: Using Advanced Features & Working with Layouts

Filemaker pro advanced java