Microsoft Access

You are browsing our project gallery containing some examples of past project work. Contact us today for an initial consultation or quote!

Donor Database

Browse all contributors, both active and inactive, using various search options
Client: 
Hospice of The Valley

This intuitive system will make it easy for your non-profit to sort out donations received.  Tracks donors, contributions and events. Allows for simple thank-you card list organization. Includes publishable reports for contributions by level by event or in memory of.

Project Tags:

Opportunity Tracking Database

Browse all contract opportunites from potential to awarded.
Client: 
Aspen Earthmoving

Incredible business analysis tool! Designed to help construction businesses keep track of potential opportunities during the bidding process, this system was designed to integrate with the Timberline accounting system but can stand alone as well. Great for business developers and CFOs to get a real-time snapshot of where active contracts stand with the click of a button while keeping all members of the bid team on the same page. Intuiative charts and graphs on forms and reports have impressive visual impact for presentations.

Links: 
Timberline Software for Real Estate and Construction
Project Tags:

USPS Label Sorter for Periodicals

Allows user to import data from excel, view 3541 worksheet, print labels
Client: 
Colorado Snow Scoop

Developed for Snowscoop, a snowmobiling periodical, this database saves days of work by importing your addresses from pre-formatted excel files and creating a 3541 worksheet for you. It also prints your labels.

Project Tags:

Lodging Reservation System

Access to all modules: Clients, Properties, Housekeeping, Reservations, Contacts
Client: 
WoodrunV Townhomes

A complete lodging management system that tracks units, owners, guests, reservations, housekeeping, maintenance and billing. Availability of units is published dynamically online with the click of a button using ODBC and MYSQL. Allows for entry of complex commission structure for multiple tour operators and travel agents as well as differing rate structures for each unit. Contracts are merged into Microsoft Word Documents.

 

Project Tags:

Fleet Vehicle Maintenance

Tabbed browser lets you view work orders, vehicles, parts orders and fuel usage.
Client: 
Town of Snowmass Village

Utilized by the Town of Snowmass Maintenance Dept and Waste Solutions of Carbondale for years now, this database keeps track of maintenance needs, work orders and fuel usage for a fleet of vehicles. The application makes work order input a snap with the extensive list of vehicles and the parts they have built up over the years. Service packages by vehicle class can be set up to automatically create work orders for common services like oil changes that need to be done on a mileage basis.

Project Tags:

IT Inventory

Computer Configuration

IT manager's organizational tool keeps track of all hardware (towers to mice) and associated software. Record maintenance contract dates and numbers and inventory all equipment serial numbers. Automation makes hardware swapping easy.

Project Tags:

Real Estate Transfer Tax

Client: 
Town of Snowmass Village

Utilized by the Town of Snowmass Village Clerk's dept for 3 years, this database tracks all Real Estate Transfer Tax transactions and sends letters to title companies.

Project Tags:

Guest Management System

Guest Management Database

For the hotel industry, this marketing tool keeps track of detailed information on guests such as restaurant preferences, grocery lists, anniversaries, weddings, children's' names and ages, and extensive housekeeping notes.

Project Tags:

Building Permits

Building Permit Browser
Client: 
Town of Snowmass Village

Utilized by the Town of Snowmass Building and Planning Dept for 4 years, this database keeps track of all Building Permits for TOSV. The database keeps track of local zoning information, contractor licensing and renewal, Building Permits in all phases of development, Sub-permits, and all inspections on building permits.

Project Tags:

Art Management

Keep track of your professional art pieces. Includes piece names, date of creation, origin, current location, design types, categories, and infinite photos of each piece. NOW Web oriented!

Project Tags:

Cycling Club Points Database

Race Results
Client: 
Aspen Cycling Club

Keeps track of membership, races, and results for the Aspen Cycling Club. Easy entry for categories and times lets you create result sheets in just a few minutes.

Project Tags:

Cost Recovery Database

TOSV COMM Dev Planner Log

Utilized by the Town of Snowmass Building and Planning Dept, this program keeps track of planner hours and bills projects monthly to recover the town's costs. Planners can enter hours from separate workstations. Takes base fees into consideration.

Project Tags:

Property Management Maintenance

Work List
Client: 
Alpine Property Management

A great tool for a property manager, this application keeps seasonal task lists on managed properties. Services and the vendors used are customizable and allow extensive reporting by home, vendor or service.

Project Tags:

Animal Shelter

Shelter Records

Tracks animals and how long they have been in the shelter, treatments administered and any background information available.

Project Tags:

Time Tracking Database

Block Hour Listing

Great for consultants! This program tracks individual hours worked on projects and provides invoicing. A nice way to let your customers know what you are doing even when you don't bill!

 

Project Tags:

Employee Time-Off

SWSD Time-Off Schedule
Client: 
Snowmass Water and Sanitation District

Utilized by the Snowmass Water and Sanitation District, this program tracks employee's earned and used time-off and sick time based on date employee. Easy reporting lets you send individualized reports to each employee.

Project Tags:

Horticultural Database

Customer File

Tracks customers and the specialized services they require for a horticultural company in Glenwood Springs. Provides proposals, work orders, invoicing and accounting reports.

Project Tags:

Business Licenses

Client: 
Town of Snowmass Village

Utilized by the Town of Snowmass Village Clerks Dept for 3 years, this database tracks all business licensing and renewals for the town.

Project Tags:

Scheduling

Client: 
Sierra Mountaineering Inc

Originally designed for Sierra Mountaineering Inc, This database schedules client reservations for custom activities using an easy-to-use use calendar format.

Project Tags:

Travel Agent

Reservations

This program tracks clientele and their respective reservations for a mountain travel agent. The system tracks condo or house reservations, airline tickets, ski tickets, and car reservations for clients. Lodging rate calculation (different costs for different nights), payment tracking, and referral pay-off reports.

Project Tags: