Access (or Microsoft Access) was a database manager which was eventually integrated into the Office Suite. As far as database tools go, this is a very good proprietary database. It included a query designer, a database designer, a report design, a macro language, and a programming language (visual basic). And this was the earliest versions.
I think this was a product that Microsoft purchased and started marketing as it’s own. It was good, and as Office evolved so did Access. But not so much. That’s Ok tho as it was always a capable product.
It’s big restriction was that it had a database size restriction of 2 gb. Not a problem in the early days, but could be considered a problem these days.
I used it two write a fairly comprehensive education database that catered to schools ranging from K-12 and to Non-Credit based colleges. There had lots of forms and tables, it was multiuser capable.
Topics
- [[AccessVersions]] - Access has been around since the early days of Windows. It has changed quite a bit.
- [[ConnectionStrings]] - Using access to connect to database servers
Samples
- [[AddRecord]]