Access

From TSG Library of Knowledge

Contents 1 Introduction to Microsoft Access 2 Forms 3 Queries and SQL 4 Macros 5 Modules 6 Class modules 6.1 The basics 6.2 Using a class module with a Form 6.3 Recordsets 6.4 Querying the Database 6.5 Error Handling

Introduction to Microsoft Access

Microsoft Access is the Database package offered by Microsoft on their Office Suite. It's default file extension for a database is .mdb, however on the 2007 version of Access that file extension changed to .accdb.

Forms

Forms - Naming Conventions

Queries and SQL

Macros

Modules

Class modules

The basics

Class modules allow Ms Access to be controlled programmatically, incorporating the OOP paradigm.

Classes are a way of defining an Object, which can then be used within Access, this object can then be referred to anywhere within Access. You can think of a class as a blueprint.

The point is to reduce the code, and reduce errors, by allowing the reuse of code, and to Encapsulate the code, so that you need only know what values to put into and then collect the results. For example (Encapsulation), I know that if I press a channel button on my TV it'll change to the correct channel, I don't need to tell it how to find that channel each time, and the result I get is the correct channel to the screen.

Using a class module with a Form

Recordsets

Querying the Database

Error Handling