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

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.

Opportunity Tracking Database

Browse all contract opportunites from potential to awarded.

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.

USPS Label Sorter for Periodicals

Allows user to import data from excel, view 3541 worksheet, print labels

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.

Lodging Reservation System

Access to all modules: Clients, Properties, Housekeeping, Reservations, Contacts

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.

 

Fleet Vehicle Maintenance

Tabbed browser lets you view work orders, vehicles, parts orders and fuel usage.

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.

Building Permits

Building Permit Browser

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.

Employee Time-Off

SWSD Time-Off Schedule

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.

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.

Real Estate Transfer Tax

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.

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!

 

Scheduling

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

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!

Property Management Maintenance

Work List

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.

Business Licenses

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

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.

Cycling Club Points Database

Race Results

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.

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.

Animal Shelter

Shelter Records

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

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.

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.