Monthly Archives: March 2014

10 – Introduction To VBA

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 Access. List of topics covered: Macros and VBA The VBA Editor The Click Event The […]

09 – Advanced Queries

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 Update Make Table Other Queries Pass-Through Data Definition SQL Queries Crosstab Queries Pivot Table Pivot […]

08 – Macros

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 on to find out more… List of topics covered: Macro Designer Macro Ribbon Action List […]

07 – Reports

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 decisions based on available information. For that reason, outputs are very important and the primary […]

06 – Form Controls

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 build better, more efficient forms. List of topics covered: Form Tools Property Sheet Fields Sheet […]

05 – Forms

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 master Access, you will need to have a very good understanding of the way they […]

01 – The Access Object

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 grips with the Access Object. List of topics covered: MS Access Terminology Access File Types […]

04 – Basic Queries

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 to SQL Access Query Designer Adding and Removing Tables Choosing Tables and Queries Viewing Query […]

03 – Tables

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 to set primary keys, how indexing works and much more. List of topics covered: Creating […]

02 – Data Modelling And Normalisation

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. List of topics covered: Databases, Data Models and Normalisation Introduction to Databases Data Modelling Relationships […]

03 – Global Class Modules

One of the best things about working with MS Access is the ability to use global variables, functions and procedures. This means that we are able to call globally declared code from anywhere within the application and is very useful for being able to keep code centralised yet accessible. Oh, and by the way, we […]

02 – Multi-Data Type Arrays

In this post we will be demonstrating how using class modules can make your arrays more functional and easier to read! In the first post we explained how class modules change the way you think about programming. You are now focusing on objects rather than actions. When dealing with arrays that require multiple data types, […]

07 – Unbound Forms iv – Form Code

In this post we will be demonstrating how you can instantiate your newly create clsFilms class module from the Form. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

06 – Unbound Forms iii – CRUD

In this post we will be giving you the code you need to Create, Update and Delete records through a Class Module. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

01 – Introduction To Class Modules

What is a class module? A class module is a group of code that allows you to create objects and utililise them in your application. What? OK, a class module is a fancy way of writing code. Better. But why so fancy? Writing code with class modules has its advantages but they are not always […]

15 – Designing For SQL Server

In this post we will be giving some thought to designing an Access application with SQL Server in mind. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.