Microsoft Access consultancy and software development

Microsoft Access allows you to create systems for a small number of users, which can then be easily migrated to SQL Server as a company grows.  Here's an example of a simple Access system:

Simple Access form

This is the sort of thing Access does well: simple forms and reports.

In order to learn to use Access effectively, you're going to need to be able to design databases:

An Access relational database design

A simple Access database - usually they have many more tables than this!

You're also going to have to learn how to link forms and reports using VBA:

Sub ProgrammingQuestion()

Dim Answer As Integer

'ask if you should learn VBA

Answer = MsgBox( _

prompt:="Do I need to learn VBA?", _

Buttons:=vbYesNo + vbDefaultButton1 + vbQuestion, _


'if person said yes ...

If Answer = vbYes Then

MsgBox "The right decision"


MsgBox "You have chosen ... not wisely"

End If

End Sub

There is a Mickey Mouse programming language in Access called (confusingly) macros, but VBA modules give you much more power.

Why are we telling you all this?  Well, virtually everyone who starts using Access underestimates how long it will take them to become proficient (particularly as Access has many foibles).  We reckon it took us 5 years to become totally fluent in creating Access databases, and you might like to spare yourself pain and call us in to help you.

This page has 0 threads Add post