Klamath Falls, Oregon

Professional Access Programmers - building and fixing databases.

We remotely support Access databases in Tulsa and throughout the country. We hold shared view sessions to discuss and document database needs, then work against this scope of work to satisfy our clients. These are Access Databases the require advanced knowledge of Access, VBA programming and best practices.

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

Clients

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
Food and Drug Administration
Dynamics Edge had a contract to Train the Food and Drug Administration. When they had an Advanced Access Class to train, they called us as Expert Access Consultants to perform the training in Silver Spring, MD
B to B Solutions
Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA

Dominion Partners
Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
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
Carmax
Built a legal matter tracking database for this Fortune 500 company with headquarters in Richmond, VA but locations all across the nation including Orlando, FL

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.
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.
B to B - DuPont
We were hired by BtoB, a SQL Server development and administration company to help their client: DuPont to provide administration support to their SQL Server Databases

The Chemical giant, DuPont, has a SQL Server farm that provides databases to the company's offices around the world.

We provided this service at the DuPont Chemical plant in Richmond, Virginia.

DuPont is a Fortune 500 Chemical Company headquartered in Wilmington, Delaware.

From their website: See what makes DuPont one of the most successful science and engineering companies in the world.

Values: Our core values govern our internal business practices and partnerships, and guide our innovations.

Leadership: Meet our Chair and CEO, board of directors, corporate executives, and regional and functional leaders.