The Ultimate Site for FileMaker
FileMaker Events
Company: Accelerate Computer Training
Url: www.acceleratecomputertraining.com
Beginning FileMaker Pro 11 Training in Southern California
Place: Long Beach, CA - USA
Date: Monday Nov. 29
2010
This one-day course teaches you how to use existing FileMaker Pro databases and how to build simple new databases. You will add and edit records, and search for and sort records. You will build a relational database by defining tables, fields and relationships, entering and importing data, and designing layouts for data entry, lists and mailing labels.
Cost: $295
Hours: 8:30am - 4:00pm
Location: 110 W. Ocean Blvd, Suite 342, Long Beach, CA
Course manual included
Pre-registration is required; multi-class and multi-student discounts are available.
Topics include:
Using Databases in FileMaker Pro 11
- Opening an existing database
- Moving between records
- Switching views
- Zoom and Status Toolbar controls
- Switching between layouts
- Entering and editing data
- Creating new records
- Duplicating and deleting records
- Switching modes
Finding and Sorting Records
- Finding records
- Entering simple search criteria
- Using symbols
- Specifying AND vs. OR requests
- Saved Finds
- Omitting records
- Finding matching records
- Understanding the Found Set
- Constraining or extending the found set
- Replacing field contents
- Saving a copy of a Database
- Sorting records
Planning and Constructing Databases
- Planning a database
- Identifying entities
- Creating an Entity-Relationship Diagram
- About key fields
- Building the database
- Creating tables
- Defining fields
- Modifying field definitions and order
- Creating calculation fields
- Setting Auto-Enter options
- Setting field validation options
- Defining relationships
Importing Data
- Importing into existing tables
- Converting Excel spreadsheets into FileMaker Pro tables
Designing Layouts
- Working in Layout mode
- Selecting objects
- Resizing objects
- Moving objects
- Deleting objects from a layout
- Layout tools
- Placing fields onto a layout
- Formatting fields, labels and parts
- Applying font formatting
- Applying number, date and time formatting
- Setting fill and line color and pattern
- Changing field display style
- Auto-complete
- Drop-down lists, pop-up menus, checkbox and radio button sets
- Drop-down calendars
- Adding decorative layout objects
- Adding text
- Drawing lines and shapes
- Importing graphics
- Setting tab order
- Creating new layouts
- Outputting reports
- Printing
- Saving as PDF
Prerequisites:
This class is ideally suited for people with basic computing skills, such as using a mouse and opening and closing windows. No FileMaker Pro or database experience is required.
+++++
Accelerate Computer Training classes feature:
- small class sizes (no more than seven students per class)
- patient, experienced FileMaker-Authorized trainers
- comfortable training environment using your choice of Mac or PC with large flat-panel monitors
- beautiful surroundings in the historic Ocean Center building in renovated downtown Long Beach, a short walk from the Queen Mary, Rainbow Harbor and the Aquarium of the Pacific
- free retakes for up to six months from the original class date
To register for this class, please call (562) 804-5508 or complete the contact form at:
Related event url: http://www.acceleratecomputertraining.com/contact/
See all events related to Accelerate Computer Training
Print - Web site - Send to a friend - Add a comment