PC Tips and Tricks to make your life easier

Typical Mistakes To Avoid When Practicing Access Database

January 28, 2010 By: lilybird Category: Software

After taking Microsoft Access courses and obtaining a lot of useful knowledge, you feel more or less confident about creating a database and have less fear about working with Access. But, when you come back to your work place, you realize that it is different from classroom and seems much harder than doing it with the help of instructor.

You should understand that Access database learning doesn’t stop after taking one class. You can take further classes and learn more theory, but nothing can compare to practice and experience. So, here are some typical mistakes to avoid when practicing your Access skills.

One of the common mistakes to avoid is creating field with the wrong type of data. At your Microsoft Access training you have learned that there are different data types, but very often the data type that seems obvious to us is not the correct one. It seems logical to enter a telephone number into a numeric field, because it consists of numbers. But, it would be wrong. Only values that could be used for calculations could be entered into numeric fields. And the telephone number should actually be in the text field.

Another common mistake is using one table for all records. A lot of Access beginners find it hard to understand the concepts of relational database. Trying to fit all the information in one table often creates wasted space and redundant data. During advanced Access training users learn that it is better to create separate tables for each type of information.

One more error, often made by beginners, is entering too much information into a field. If you need to enter information about cars, you shouldn’t put the model, year and make of the vehicle into one field. This will become a problem, when you want to run a query and find all cars made in a certain year. You should always consider wisely whether the data is better to be separated into different fields. Besides, in Access training you will learn how simple it is to link fields together.

And one more common mistake a lot of Access users make is using the default field size. We know that the text field has a length of 50 by default. You have to consider how long you need your fields to be and set them up accordingly, instead of using the default size. If you need only 10 characters for the field, assigning the default 50 characters is a waste of space. It might not seem like a lot, but if you count all of the fields, your database might start working slow because of its size. The same thing concerns the number fields.

These are some of the typical mistakes new Access users make. And now that you know about them, you should try to avoid them and make your Access database building more effective.

The sphere of computers and computer applications grows all the time. But you can turn this problem into your advantage by catching up with this knowledge and becoming a pro, for example in microsoft access database niche.

Please visit this web site that specifies in microsoft access database topic and has a nice line of microsoft access database products available.

Leave a Reply