Microsoft Access Icon Programming Consulting Training Integration
New Applications

Consultation

Maintenance
Pricing
Access has been around for over 25 years and so has Access Rite. There are 10s' of thousands of applications in use. Some were developed professionally, but the vast majority of these old applications had a number of 'hands' over the years. 

And many will need maintenance when a new version of Access is released or a new feature is needed. Unfortunately, the kids coming out of college now look down at Access as mobile applications and enterprise grade development is where their future lies. That's where old we come in.
We've subcontracted for large firms. Overhead led to high hourly rates (of which I received but a fraction) and most of the bids were rejected.

It's a business model that depends on image, and capabilities far beyond most clients' means and needs. Premium pricing opens the door to competition.

My business model allows turning the hands of time back to, say, the year 2000, when independent access developers were much more plentiful and development less costly.
FREE: No matter what the job, a careful review of requirements and your existing application (if any) is needed to avoid surprises when the bill comes in. I'll spend all the time needed to help you determine if we're a good fit and getting a handle on the cost.

That may mean an online meeting to review your application. Phones calls and, in many cases, sending you a link to upload your application to my secure server for detailed review.
Access Right can start with a clean sheet of paper and work with you to create the application of your dreams. Whether simple or complex, I focus on error-free applications that are easy to use.

But just because an application is simple, doesn't mean it shouldn't be done in a professional way. Professional design means any good developer in the future can take over the system and understand what was done and how it was done.

Microsoft Access Software Design & Development

Programming is Science and Art

The Science and Engineering: Software development is the process of developing software through successive phases in an orderly way. This process includes not only the actual writing of code but also the preparation of requirements and objectives, the design of what is to be coded, and confirmation that what is developed has met objectives. Thus, it is planned. Engineers use drawings and schematics, businesses use timelines, everything complicated needs a plan.

You can't properly do a home remodeling project without some sort of plan. That plan implies function, layout, etc. While a handsketch may do for many projects, a professional gives you something that works for all time and any other professional can understand. The same is true for software. It takes a bit of time to develop a good plan, but in the end it saves much more time.
The Art in Software: To you and any user, all the code that drives the machine is just the engine under the hood. You only think about it when something goes wrong. In most people's minds, the important aspects of an automobile are the features and the beauty. Likewise, good software design is much more than the code, although I see a beauty in that too.

To you and any user, the important things include how easy is it use (e.g. automatic transmissions), how logical are the controls, how comfortable is it drive. We call that the 'interface'. Like any great product, great software is built with users at the foremost of the design process since to them the interface IS the software.

Below is an Access database application we sell on our inspection software site. It's designed to run on a touch-screen tablet and sychronizes to our flagship cleaning management software.
iSpec: Inspection Software and example of expanding the limits of what Access can do
FULL NAME
EMAIL
PHONE
Submit

Contact Us Now

To discuss your requirements, budget or just chat

You won't regret reaching out to discuss your project or maintenance needs.
  

Are your needs complex?

Are your needs simple?

One of my applications contains a quarter of a million lines of code, four hundred tables, 3,600 querys and hundreds of forms and reports. And, it's bullet-proof: it simply cannot and will not crash. Perhaps 25,000 hours of development over 25 years means something. Along the way, unique code techniques and functionality was released to other developers for incorporation in their products. My point is that when it comes to Access, I can handle anything.
Your IT department is forcing an upgrade of Microsoft Office and your old application won't work under the newer version, you've been searching for a developer who you can trust to do the job. But everyone you've talked to wants something north of $180/hr. and maybe that 10-hour job becomes hard to justify. Contact me

Workmanship Warranty

Billing Policies

Satisfaction is guaranteed on fixed quote jobs. This means you won't have to deal with unexpected surprises. Work will continue beyond the hours quoted until you are satisfied at no additional charge.

Note that for upgrades from older versions of Access, changes in code techniques make fixed quoting difficult. Unexpected bugs almost always occur, so we do not offer fixed rates on this type of project.

If you opt for an hourly rate rather than a fixed quote, progress reports will be submitted at intervals of one quarter the preliminary estimate and include any foreseen adjustments to the estimate.

