Wednesday, September 17, 2008

FileMaker® Training (FTS) for Non-Profits and Educational Attendees (2-Two Day Classes)

SolutionMakers, Inc., a FileMaker Authorized Trainer, is pleased to announce a dedicated effort to empower the FileMaker developer in the trenches of our all important education and non-profit organizations. This training curriculum is offered at a special price for those public service workgroups that may have constrained budgets for software training.

Training materials for this series of classes come directly from FileMaker Inc. and includes a 200+ page textbook, example & exercise files, quiz questions and interactive training video content on an included CD.

CLASS 1 – FILEMAKER SKILLS LEVEL 1 (2 days) Register

Training Date: 10/20/2008 – 10/21/2008, 8:30AM - 4:30PM with a 1 hour Lunch
Training Location: University of Washington – 18115 Campus Way, Bothell, WA 98011
Trainer: Jason Young
$425 – (Includes a discount 50% off of our standard training) Materials included
Register: http://secure.solutionmakers.com/store/index.lasso?page=detail&id=160

This class will cover the following FTS modules:
Using FileMaker Pro
Working with Fields
Data Modeling
Working with Layouts
Calculation Functions

CLASS 2 – FILEMAKER SKILLS LEVEL 2 (2 days) Register

Training Date: 10/22/2008 – 10/23/2008, 8:30AM - 4:30PM with a 1 hour Lunch
Training Location: University of Washington – 18115 Campus Way, Bothell, WA 98011
Trainer: Jason Young
$425 – (Includes a discount 50% off of our standard training) Materials included
Register: http://secure.solutionmakers.com/store/index.lasso?page=detail&id=161
This class will cover the following FTS modules:
Scripting
Reporting
Security
Intermediate & Advanced Techniques

Thursday, September 4, 2008

FileMaker Authorized Training, September 16 & 17 and 18 & 19

SolutionMakers, Inc., one of 15 FileMaker Authorized Trainers in the country and the only one in the Pacific Northwest, is offering its FileMaker Training Series Development Skills Courses One and Two this September. These courses are designed to provide a solid foundation for those just starting to develop in FileMaker or a refresher for more advanced developers looking to get FileMaker certified. Class registration can be done online at SolutionMakers.com. FMPUG and TechNet members should be sure to check their membership for discounts as well.

All SMi courses are taught by FileMaker Authorized Trainer, Jason Young. Jason has been working with FileMaker since the late 90's and is FileMaker 8 and 9 certified. He has trained a number of work groups over the years and in the last few years has made a terrific transition to the classroom. Jason always encourages his students to bring their projects to class so that the lessons learned can be readily applied to the projects currently being worked on.

All SMi classes are taught at the University of Washington, Bothell campus. This campus is located just off I-405 northeast of Seattle. Since it is a newer college campus, the classrooms offer state-of-the-art technology and an easily accessible campus.

SMi requires that each attending student bring their own laptop, preferably with their current project loaded onto the machine, and a copy of FileMaker 9 on it. Each student also needs a copy of the FileMaker Training Series Manual. This can be purchased through SMi or through FileMaker. Laptop rentals are also available.

For those who are unable to attend the September classes, SolutionMakers always has another set right around the corner. SMi will offer these same classes, as well as the more advanced one-day class, FileMaker 9 Server Admin, Connectivity & the Web, October 20-24. Registration for all classes can be done online at SolutionMakers.com.

FileMaker 9 Developer Skills 1 (Two Day Class)
September 16-17, 2008




FTS Modules covered in this session:

1) Using FileMaker Pro: Approach FileMaker Pro 9 from the perspective of
users:
Learn techniques for working with FileMaker data, printing & exporting, performing Find requests, and accessing features for working with email, Adobe PDF and Microsoft Excel documents.

2) Working with Fields:
Learn practical skills required to define FileMaker Pro 9 data tables and fields. This module explores data types and options for auto-entry, validation, and field storage. Discover how to manage images and other objects in container fields and work with the Database Design Report in FileMaker Pro Advanced.

3) Data Modeling:
Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. This module also covers lessons in building layouts using related data fields and portals.

4) Working with Layouts: Review new features in FileMaker Pro 9, such as conditional formatting and auto-resize, while learning how to work with layout objects. Understand how field behavior and tab orders are controlled, learn to create different kinds of value lists, and work with the Web Viewer object, Tab Control object, and Tool Tips.

5) Calculation Functions:
Learn how functions work in the calculation engine in FileMaker Pro 9. Study how custom functions are built and how to best apply them to database solutions.

FileMaker 9 Developer Skills 2 (Two Day Class)
September 18-19, 2008




FTS Modules covered in this session:

6) Scripting:
User controls and interface elements are generally driven through scripts in FileMaker Pro 9. Explore best practices in scripting, learn how to build navigation and window controls, and study logical branching and looping routines.

