Database

Design

 

 

There have been many instances where, in my role as an advanced Access database programmer for clients, I have brought my skills to bear on existing projects. In all cases, this involves programming in Visual Basic as the"code-behind" in order to get the job done.

 

 

 

 

 

 

 

 

 

Microsoft Access is a great choice of database. It is widely used and is the most popular database package you can purchase in the world. There are competitors to this package but the ease of use and its wide userbase makes it a winner. Additionally, there are numerous resources on the internet for Access, including tips, training, and tutorials.

Access has VBA (Visual Basic for Applications) as its underlying programming code. However, there is much you can do without using VBA. It was designed so the beginner can make good use of it but at the same time it has enough power for the serious developer.

I have found that many people have begun projects and while quite pleased with the speed of forms creation, often get tangled up in the area of queries that are beyond one table in scope.