MS Access Programming

Cambria is composed of high caliber IT Professionals who decided to join forces and make a difference in the highly competitive world of Information Technology. Among our specialties of long standing is Microsoft Access Programming.

Contact Nancy

MS Access Programming

Microsoft Access Programming Services at Cambria

Cambria has been providing custom access programming services since 1984 and has made Microsoft Access programming one of its specialities for the past nine years. Our Access programming team has developed hundreds of Access applications — from simple mailing lists to complex data analysis and accounting systems where the Access Basic language is used but where SQL Server replaces the Access database.

Our MS Access Programming Experts

Nancy and Romeo are Cambria's MS Access Expert Programmers.

Nancy Crewdson, who can do Access programming in her sleep, heads up our Access Team. She has 19 years of database programming experience and Access has been her tool of choice since 1994. She is supported by Mike McCullough, Romeo Acidera and Ian Talanquines who assist her and James Cerezo, who brings his expertise in Visual Basic and database connectivity to bear on Access programming problems.

Access Programming Handholding

Access programming is the right approach for many applications, but oftentimes, the non-programmer hits a "brick wall" in taking a concept past the wizards to actual implementation. Consequently, handholding for those new to Access programming is often a big part of our daily work. "Why does this query not work?" "How do I structure this report?" "How can I make my interface more intuitive to the user?" "How can I speed this up?" or even "How do I migrate Access macros to Visual Basic code?" are questions we frequently answer. Other times, we are given a broken or incomplete Access database and are asked to fix it or to add new modules or new reports.

Sample Access Programming Projects

  • "RedProTrac" is a Real Estate Development Project tracking system created for the TynanGroup, a nationwide development firm. It tracks large scale construction projects from inception including budget, contracts, change orders, purchasing and owners draw. It took many months of Access programming time and close interaction with the client to make this accounting and project management tool come alive. Microsoft Access was chosen to minimize cost and maximize the lead time for getting the program running.

  • For Pacific Media Associates, a market research company with offices in New York, Tokyo and the San Jose Area, we developed an analytical and forecasting tool with the front end in Access, and the back end in SQL Server. Most of the reports involve weighted computations exported into formatted Excel spreadsheets. This has been a major project for our Access Programming team and has evolved over many years.

  • For the Sequoia Center, a Silicon Valley alcohol and drug rehabilitation treatment center, we used Microsoft Access to create a patient billing and treatment tracking system. We strive for a paperless office respecting patient privacy and case worker efficiency. After intake, the Access database system tracks in-patient and out-patient services with specialized billing to insurance companies via UB92, using the insurance company's own terminology and authorized codes. It also handles private pay and accounts receivable accounting functions.

And Everything in Between

The Access programs described above were large projects. We are also no stranger to small ones. Typical is one for Norquist Salvage Company. This company manages donation drives for charities - the folks who call you up asking if you have any household items or clothing to leave on your curb on a designated day for pickup. The Access database maintains household address and phone numbers, call center postings, reminder post cards, and driver route sheets and payments and previous donations where households could leave their unwanted household goods.

Access Programming Alternatives

No tool is for every job, of course, and the use of Access Programming is no exception. There is a point where an Access database is too large for efficient performance and this is the point to consider an upgrade to a database like Microsoft SQL Server. Cambria can also help with this.

  • "Romeo you are so AWESOME!!!! This is going to be great when you are done…

    Thank you, I’m certain Jeff can work with what you have working thus far!"

    Shelia McBride,
    Gradecheck, Detroit, MI

  • "Thank you Nancy! The upgraded database will only enhance our abilities to do more!"

  • Karen Zinn, Razak Company, Philadelphia, PA

  • "A person usually doesn't hear when they did something right, only when something was done wrong, so "Wow Nancy, we have a great program!!"

    It was an amazing feeling to see the interest in another insurance agents face when we showed him meimo this morning. We should be able to eliminate STACKS of paper from this agency.

    Meimo would not be near the quality that it is if we had different programmers. Thank you again for a great program!!"

    Joe Frain, Frain Insurance Agency, Chesterton, IN

  • Read More Testimonials