Transcript Key Features - OpenGate Software

Ultimate Bundle Overview
•Products
•Benefits
•Technical Requirements
•Licensing
Pricing Valid until 01-Sep-2010
OpenGate Products
Database Creation
– Designer steps users through Q&A wizard to design their database. Designer
automatically generates the necessary tables, relationships, and data entry forms.
Learn More>>
Menu Navigation
– UI Builder adds attractive menu navigation and advanced features to existing
Access databases. Learn More>>
Analysis and Data Visualization
– Dashboard Builder offers quick access to key metrics and trending directly within
an Access database. Learn More>>
Database Automation
– Workflow Builder allows you to automate repetitive processes. Users define task
flows that use pre-defined actions instead of macros or Visual Basic. Learn More>>
Security
– FormSafe protects information at the data entry form level. Hide or obscure fields,
buttons, and other screen items based on who is logged in to your database. Learn
More>>
OpenGate’s products are designed to function independently, or as a single integrated suite.
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Key Benefits of the full Suite
• Save Time, Reduce Consulting Expense
– Users have pre-built tools to leverage instead of spending time
researching and testing common features
– Reduce the need for consulting to create departmental
databases
• Unlimited Use
– Unlimited use in your organization. Use any product without
limitation to the number of users or databases
• Lifetime Updates and Support
– No monthly support fees, lifetime support via phone or email
– Download updates at no charge when they are made available
to benefit from new features
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Technical Requirements
All products are delivered as Microsoft Access database files. No
additional installation is required to use them.
• Database Designers/Developers
– Microsoft Access 2000 or higher
• End Users
– Microsoft Access 2000 or higher, or the free Access 2007 runtime
license
• Optional
– OpenGate products support linked tables to MySQL or SQL Server
database tables
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Licensing
• Ultimate Bundle
$1,159 USD (25% off all product licenses)
–
–
–
–
–
–
Designer
Dashboard Builder - Professional
UI Builder – Enterprise
Workflow Builder
FormSafe
Access to the OpenGate Library of pre-packaged features
–
–
–
–
Lifetime support
Lifetime updates
Unlimited users within your company
Unlimited databases within your company
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Why OpenGate Software
• Over 5,000 users in more than 80 countries
worldwide
• Producing Microsoft Access solutions since
2001
• Integrated suite of Microsoft Access tools
built for beginners and professional
developers
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
PRODUCT DETAIL
Dashboard Builder
•
<<Return to
Product Catalog
Key Features
– Unlimited dashboards and metrics
– Visual meters with configurable thresholds
– Drilldown to your form data from each
dashboard metric
– Email alerts when thresholds are
exceeded
– Supports Microsoft Access, Microsoft SQL
Server, and MySQL® Server linked tables
– Full source code access to incorporate
meters and graphs into your own forms
•
How You Benefit
– Gain rapid access to key performance indicators to make better business
decisions
– Flexibility to define numerous dashboards that target the appropriate
audiences
– Fast implementation with no VB coding or SQL expertise required
– Incorporate into your existing database, or operate as standalone
application
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
UI Builder - Enterprise
•
<<Return to
Product Catalog
Key Features
– Multiple Web-2.0 looking menu layouts
and unlimited custom color schemes
– More than 25 pre-defined menu button
commands that require no VB coding
– User-level menus to limit user access to
only the forms and reports they need
– Automatic backups, record-level audit
history functionality, and many more
features
– Pre-built template applications included
– Full source code access
•
How You Benefit
– Quickly gain rich functionality that is fully tested and proven
– Focus on your business instead of recreating common Access functionality
– Incorporate UI Builder into your existing database, or jump-start your next
Access project
– Minimize user frustration and training with a highly intuitive interface
– Reduce the time to maintain and troubleshoot your Access databases
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Designer
•
<<Return to
Product Catalog
Key Features
– Wizard-like questionnaire to create your
database
– Multiple design “templates” that can help
accelerate your design project
– Creates many-to-one and many-to-many
table joins
– Automatically creates lookup tables
– Allows users to select from a list of
available formats/input masks
– Automatically creates data entry forms
with related information displayed in a
single screen
•
How You Benefit
– Create complex databases without taking the time to become an expert in
relational database design
– Ensure your database is properly structured and normalized to minimize
data duplication and errors
– Reduce the time to maintain and troubleshoot your Access databases
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
Workflow Builder
•
<<Return to
Product Catalog
Key Features
– Define multiple workflows with distinct
process steps
– Execute macros, queries, VB code, or
reports
– Define success and failure paths for each
workflow step
– Run manually or on a scheduled basis
– UI Builder - Enterprise Edition included
– Each activity is fully logged
– Condition-based administrator alerts
•
How You Benefit
– Minimize repetitive manual labor and consulting
– Automate with less Visual Basic, enables beginner users to configure instead
of code
– Extensive activity logging gives you a record of each step of the process for
future reference
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483
FormSafe
•
<<Return to
Product Catalog
Key Features
– Hide, disable, or obscure any Access
control (button, label, text box, etc.) at
runtime
– Support for first-level subforms
– Visual Basic expertise not required
– Configure rules by user integrate with UI
Builder – Enterprise to establish rules at the
role level
•
How You Benefit
–
–
–
–
–
Increase form security at the user level
Reduce development time and effort
Eliminate duplicate forms or hard coding to hide fields by user
Ensure compliance with government privacy regulations
Easily integrates with any Access database
Copyright 2010 OpenGate Software Inc.
Contact Us 888.967.6483