7) Reporting:
Practice creating reports in FileMaker Pro 9 using a variety of techniques.
Explore sub-summary reports that group information by break fields. Learn how to build a cross-tab report (with data-driven columns) and an HTML report that is displayed via the Web Viewer object.

8) Security:
Study the account-based security features of FileMaker Pro 9 and learn how to implement privilege sets, tie access to database solutions to external authentication servers, control both access and authoring rights to systems, and extend security controls with scripting.

9) Intermediate & Advanced Techniques:
Work with relational value lists, write scripts that leverage object naming, and explore Custom Menus in depth. Learn advanced techniques with portals that include dynamic sorting, filtering, row highlights and preview panes.

If you're interested please visit the SMi website or call 1-800-237-3975.

Tuesday, September 2, 2008

Enhancements to 123sync™ Now Available

123sync Standard Edition Version 1.1 Adds Products, Employee and Time Tracking Features

SEATTLE, WA – September 1, 2008 – Accounting integration experts, SolutionMakers, Inc., are pleased to announce the release of the first enhancement to their QuickBooks accounting integration tool, 123sync Standard Edition. The FileMaker-based application was initially launched at the FileMaker Developer Convention in Phoenix last July and features the ability to integrate a majority of QuickBooks modules with FileMaker, SQL, MySQL and Oracle based business solutions “in as little as an hour”. The list of supported QuickBooks modules now gets a boost with the release of 123sync version 1.1. In addition to the initial set of features which included the ability to interact with vendor, job and customer data for example, users now have access to products, employee and time tracking data as well. For a complete listing of features in this release, please visit the SolutionMakers’ website at http://secure.solutionmakers.com/store/index.lasso?page=detail&category_id=1002&keyword=&skip=1.

One example of the changes users can now take advantage of can be seen with the post of an invoice to QuickBooks. 123sync will now update the QuickBooks inventory figure as sales-based inventory changes are made. For example, if Mike’s Bikes stocks 10 sets of peddles and a customer purchases one, once the transaction is recorded in Mike’s system (typically an automated process at checkout) 123sync will be ready to sync with QuickBooks to subtract one from the total. The 10 displayed in QuickBooks will now read nine.

123sync users who upgrade to version 1.1 will also be able to extract employee records from QuickBooks and add new ones as well. Should Mike wish to add Sally the Sales Clerk to his payroll, he simply enters her details into his business solution and, once synchronized with 123sync, QuickBooks will now be ready to issue Sally a paycheck.


Quite often, paychecks are driven by time worked. SolutionMakers has now added time tracking in version 1.1 as well. Should Sally log an eight hour shift, at the end of the day when Mike syncs his business solution with QuickBooks using 123sync, Sally’s time will be reported. In addition, should he
later learn that Sam, the Sales Clerk, accidentally logged his time under Sally’s account, he can simply delete those hours and, upon syncing with QuickBooks, those eight hours worked will be removed and not be accounted for on Sally’s paycheck. Logging hours against jobs will also update the Job Cost features in QuickBooks.

With version 1.0 of 123sync, SolutionMakers introduced itself as a knowledgeable resource in the accounting software development community. With version 1.1, SolutionMakers takes the first step towards offering an entire suite of robust accounting integration tools that accommodate a multitude of account software packages. In the short term, look for SolutionMakers to release the 123sync for QuickBooks Enhanced Edition later this fall.

Monday, August 18, 2008

SolutionMakers blog now online

Welcome to the initial post on what will surely be an effective resource for clients, business partners, and friends of SolutionMakers, Inc. – our company blog!

Who is SolutionMakers, Inc.?

Headquartered in Seattle, WA, SolutionMakers, Inc. offers integrated business management solutions and software training. Since 1995, our focus has been “Transforming Technology into Tools” that our clients can use to grow and manage their business. These tools include solutions for project management, accounting integration, scheduling, account management, and other critical business management tools for the construction industry, medical industry, and beyond. Our commitment to answering our phone and offering qualified, personal customer service is unparalleled in the software industry. Best of all, whether you run your business on Windows, Macintosh or mixed platform networks our solutions are 100% cross platform compatible.

Why a blog?

As experts in understanding data flow and business processes, we have a wealth of information to share. This information will not only help our immediate loop of contacts stay in sync with our efforts (ie. software updates, tool usage suggestions, etc.), it should also prove to be a helpful resource for others as well. Although you can always visit our official web site at http://www.SolutionMakers.com, a blog will offer a number of our employees the opportunity to share information in a slightly less formal format. This blog will also serve to better connect us with our customers as it offers two-way communication in the form of blog comments (direct e-mails to Info@SolutionMakers.com are still encouraged as well). Your feedback is highly encouraged as it will help drive future features of our products.

What will you be blogging about?

Topics on our blog will include tips and tricks with the latest software technology, company news, suggestions for operational best-practices in various industries based on common data flow occurrences, and more!

Please bookmark http://solutionmakersinc.blogspot.com and be sure to check back often. We have a lot to share and look forward to hearing from you as well!