What is Microsoft Access?

August 3, 2013 in Microsoft Access

The fact is, most people don’t understand what Microsoft Access is. That includes most developers. This fact struck me in particular at the start of a recent project overhauling a collection of legacy Access applications. Naturally the end users were pretty murky on what Access was, they just knew they had to open Access to get to their applications. The business analyst who had been managing a lot of configuration and building queries and reports was certainly not a developer, and was not well versed in how Access applications are (or can be) architected. My colleague and lead on the
…read more

Microsoft Access Field Data Type Reference

April 30, 2013 in Microsoft Access

This page lists every possible field data type that a native Access (Access Database Engine) database can contain. It also shows which methods can be used to create fields of the given type. The information here applies to Access 2007+ (the ACE engine) but most information holds true for earlier versions as well. Contents List of Data Types Examining Data Types Creating Fields, by Data Type List of Microsoft Access Data Types Types of Types Officially, there are 13 primary data types in Microsoft Access. See SQL Data Types. There a number of subtypes, however, depending on how an individual
…read more

What Microsoft Access is Good For

February 8, 2013 in Microsoft Access

A lot of my posts here will be about how best to use Microsoft Access, from programming in VBA and Jet SQL to indexing and data application architecture. For a lot of IT professionals the question this immediately raises is “Why?”, as in “Why the heck would you ever use Access?” Searching for “Hate” and “Microsoft Access” yields plenty of results (of course “hate oracle” yields even more). From my first experience as a finance intern hacking VBA to get stuff done to later years both using and analyzing all the big boys of enterprise database development I went through
…read more