Database Projects

Simplify Your Life!

Cook Software Solutions customizes your application to suit your specific needs. Because of our expertise and experience, we also suggest features that make it much easier to use your application.

Completed Database Design for our Clients

timeline_pre_loader
Security Transaction Tracking & Reporting

Created Access application for venture capital firm to track security transactions. Application uses Automation to interact with Excel, Word, and Outlook programmatically.

Generates customized, formatted Word documents from data in the database

Creates and sends customized e-mailings to contacts in the database

Retrieves stock quotes at 5 PM every weekday via the web and stores them for historical purposes

Tracks thousands of transactions including buys, sells, and stock splits

Promotional Dollar Tracking

Created Access promotional spending application used by a Fortune 500 company to track its 70 million dollar promotional spending nationwide.

SQL Server Upsizing

Upsized existing Access databases to SQL Server and optimized for superior performance.

Cost Tracking

Created Access cost database used to track departmental costs by project, employee, and product.

Production & Inventory Management

Created Access application to manage orders, work orders, receiving, production scheduling, shipping, and sales reporting for a pipe coating company.

Scheduling

Created Access application used to schedule executive training programs for an executive training firm. The application features a scheduler that allows the user to schedule instructors based on their availablity and ability to teach the program, a monthly calendar that displays program scheduling information, and a materials generator that builds a list of materials required for a given program.

Scheduling

Created Access application to schedule employee visits for a health care firm. Among its many features, the application uses scheduling data in the database to calculate employee mileage for expense reporting purposes, generates time sheets, and generates expense reports.