Klamath Falls Oregon

Microsoft Access Klamath Falls Oregon

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. It was named after the Link River, on whose falls the city was sited. The name was changed to Klamath Falls in 1893. The population was 20,840 at the 2010 census. The city is on the southeastern shore of the Upper Klamath Lake and about 25 miles (40 km) north of the California–Oregon border. 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

Build / Fix your Access Database

How we Build and Fix an Access Database

Integrate Access with Other programs

How Integration Works

Here are some clients we have helped in Klamath Falls

Client

Location

Project Description

Bear Technologies Klamath Falls, Oregon Partner to fix Access database for their Police Client: Police Department, Klamath Falls, 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 form – 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