Month March 2014

In this post we will be introducing VBA and the Access Integrated Development Environment. To really take Access to the next level, you will need to learn VBA and how it underpins a lot of what takes place in MS…

In this post we will be looking at more advanced concepts in queries. We will be examining different join types and introducing action queries. List of topics covered: Table Joins Returning Null Values Cartesian Product Action Queries Append (Insert) Delete…

In this post we will be examining Macros and how you can use them to automate your application. Macros are an important part of MS Access as they enable you to quickly and easily add functionality to your database. Read…

In this post we will be looking at how to create and manipulate reports in MS Access. Outputs are the main reason that we use databases. They enable us to view summarized data quickly and efficiently and to make critical…

In this post we will be taking a look at form controls. The way in which form controls interact with their parent forms can determine how well your data is validated and presented. Understanding form controls will help you to…

In this post we will be taking a look at forms and how you can use them in your Access applications. Forms represent the central way in which data can be added to your Access applications and in order to…

In this post we will be looking at the Access Object in detail. We will be examining everything from File Types and Terminology through to the Access Integrated Development Environment and Downloading Templates in order to help you get to…

In this post we will be examining basic queries and introducing Structured Query Language. We will also be showing you how to make your queries smarter with criteria and how to work with multi-table queries. List of topics covered: Introduction…

In this post we will be examining tables, data types and primary keys. Being able to manipulate tables is a fundamental requirement of working with Microsoft Access. We will be showing you how to work with different data types, how…

In this post we will be looking at the Data Modelling and Normalisation. We will be looking at the way data is handled by Access and the how you should be breaking your data down into tables and relating them.…