|
SERVICES
|
|
"Information is your
organization’s most valuable asset."
Brady Systems Solutions
provides a wide range of services to help you manage this
critical resource using Access database technology. |
 |
|
New Database Design
With a well-designed custom database your
operations will run more efficiently saving you time, reducing costs and
positioning your company for future growth. During the design stage, we
collaborate with you to gain an understanding of your data
management requirements and administrative workflow, then
design and build an Access-based system customized to the
way you conduct business.
Each step of the way we will consult and coordinate with
your Information Technology personnel to ensure that the new
database meets your standards for security, reliability,
source code versioning, documentation and applicable
regulatory requirements.
After implementation you
will receive:
|
Existing Database Upgrade and Enhancement
Your information systems must keep pace with growth and a
constantly-changing
business and regulatory environment. When your
existing Access database system
no longer meets your needs, Brady Systems Solutions
can:
Access Consulting From basic questions about the capabilities of Access to a
detailed plan for solving
a complex data management problem,
Brady Systems Solutions will show you how
to use Access to
its fullest potential.
We can help you:
◊ Train staff on specific Access features and functions
◊ Determine if Access is the best fit for a specific problem
or proposed project ◊
Query and report information from IBM DB2, Oracle and SQL
Server databases ◊ Analyze data from multiple sources/systems
◊ Organize and clean up data in an existing database
◊ Convert data from one system to another
◊ Prototype systems to be developed using other technologies
(proof-of-concept)
Technologies Used
-
Microsoft Access (2000 to 2007) forms, reports, queries,
macros, modules
-
Visual Basic for Applications (VBA) programming
-
Structured Query Language (SQL) programming
-
Microsoft SQL Server 2005 T-SQL, Management Studio
-
Microsoft Office (2000 to 2007) Word, Excel and Outlook
integration
-
ODBC connectivity to IBM DB2, Oracle and other relational
database management systems
|