Microsoft Access Types: What Are The Pros And Cons

As you may have gathered, one in all my roles within this niche covers IT software training. When teaching Microsoft Access kinds (often throughout day 2), delegates would normally be shown the quickest method of creating such types and that means using either the Access form templates or the built-in wizard tool.

This in fact means most kinds (if not all) are ‘sure’ types or in other words, have a knowledge source file attached whether or not it’s a table or query.

In truth, when I train this area of MS Access, I usually categorise into four types of use for such an object; these are:

1. Data Entry Form – Types which give customers a straightforward to use interface to add, modify and delete records.

2. Screen Enquiries (Read Only) – Forms that enable users to view as read only screens restricting functionality and filtering for sure records only.

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

4. Menu Screen (Switchboard) – Kinds which allow customers to navigate across the database system with out ever understanding or having access to the background design.

To shortly put into perspective of the above four types, one can associate which method could possibly be set as ‘bound’ or ‘unbound’ for each one. The first two items can be certain; the primary to normally a table and the second to a query.

The third type of use (Dialog) would usually be an unbound form as by definition this form would not require any archiving of the data values. The final item can be certain to a table if this was generated via the Switchboard Manager device or unbound if generated by the ‘Modal Dialog’ template or manually built.

So what are the pros and cons of utilizing microsoft access expert Access varieties?

Working with ‘Certain’ varieties means that it is much easier and quicker to create forms which can be related to records from tables or queries saving on the development time.

However, every time the cursor (that’s when scrolling) moves between records, you automatically set off the save report action sustaining data integrity. What for those who wanted to stop this from happening and have better management? Well, you can’t with this type of object relationship.

In reality, trying to cancel a file will not be at all times apparent or person-pleasant as the ESC (escape) key has a two folded response; the primary to the field your cursor is active and second the entire record. Yes, you may undo file modifications however this shouldn’t be relied upon.

It does present automated relationship links between your tables providing you’re utilizing major keys and other linked fields between tables correctly without the necessity to manually intercede.

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

Aesthetically, the final feel and appear of the form designs using the standard wizard tool or earlier model templates are poor – even the later model templates should not sensible!

Utilizing ‘Unbound’ Access forms changes the dynamics of how you use and management records by way of a form. The apparent point is that by default the form loads with no data connected to it which improves the final efficiency particularly when you had fairly a busy looking form with many controls.

How you create a connection to affiliate information to your kind would normally mean utilizing Access VBA code (with regards to DAO or ADO – another time!) that allow users to regulate when to edit, update, delete and save changes to records.

483150login-checkMicrosoft Access Types: What Are The Pros And Cons

Leave a Reply

Your email address will not be published. Required fields are marked *