Klamath Falls Oregon

Microsoft Access Database in Klamath Falls, Oregon

We partner with Bear Technologies in Klamath Falls and Build/Fix Access databases with their clients including the Tulelake Police Department. Bear Technologies is an example of one of our computer engineering strategic partners that needs an Access Database expert on hand to help with their clients.

From Wikipedia: Klamath Falls is a city in and the county seat of Klamath County, Oregon, United States. The city was originally called Linkville when George Nurse founded the town in 1867.

The Klamath Falls area had been inhabited by Native Americans for at least 4,000 years before the first European settlers. The Klamath Basin became part of the Oregon Trail with the opening of the Applegate Trail. Logging was Klamath We've developed Access Databases in Klamath Falls for the Police department (subcontracted through Bear Technologies). These are professionally built database with advanced navigation forms, criterion for reports, and normalized table structure.


Subcontract / Partner with us for your Client's database

How Partnership Works
  • Commonwealth Computer Training
    Commonwealth Computer Training has referred us and subcontracted us to a number of their clients including the French Insurance Giant: Allianz. We have provided Access database development and mentorship.

    From Commonwealth's website: Commonwealth Computer Training (CCT) opened in 2001 as the technology training division of Commonwealth Personnel Consultants, Inc., Patricia W. Haynes, a Certified Personnel Consultant, co-founded Commonwealth Personnel Consultants in 1985. It is one of the first female owned and operated recruiting firms in the Richmond, Virginia area. CCT is a SWAM certified business.



    Commonwealth Computer Training

  • WSI Web Strategies
    Subcontract build Access & Web applications to Pack & Ride and Vatex and a Soccer Association. We subcontracted to WSI Web Strategies to help their clients. Both are in Richmond, Virginia
  • Epitome Systems
    Network Engineering Firm in Columbia, Maryland.

    They subcontracted us to Fix an Access database for determining hospital emergency room time differentials for their client Bon Secours in Baltimore, MD.

    This Access database was developed to track efficiency of the emergency room operation at Hospitals for Bon Secours. The various stages of a patient's visit are tracked and the minutes recorded for moving through each stage of the emergency room visit.

    This database uses extensive Forms that have built to provide the quickest data entry possible for the user.

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Holiday Signs
    Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

    We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting
  • Pepsi Bottling - Los Angeles
    Trained Pepsi on an Access Database we built tracking plant efficiency. We worked in Los Angeles (Riverside plant) and also created a training manual for the plant.
  • PepsiCo Global Concentrate Solutions
    In Atlanta, we are working with PepsiCo Global Concentrate Solutions to implement a Plant Picking database we built for Pepsi's Carlisle, PA plant. Pepsi Bottling approached us 20 years ago to build a Plant Efficiency tracking database that was rolled out nationwide. The other divisions within Pepsi then contacted and contracted us to build other professional Access database solutions.

Integrate Access with Other programs

How Integration Works
  • Hospital Hospitality House
    Developed Access database for charity hotel organization. This hotel management application interacts with both a Topaz Signature pad for capturing hotel guest signatures as well as Adobe Acrobat and for producing .pdf files.
  • Greystone
    Manufacturing Firm in Toano, Virginia.

    We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.

    This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer

    From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina initially engaged us to build an Access Database to track Environmentl Protection Agency (EPA) forms. They have over 2,000 EPA forms on file with the US Government.

    Upon further conversation and discovering the intent of this chemical/pesticide client, we decided that an Access Database WAS NOT the proper solution.

    They desired people AROUND THE WORLD to enter and query their application. So we built this database using PHP web pages and a SQL Server data file. You may find more information about this application at www.data-blade.com

    From their website: We know that growing is about more than just crops and cultivation. It's about sunshine and rain, early mornings and hard work. It can be frustratingly unpredictable, but also wonderfully uplifting. More than anything, it's about people. Nufarm is the dependable partner behind thousands of agricultural success stories. Every day, growers around the world turn to our products and our people to help with the challenges of fighting disease, weeds and pests, and to increase crop yields.

Here are some clients we have helped in Klamath Falls

Client

Project Description

Bear Technologies Partner to fix Access database for their Police Client: Tulelake Police Department, OR. We provided them with this quote:

1. Asp.net application that can be run from any computer using a web browser. this will be used on any and all PCs used by the department

2. 3 tables plus asp.net log in tables a. Crime Report (currently 130 +/- fields) b. Officers (currently 9 fields); add user name field from asp.net for correlation c. State Abbreviations (currently 1 field)

3. Forms for data input a. Log in to asp.net app b. New user to asp.net app c. Edit/Add officer to SQL database (there will be an association of New user to asp.net using user name from asp.net) d. Edit/Add State Abbreviations to SQL database e. Edit/Add Crime Report to SQL database

4. Reports a. Crime Report

5. Search feature on Crime Report form

6. Record navigation feature on Crime Report

7. Print Button on Crime Report

8. Sync Button on log in to asp.net for - requires password

9. Sync new records to SQL Server Express

10. Update modified records to SQL Server Express

11. At present a sync from SQL Server Express to the asp.net application is not included

12. At present migrating old data from MS Access to SQL Server Express is not included

Contact



Our Process

  1. Discovery Conversation
  2. Agree to scope of work
  3. Test plan creation
  4. Iterative database development with client input
  5. Database rough draft delivery
  6. Database final implementation
  7. Database user documents
  8. Database developer documents