Microsoft Access Types: What Are The Pros And Cons

As you may have gathered, one of my roles within this area of interest covers IT software training. When teaching Microsoft Access types (often during day 2), delegates would normally be shown the quickest method of creating such kinds and that means utilizing both the access database consultant kind templates or the built-in wizard tool.

This after all means most forms (if not all) are ‘bound’ forms or in different words, have a knowledge supply file connected whether or not it’s a table or query.

In fact, after I train this space of MS Access, I usually categorise into 4 types of use for such an object; these are:

1. Data Entry Form – Types which give users a simple to make use of interface to add, modify and delete records.

2. Screen Enquiries (Read Only) – Forms that allow users to view as read only screens restricting performance and filtering for certain records only.

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

4. Menu Screen (Switchboard) – Varieties which permit customers to navigate around the database system without ever knowing or having access to the background design.

To rapidly put into perspective of the above four types, one can affiliate which technique might be set as ‘sure’ or ‘unbound’ for each one. The primary gadgets would 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 kind would not require any archiving of the info values. The final item would be bound to a table if this was generated through the Switchboard Manager tool or unbound if generated by the ‘Modal Dialog’ template or manually built.

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

Working with ‘Bound’ kinds signifies that it is a lot simpler and faster to create types which might be related to records from tables or queries saving on the development time.

However, each time the cursor (that is when scrolling) moves between records, you automatically set off the save document action maintaining knowledge integrity. What should you wanted to cease this from happening and have better management? Well, you may’t with this type of object relationship.

Actually, trying to cancel a document will not be all the time obvious or consumer-pleasant as the ESC (escape) key has a two folded response; the primary to the sphere your cursor is active and second your entire record. Yes, you can undo file modifications however this shouldn’t be relied upon.

It does provide automated relationship links between your tables providing you might be utilizing major keys and other linked fields between tables accurately with out the necessity to manually intercede.

With basic forms, you do see simple components like the navigation bar with a report number and counter, the ability to seek out and seek for records (using the constructed-in tools) and simply call the edit and delete actions.

Aesthetically, the final look and feel of the shape designs using the standard wizard tool or earlier version templates are poor – even the later version templates aren’t good!

Utilizing ‘Unbound’ Access kinds changes the dynamics of how you utilize and management records through a form. The apparent level is that by default the form loads with no information hooked up to it which improves the final efficiency particularly in case you had fairly a busy trying form with many controls.

How you create a connection to associate information to your form would normally imply utilizing Access VBA code (close to DAO or ADO – another time!) that allow users to regulate when to edit, replace, delete and save adjustments to records.

Post Tagged with