Learning Method: Instructor-led Classroom Learning Duration: 1.00 Day
Overview:
For the beginning FileMaker student, learn to create and use databases to store and organize information. Set up a database, find records, format fields, create mailing labels, and create columnar reports.
Who Should Attend:
The target student for this course is office personnel who work with personal computers, and who need to store and organize information for their individual use, but who have little or no experience using FileMaker Pro. They may have experience using office productivity applications, such as a word processor or spreadsheet program, but probably do not have experience using other database applications.
At Course Completion:
Upon successful completion of this course, students will be able to: access data in an existing database, locate records and groups of records that meet specific criteria, create a new database that includes multiple records and multiple layouts, create database layouts by positioning and formatting fields, add graphic and text elements to layouts, create several layouts that can be output to display data for various needs, create a columnar report layout that includes sub-summary data for specified groups of records.
Course Outline:
Lesson 1: Maintaining a Database
- Browse Records
- Add Records
- Edit Records
- Sort Records
- Print a Report
Lesson 2: Finding Records
- Find Records Meeting All Specified Criteria
- Specify an OR Search
- Refine Found Sets
Lesson 3: Setting Up a Database
- Create a New Database File
- Import Data
- Calculate Field Data Automatically
- Create an Automatic Numbering Field
- Control Field Validation
Lesson 4: Formatting Fields
- Position and Resize Fields
- Format Fields
- Format Value Lists
- Create Repeating Fields
- Set Tab Order
Lesson 5: Adding Graphics and Text to Layouts
- Draw and Position Graphic Elements
- Import Graphics
- Add Text Elements
Lesson 6: Creating Layouts for Mailing Form Letters
- Create Mailing Labels
- Create a Personalized Form Letter
Lesson 7: Creating Columnar Reports
- Create a Columnar Report Layout
- Create Summary Data
- Create Sub-Summary Data
