Transcript MS PowerPoint

FileMaker Pro
Solution Portfolio
Member since 1997
•
We invite you to browse this portfolio which presents a
wide variety of solutions we have created for clients in
various industries and disciplines.
•
Each solution is unique and custom-tailored to the needs
of our client. Likewise, you can expect the same custom
attention to any project or solution we would undertake
for you.
•
Please contact us with any questions or comments.
•
© Copyright 2008 Burnham Business Development, Inc. All rights Reserved.
7522 Campbell Road • Suite 113-178 • Dallas, TX 75248 • USA • 972.930.0525
[email protected]
TABLE OF CONTENTS
•
ORDER MANAGEMENT
•
INSURANCE BROKER
•
MOVING & STORAGE
•
BULK E-MAIL PROCESSING
•
CREDIT REPORTING
•
ELECTORAL COLLEGE
•
INVESTMENT MANAGER
•
TRADE SHOW PLANNER
•
DENTAL WEB SITE
•
PROFESSIONAL RECRUITING
•
DATABASE PUBLISHING
•
HEALTH RECORDS
•
SALES REP CRM
•
CARAVAN TRADE SHOW
•
FASHION PLANNING
•
PROPOSALS & SAMPLE ORDERS
•
TIME CLOCK
Order Management
Network Database
Originally created in FileMaker 5 and upgraded to v6, the latest
edition of Order Locator-LAN takes advantage of numerous features
in v. 7, 8 and 9. Runs on Windows or Macintosh networks, including
remote locations.
RETURN TO MENU
Online Status Information
Since 2002, this web site has
been gathering and
aggregating data reported via
FTP by various companies
using Order Locator as a LAN
system. It also accepts CSV
and XML data sent by other
companies who don’t use
FileMaker Pro.
RETURN TO MENU
Originally running with FMP6
and Lasso 3, the web based
system is now running with
MySQL and Lasso 8 and
features Ajax interface tools for
robust performance and
content management.
Insurance Broker
Insurance brokerage firm
Certificate Control
is
responsible
for
providing
underwriters
with
evidence
of
insurance
(certificates)
for
their
insured
contractor clients.
This database replaces
inefficient storage of sent
items in MS-outlook with
a centralized system that
prepares emails sent
using
smtp-it
and
maintains a perpetual log.
RETURN TO MENU
Claims Management
The same database
also inherits data
from
Applied
Systems’ TAM™ to
create custom reports
to manage claims
with
reports
that
organize claims by
state and claim type.
RETURN TO MENU
Moving & Storage
Bills of Lading & Manifests
Moving
&
Storage
company specializing in
transport
of
very
expensive fine arts from
museums and galleries,
presidential
libraries,
etc. uses this database
to enter the specs for
each job and generate
a very customized bill
of lading.
RETURN TO MENU
Upon completion of
each record, the data is
transferred
to
QuickBooks using XML.
Bulk E-Mail Processing
Address Lists, Groups & Stored Messages
This
FileMaker
runtime
solution enables users to keep
large numbers of email
addresses very well organized
for easy group selection and
mass email transmission of
either plain-text or HTML
email.
In a matter of minutes,
addresses can be selected by
various criteria and messages
prepared for delivery using the
SMTPit plugin.
RETURN TO MENU
Credit Reporting
Inherits data from any A/R system
This database is distributed
as a runtime solution to
clients of a major credit
reporting service bureau.
Its principal function is to
gather A/R data from 5
popular accounting packages
and re-format the data for
monthly reporting to the credit
bureau.
It also gives management
teams
a
“snapshot”
of
periodic credit status and
trends.
RETURN TO MENU
Electoral College
Predict the Winner!
This database was created for
entertainment in a bar at Newark
Airport on Election Day 2000 and
accurately forecast the outcome
weeks before the US Supreme Court
decided the presidential election.
It was used again in 2004 by about
10 friends who all got similar results,
accurately predicting the outcome of
the 2004 election results in Florida
and Ohio.
RETURN TO MENU
Investment Manager
Portfolio Management
RETURN TO MENU
Trade Show Planner
Advance Planning
Mailed
preregistered
show
attendees on CDROM media in 1997,
this
database
enabled people to
plan their booth
visits, create lists,
assign tasks, and
perform
various
follow-up activities.
RETURN TO MENU
to
Today, this database
would be deployed
online for easier
access and update
flexibility.
Dental Web Site
FileMaker Pro is used
PHP Web Site Integration
by this dentist and his
staff to connect to a
database
hosted
under
FileMaker
Server.
Various data tables
populate lists and
personnel information
that
appears
on
various pages of their
web site.
RETURN TO MENU
PHP connects the
FileMaker database to
the web pages.
Dental Photos
The creation of a series of technical dental
photos is handled off-line using special
photographic equipment and software.
The photos are inserted into FileMaker by
dental personnel for presentation on the
web site.
RETURN TO MENU
Professional Recruiting
Employment Matchmaking
This database
is hosted
under FileMaker Server and
accessed by a workgroup of
professional recruiters.
By matching the personal
characteristics
and
preferences with the skills
required by prospective
employers, the company is
able to serve the needs of
clients and candidates from
coast-to-coast.
RETURN TO MENU
Various
email
and
document
generation
features support the day-today business functions.
Database Publishing
From FileMaker to Quark Xpress
Book reviews and relevant publication data are written in
FileMaker Pro. Then, all the records for a 350+ page
catalog complete with 3 cross-reference index sections
is exported to Quark Xpress where style sheets interpret
pre-defined formats for automatic document creation.
RETURN TO MENU
Health Records
Student Health Services
To remain enrolled in a medical
college, students must comply
with an extensive series of
health
exams
and
immunizations on a timesensitive schedule.
This FileMaker database has
been in operation since 1997. It
was originally created in v3 and
currently runs in v6.
The college’s health services
office relies on this database to
manage the due dates for more
than 2,000 enrolled students.
RETURN TO MENU
Sales Rep CRM
Multi-User CRM
This networked CRM system for promotional products sales reps manages
clients, contacts, appointments, memos, email communication, phone calls
and product research.
RETURN TO MENU
Output Documents
When clients make purchases, the system generates order confirmations,
purchase orders to vendors and upon completion of the job, invoices for
clients. All documents can be printed or transmitted by email as PDF
attachments.
RETURN TO MENU
Caravan Trade Show
From
Database
to
Web
Site
Administrative database manages 93 venues in 53 North
American cities. Scripted data exports create updated
schedules for easy publication to the web site whenever
changes occur.
HTML
export!
RETURN TO MENU
Document Generation
PDF
flyers,
promotional
formatted
name badges and
weekly
with
schedules
destination
maps are just a
few examples of
the documents that
are produced by
the
database.
RETURN TO MENU
admin
Demographic Invitations
Using GPS coordinates, more than 100,000 people are matched in the
database to the event closest to them. The database uses an email
plug-in to send targeted invitations. In addition, fax numbers are used
for broadcast fax distribution.
RETURN TO MENU
Fashion Planning
From Marketing to Manufacturing
Manufacturer of children’s
clothing uses this database
to manage the product
specifications and graphics
used to produce each
season’s line of branded
apparel.
Network access to the
database replaces obsolete
inefficient
paperwork
system in their office and
improves
communication
with offshore vendors.
RETURN TO MENU
Proposals & Sample Orders
Efficiency & Organization
Runtime solution used by
sales reps to generate clean,
legible purchase orders (PDF
documents)
while
also
communicating
sample
purchases to their accounting
department.
The major benefit is in
improved
communication,
saving time and money by
resolving discrepancies.
The same database also
creates PDF sales proposals
with product images.
RETURN TO MENU
Time Clock
Increase Worker Productivity
This networked “time clock”
was originally designed for a
team of 3 dozen graphic
designers but can be used by
any size workgroup. It keeps
track of time devoted to a
variety of computer-based
projects by creating log-in/logout time slips that can be
associated
with
specific
projects and General Ledger
codes.
The database also handles
payroll reporting and gives
management a robust analysis
of the time spent on each job
by each employee.
RETURN TO MENU
•
Thank you for viewing our Portfolio!
•
© Copyright 2008 Burnham Business Development, Inc. All rights Reserved.
7522 Campbell Road • Suite 113-178 • Dallas, TX 75248 • USA • 972.930.0525
[email protected]