Microsoft Access Kinds: What Are The Pros And Cons

As you’ll have gathered, certainly one of my roles within this area of interest covers IT software training. When teaching Microsoft Access types (usually during day 2), delegates would normally be shown the quickest method of making such kinds and which means using either the Access type templates or the constructed-in wizard tool.

This of course means most types (if not all) are ‘certain’ kinds or in different words, have an information supply file attached whether it be a table or query.

The truth is, when I train this area of MS Access, I normally categorise into 4 types of use for such an object; these are:

1. Data Entry Type – Forms which give customers an easy to use interface to add, modify and delete records.

2. Screen Enquiries (Read Only) – Types that allow customers to view as read only screens limiting functionality and filtering for sure records only.

3. Dialog Box – Types which act as a communication portal between users and the system passing information and values to interact with Access.

4. Menu Screen (Switchboard) – Kinds which enable users to navigate around the database system without ever knowing or having access to the background design.

To shortly put into perspective of the above 4 types, one can affiliate which technique could be set as ‘sure’ or ‘unbound’ for each one. The primary gadgets can be sure; the first to usually a table and the second to a query.

The third type of use (Dialog) would normally be an unbound kind as by definition this form would not require any archiving of the info values. The final merchandise can be bound to a table if this was generated by way of the Switchboard Manager instrument or unbound if generated by the ‘Modal Dialog’ template or manually built.

So what are the professionals and cons of using Microsoft Access forms?

Working with ‘Bound’ types signifies that it’s a lot simpler and quicker to create forms that are related to records from tables or queries saving on the development time.

However, every time the cursor (that is when scrolling) moves between records, you automatically trigger the save record action maintaining knowledge integrity. What when you wished to cease this from taking place and have higher control? Well, you’ll be able to’t with this type of object relationship.

The truth is, making an attempt to cancel a report isn’t at all times obvious or user-friendly as the ESC (escape) key has a two folded response; the primary to the field your cursor is active and second the whole record. Sure, you can undo report changes but this shouldn’t be relied upon.

It does present automatic relationship links between your tables offering you’re utilizing major keys and different linked fields between tables accurately without the need to manually intercede.

With fundamental types, you do see easy elements just like the navigation bar with a record number and counter, the power to seek out and search for records (using the constructed-in tools) and easily call the edit and delete actions.

Aesthetically, the final feel and appear of the form designs using the usual wizard instrument or earlier model templates are poor – even the later model templates are usually not brilliant!

Utilizing ‘Unbound’ Access programming types adjustments the dynamics of how you utilize and management records by way of a form. The apparent level is that by default the form loads with no information hooked up to it which improves the overall performance especially should you had quite a busy trying kind with many controls.

The way you create a connection to affiliate information to your kind would normally imply utilizing Access VBA code (on the subject of DAO or ADO – another time!) that enable users to manage when to edit, replace, delete and save changes to records.

Post Tagged with