Access Database Consultant Developer Programmer

UPGRADE
ACCESS
DATABASE

  • LOMC, LLC / PrimeLegal
    LOMC LC / Prime Legal is a prepaid law firm. We built a web application to manage their referral network
  • GUSA Soccer
    GUSA Soccer is a Soccer league in Goochland, Virginia. We built a website to manage their player registations
  • At Home Care
    AT Home Health and Hospice Care is an established, full-service home health agency and hospice that provides a superior quality of services in a caring manner. We built a web application to manage their Doctor sign off process
  • Pack & Ride
    Pack and Ride provided portable box solutions to both house and transport belongings. We built a web application to manage logistics of container delivery to Pack and Ride's clients
  • Ensafe
    Ensafe is an Environmental Engineering firm that was consulting to Camp Peary. They subcontracted us to build a web application/SQL Server database for their Department of Defense client that provides CIA training in Williamsburg, VA. This database tracks the hazardous materials brought onto the military base, the current inventory levels of those hazardous materials, and the disposal of the hazardous materials. The database produces the annual reports required by the Environmental Protection Agency including Form R and Tier I and Tier II reports.
  • Nufarm Americas Inc.
    NuFarm is a pesticide chemical manufacturer based in Australia. They're office in Raleigh North Carolina initially engaged us to build a web application to track Environmentl Protection Agency (EPA) forms. They have over 2,000 EPA forms on file with the US Government.

    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.

    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.

REPAIR
ACCESS
DATABASE

  • 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
  • Maisonettes Apartments
    Maisonnettes Apartments runs an apartment complex and a trailer park. We upgraded their previous DOS based monthly rent collection application into an Access Database. Now all functionality of tracking tenants monthly rent is handled in Access. This database also provide the lease agreements and tracks historical tenants (tenants that have previously lived at the property)
  • At Home Care
    AT Home Health and Hospice Care is an established, full-service home health agency and hospice that provides a superior quality of services in a caring manner. We built a web application to manage their Doctor sign off process
  • Pack & Ride
    Pack and Ride provided portable box solutions to both house and transport belongings. We built a web application to manage logistics of container delivery to Pack and Ride's clients
  • 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.
  • 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.
  • Shaheen & Shaheen
    Creating and modifying Access database for marketing purposes
  • 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
  • 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.

MODIFY
ACCESS
DATABASE

  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built (and Host) a MySQL database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This is a backoffice application that runs the expense side of a company with geographically dispersed employees. They track their billable time and expenses, assigning both to projects/clients.
  • Strategic Technology Systems
    An Access database with a SQL Server back end was already in place at CeMark, STS's client. We were asked to migrate the data file to a new version of SQL Server.
  • ActivSupport
    ActivSupport contacted us to fix various SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA.

    Active Support needed an expert database consulting company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. By supplying professional database developers to ActivSupport and their clients, we kept both our partner and their client happy
  • 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.
  • Bear Technologies: Tulelake Police Department
    Partner to fix 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

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database