Billing is charged in minimum of 0.25-hour increments. Payments are required net 30 days with discounts offered for prompt payment.

SOME SUCCESSFUL PROJECTS

Access Development is my world. You name it, I've done it. Examples shown below demonstrate the depth of knowlege
Microsoft Products, Inc. (Yonkers, NY): This small manufacturing company needed a way to organize and view downloaded Google Ad Campaign Data. Starting with a downloaded CSV file, the system imports and then presents graphical views of the data having differing sets of criteria and data elements.
State of Texas, General Land Office (Austin, Texas) When IT decided to force all users to upgrade of Office 2016, they had to upgrade hundreds of databases dating back to the 90's. So had security requirements that used the old Access security model and had to be updated to a SQL-Server based control system which I designed.
Diversey, Inc. (Fort Mill, South Carolina) This global cleaning products manufacturer wanted a wizard approach to determining labor and supplies for a facility based on square feet and type of facility. Delivered in spades, people around the world are using it.

WHAT IS AN ACCESS DEVELOPER?

Note, that the old terminology is Access Programmer. Since programming refers more to the act of writing code, and Access applications require much more than just code, we now use the term Access Developer. Since search engines can't differentiate or associate those two terms easily, and since some users will still search on the either term, it's necessary to include both terms here and there in the website, just to ensure readers such as you can find us. Likewise, you probably don't want or need the technical details in this and subsequent sections. But to be frank, while you may not read it, the search engines do and one way they determine how high in search results a page or website appears is by the quantity and quality of the text on the page (or how much one is willing to pay them). We wish we could just put up a simple website, "hey, we're here and we're great " Access Developers". But, unfortunately, since other developers go to great lengths to get high rankings, we are forced to do this.

Microsoft Access is a complete, self-contained development environment. This means that it includes many types of objects developers use to put together a complete "application". These are the objects we work with:

  1. The Microsoft Access Application itself: Access has its own set of properties and a good developer knows how to change them in code. For example, there is a property called ShowFullMenus (Yes or No). If we've created a custom ribbon menu we may set this property to No, to hide the normal Access ribbons from users.

  2. Forms: To users of the application, the forms ARE the application as they comprise most of the user interface. They are what you see, the "screens" so to speak, or pages in modern terms. In a database, the primary use of forms is to show records, but developers also use them to also put controls for navigation, record selection, and many other things. One of the ways to judge a developer is simply by the visual quality (appearance) of the forms. Are the controls lined up and uniform in appearance and are the labels easily understood? It's trivial now to do this well, and any developer who doesn't is a cowboy. If not great in the little things...

  3. Tables: Tables are the heart of any database, the first building block. Tables contain fields and fields have properties to control the type of information contained in them. Relationships can be set between tables to help control data.

  4. Queries: Queries are a language used to call up information from tables. Access offers a graphical view that is convenient for users, but the SQL (structured query language) view shows what they really are.

  5. Reports:  These show data formatted for printing. They can have code to control formatting.

  6. Modules: Code modules contain developer-defined procedures and functions that can control every other object. In mature and extensive applications, hundreds of thousands of lines can exist.

  7. Macros: These are beginner-level objects that allow users to define actions similar to code modules. Experienced developers do not use them.

  8. Controls: There are all kinds of controls to do a variety of jobs. The most obvious one is a button (formally, a Command Button) to, say, close a form. But the most common control by far is one you may not think of, the Text Box which are used to display, guess what? Others include drop-down lists (called a Combo Box) and labels.

So, what does all these mean for a developer? Well all "applications" developed in the Microsoft Access Container contain many objects. The job is to combine all these different things into a working program that performs useful tasks.

A good programmer understands the use of most of these objects and can put them together reasonably well.

A great programmer has mastered every single aspect of the Access to a high level of expertise. A great programmer strives to provide an easily understood interface with great power under the hood doing the jobs a good programmer may have a user do. A great programmer is a professional who builds to a community standard that any other professional programmer could understand and extend. Just a casual scan of the objects above may make one appreciate the complexity of developing good Access Applications.