Rather than trying to integrate multiple electronic files and information sources such as corporate enterprise data, 3 additional access databases, and 5 additional excel spreadsheets...

Wouldn't it be nice to have the capability to manage new content and new data that you find your primary database program has left out? Perhaps your business has expanded and you need to track new concepts of your business that your first database didn't include. Rather than building a new database to track this new business concept, since, in an ideal world, ALL of your data ought to communicate seamlessly, why not use one application for all of your needs. Sound like paradise?

Vacation Rental Managers Association Website
Vacation Rental Member and Public Website
This site offers users quick and easy access to company products and services for 6 different audiences for this industry. To accomplish this, we thoroughly organized the site into easily understood sections so the unfamiliar user can clearly navigate. One service includes a contact database that offers sophisticated search tools based on location, descriptions, and keywords. The strength in this project is giving the site administrators all necessary tools for managing site content. Administrative Assistants can post and expire news articles, images, links, files, membership information, and registration forms as needed saving time conducting site clean up. The administrative utilities of this site make managing site content and exposure of company data so easy for an admin to manage and a user to view thereby saving ample time and costs programming or creating new content. Like the Event Registration system, this system excels in flexibility.

Safety Compliance System
OSHA Compliant Safety Database
Tracks and reports OSHA specified and required data on occupational injuries and workman's compensation. If, in your workplace, you have ever had to longhand an OSHA regulatory report that lists injuries at your facility, you would know what a task this can be. The form calls for 20 minutes, and I've seen it take over 2 days to compile the required information. This system lets your organization track such events, and all related costs as well as the progression of the injury. This system tells a business now many lost workdays the company has suffered from work-related injuries. Business owners also have the luxury of running statistical reports that illustrate what types of injuries are prone to occur, why, and when. This allows a business to apply such knowledge and focus management efforts to reduce injuries...therefore also reduce costs, suits, and insurance premiums as a result.

Human Resources Enterprise Database
Employee Resume with Appraisals, Feedback, Ratings
This complex system allows a business to track anything it needs to know about its personnel resources. For example: When someone in your company has given notice imagine the comfort in knowing you can run a search and find a matching and qualified candidate to fill the position from inside your company. Not only do you find the candidate, you are able to see his entire resume history from before and from working with your company. With such a complicated matrix of information, human resource processes and recruiting are minimized and the time can be better spent retaining valuable employees and building productive programs.

Reservation Database
Web Based Reservation and Scheduling System
This system replaced a tedious spreadsheet and allows online childcare bookings and scheduling. Clients request childcare services and then administrators schedule childcare providers based on their availability. The built in 'scheduler' ensures that the providers have steady workloads based on their hours available for work which they manage using specific weekly schedules, dates, and time frames. This system runs over secure server and accepts credit card transactions. The administrative side of the system offers statistical reports listing which providers are assigned to which clients and when, cancellations, and also distributes confirmation receipts when the client registers for a service.

Employee Phone Book
Employee Phone and Location Roster
This web based tool allows anyone company wide to run a list of employees and how to contact then by various means including work location, job titles, and departments. Think of a phone directory that gives you the information you want with 2 clicks of a button.

Conference and Event Registration
Seminar and Conference Event Registration System
Tracks registrations, cancellations, and all associated costs, fees, and payments for requested services. This Web based tool includes sophisticated reporting capabilities (including PDF reports) that enable administrators to run attendance lists at event sites as well as distribute registration confirmations to customers via email. We accomplished a unique requirement of this system enabling users to easily create and manage their own custom sorts and filters. This offers quick and easy data manipulation for building custom report lists for rapid, on-the-fly reporting needs.

Human Resources Appraisals System
Performance Appraisals and Employee Feedback
This Human Resources application is a web based tool that allows employees and managers to share feedback on employee performance. The system also tracks goals for the employee and how well they achieve their goals in given time periods. This unique system increases employee productivity with the company by aligning Company goals with the specific goals of the employees which provides greater motivation to accomplish work related tasks that benefit both the company and the employee.

Insurance Claims
Liability, Asset, and Loss Claims
How much money does your company lose to stolen or damaged property and how does such affect your insurance premiums? If you knew accurately what was being stolen or damaged, then you would know where to focus your attention to prevent such events. If your organization deals regularly with 3rd party claims, or general liability claims, wouldn't it be nice to track the progress and costs of each claim. This system tracks a claim through it's life enabling a business to focus efforts to reduce such costs.

Tax Accrual and Return System
Asset Tracking for Depreciation and Amortization
This Access database system tracks balance adjustments for the amortization and depreciation of corporate assets such as tools and equipment from year to year through the life of the asset. The tax processes this system use are known as M1 and FAS accrual and return.

E-Newsletters
HTML Rich Email Distribution
Rich E-Newsletters client reports, invoices, receipts and news updates sent through web interfaces.

Company Intranet
Company Intranet and Web Based Reports
Here, we upgraded less-than-user-friendly reports with a set of web based reports that accomplished two goals:

1. Everyone in the company can now access their own data any time and in their requested format with ease.

2. The time required to run reports we cut in half by leveraging additional database technologies and practices, making web based reporting a possibility.

In this project, we also gave the users the ability to export their web based report into an excel spreadsheet for further data manipulation and sorting.

Insurance Bonds Database
Insurance Bonds Tracking System
This system tracks the activity, sureties, and insurance bond related costs for Heavy Civil Construction projects.

Knowledge Library
Library Tracking System
A library-type filing system of submittals, proposals, engineering projects, and contractors for easy search and retrieval functions. This system tells who has what documents and files checked out (from the library) as well as where to find the physical files. Administrators run labels to tag each document file for physical file storage and retrieval.

Active Directory Tools
Windows Active Directory Tools and Utilities
Ever think about how easy life would be if Active Directory employee data matched your company's enterprise data management system? We have created a collection of programs that synchronize Active Directory user data with other enterprise database systems. In addition we have several custom interfaces that enable users to update contact information.

Tronick Training Solutions
Tronick Training Solutions - TTS
A network of industry professionals that specialize in providing software training solutions for corporations, non-profit organizations, and government institutions in the Monterey Bay area and beyond.