Why Access

Microsoft Access provides two main functions. Firstly it is a database container, capable of storing your data. Secondly it is an application development tool which enables you to create forms and reports that make use of your data by presenting it to the user. In fact Access is considered a Rapid Application Development (RAD) tool. It’s… Read More »

Containers, Collections and Objects

An Access Database is a container. Within this container are collections of objects which include tables, queries, forms and reports. Objects can themselves be containers. For example a table contains columns (or fields) while forms and reports contain controls that display data. So we could iterate through our database’s Tables (TableDefs) and through each Table’s Fields like this… Read More »

Naming Conventions

When Naming Objects, The first purpose of Naming Conventions is to ensure that the names of objects are unique. Access may allow you to give the same name as a table to a form or report (but not a query) but that doesn’t mean you should. At some point you may need to rename an object… Read More »

The Software Development Life Cycle

The Software Development Life Cycle outlines the process for successful software development. The concepts of SDLC are part of Project Management, regardless of what PM strategy you use. This cycle may be a day or a year but in its most simplified form The Cycle looks like – Specify > Develop > Test and Document >… Read More »