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 (40km) north of the CaliforniaOregon border. The Klamath Falls area had been inhabited by Native Americans for at least 4,000years 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
  • Greystone
    We built a Quality tracking database that imports text files from machinery and reports defects for this automotive part manufacturer
  • West Broad Hyundai Dealership
    We've built an Access Database that imports lead data from a variety of sources, massages the data and reports it the way the dealership wants to see it.
  • Strategic Technology Systems
    Strategic Technology Systems is a full service IT company that provides consulting and support to their clients that need hardware, networks, servers, etc. running smoothly for their companies. Adam Mears, owner of STS contacted me to build an Access database for his client, The Snead Company, a commercial window supplier to the commercial construction industry. This Access database is web enabled with a SQL Server back end. Additionally it interacts with Sharepoint, providing light document management services. The Snead Company creates proposals for their clients using this Access database and then tracks the progress of those proposals to winning status (or dead status).

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Hercules Chemical - Alizay
    Supported their Access Database
  • Hercules Chemical - Franklin
    Supported their Access Database
  • Glave Firm, The
    A NATIONALLY RECOGNIZED ARCHITECTURE, interior design, and planning firm, Glav & Holmes Architecture was founded in 1965 in Richmond, Virginia. The firm of 60 architects, interior designers, historic preservationists, and supporting staff, maintains a diverse and integrated portfolio demonstrating expertise in numerous market areas, including Higher Education, Cultural, Civic, Hospitality, and Residential. Clients are provided with comprehensive services whether projects involve new buildings, additions to buildings, renovations, or adaptive reuse.

Integrate Access with Other programs

How Integration Works
  • Bravo Wine Imports
    Bravo Imports Wine mostly from Italy and sells, through agents, to restaurants and markets including Kroger. This database application provides both a web page for entering orders as well as Quickbooks integration for creating invoices from those orders and updating current inventory and product lists. This is accomplished through an ODBC connection directly to Quickbooks. Agents and Items are managed through the Access database which communicates with the Website via MySQL connection (attached tables in the Access database). When Agents place orders, those order are viewed in the Access database, massaged and approved. Again through the use of attached MySQL tables. Bravo Wine is in Harrisonburg, Virginia. We provided the Microsoft Access help for this project
  • B to B - DuPont
    SQL Server Admininstration Support
  • Masonomics
    Microsoft Access Database for a commercial mason that sends text messages, connects to SQL Server web database for mobile web pages, and retrieves Timberline project information for project resource scheduling. This is one of the most complex Access Databases we've built considering the number of integrations with other systems.

Here are some clients we have helped in Klamath Falls

Client

Location

Project Description

Bear Technologies Klamath Falls, OR 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