Home Services Portfolio Resources About Us Contact Us

Site Map

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:

  • User training

  • Assistance with transitioning to the new workflow as needed

  • One year of support after project completion to

    • answer your questions

    •  make minor modifications as needed

    • ensure the system fully satisfies your documented business and technical requirements

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:

  • Leverage your database investment by adding new features and functionality

  • Fix problems with an existing database including

    • Program bugs

    • Poorly-designed user interfaces

    • data source connection errors

    • Microsoft Office upgrades

    • other functional or technical issues

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

 

Home

Services

Portfolio

Resources

About Us

Contact Us

Site Map