Office 2007 Microsoft Access.

The main advantage of building something in Access is the pure speed of development, the main disadvantage is that Access is sold by Microsoft as part of their Office 2007 package, so you have to pay for it! At Visual Basic UK we use Access as a development tool. The VBA (Visual Basic Applications) code can easily be converted into .NET code.

It is surprising the number of operations using Access to perform large roles in their process. It is very reliable and can readily be backed-up. If you are one of these operations and would like some help with your VBA (Visual Basic Applications) code, please ask Visual Basic UK.

Upgrade your Application.

Is it time to upgrade your application? The advantage of moving to .NET is that an executable (.exe) file is created, the user does not need Access to run it. This can be useful when your operation is growing. Remember that at Visual Basic UK we sell you the executable file and the files that are used to make up the executable file - you get the complete issue.

Relational JET.

Access uses a RDBS (Relational Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle or any ODBC-compliant data container. Skilled software developers and data architects use it to develop application software.

VBA and Query Builder.

Access allows relatively quick development because of very good GUI design tools and high level integration of design and data objects. All database tables, queries, forms and reports are stored in the .mdb or .accdb database.