| |
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 Team
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.
| |
|
