Raleigh North Carolina

Microsoft Access Raleigh North Carolina

Our Clients in North Carolina include Progress Energy, NuFarm Pesticides and The Select Group Staffing Firm. All are Access database clients relying on our expert developers and consultants.


Subcontract / Partner with us for your Client's database

How Partnership Works
  • Convergent Business Solutions LLC
    Partner to build Access database for their Retirement Home client: Virginia Baptist Homes, a retirement community. We modified this existing Access 2007 database for the IT manager of VA Baptist Homes. The database receives daily text files from the retirement home's phone systems (6 geographic retirement home locations). The 6 text files are imported, staged, scrubbed and processed into consolidated, individual invoices for the members of the retirement community. The receive monthly bills for the phone calls they make / receive. We provided the Microsoft Access Database help for this project
  • 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 and modify the existing Access database with a bunch of punch list items.
  • NTS
    Subcontracted to build Access & SQL server databases to the Virginia Lottery, the Virginia Beach Fire Department, Townes Engineering, EHS Laboratories and more

Build / Fix your Access Database

How we Build and Fix an Access Database
  • Naval Laboratory
    The Naval Research Laboratory in Waldorf, MD contacted us to build an inventory database. This Access Database handles the entire process of purchasing and inventorying all items on the base including all test equipment used at the Naval Research Laboratory. We all use hand scanner so complete physical inventories on base that stores/forwards information to the Access Database.
  • Ferrara Candy
    Ferrara Candy is a Candy Manufacturer the produces Candy in the United States and Mexico. Our Access database tracks, manages, and reports the overall equipment effectiveness of the manufacturing plants.
  • Capital One - Art
    Build Access database for Fortune 500 credit card company. Database tracks artwork throughout company

Integrate Access with Other programs

How Integration Works
  • France Environmental
    Importing leads from Peachtree And Outlook to generate sales/marketing emails that come from the Access Database and Integrate with Outlook. This is an Access database that manages the environmental compliance training classes that France Environmental offers their clients. We've built Outlook import process for both inbox and contacts. We've also built email functionality with attachments from within the Access Database.
  • 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.
  • API Services
    Precision measurement and tool calibration for manufacturing clients, we built an Access database for API Sensor that tracks associates timesheets and expenses for management reporting and reimbursement/payroll. This application connects to SQL Server which is hosted on Data Control's Web Server. 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.

Here are some clients we have helped in Raleigh

Client

Location

Project Description

NuFarm Raleigh, NC NuFarm is a pesticide chemical manufacturer that 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
The Select Group Raleigh, NC One of our former Capital One clients moved to a staffing firm in Raleigh, North Carolina. As Chief Financial Officer at this new firm, he re engaged us to build an Access Database to track Purchase Orders and Timesheet information. Ease of use and quickness in handling large amounts of imported Excel data into this Access database is key for this finance/accounting department to generate their monthly invoices while staying within the budgets if each individual purchase order. This Access database imports Excel Spreadsheets full of monthly time. This time is then applied to existing, budgeted Purchase Orders. As the budget limits of the Purchase Order is reached, the user is notified that the PO is in jeopardy of being exceeded. At that point, individual time records may be split (internal access functionality that reduces and appends) amongst additional Pos. Furthermore, this mission critical Access Database also has a series of reports that allow the users to see which Pos are in Jeopardy of expiring based on the average billings/day and the number of days left in the Purchase Order contract. Lastly this administrative Access database runs Excel Exports for creating the actual invoice that is sent to this staffing firm's clients.

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