Gaining a skill in any Microsoft product is always worth its weight in gold. In terms of job prospects you cannot go wrong. If you want to understand how to record and manipulate information it is a good idea to learn MS Access.

How can this program help you? Most companies need a way of storing and retrieving information. Paper based systems have been replaced by technology, specifically spreadsheets and databases. MS Access is Microsoft's best selling desktop database system. When it first appeared it shook up the whole database market and many established brands found they suddenly could not compete.

MS Access is an ideal tool for developing systems used by a small number of users. It comes as part of the MS Office suite of programs. In this package you have the core components of Word, Excel, PowerPoint, Access and Outlook. For many beginners Access proves the most challenging package to learn. This is probably because there is a lot more to it than the other MS Office applications. Having said that, there are different stages to the learning process. It is possible to create simple working systems by using the in built wizards to guide you through database creation. For anything more substantial though it is better to learn MS Access from a reputable source.

There are many components to consider when you learn MS Access. For one, you will be taught some relational database theory. In simple terms this is how data relates to other data. For example you will have a relationship between a student and courses or a quotation and a client. This first step is the most important feature to learn as everything that follows on will build on this foundation.

You will be eager to get onto screen interface design, but before you can do this you have to create storage areas for the data. You will learn how to create what are known as tables to hold the data. The number of tables you have will depend on the type of data you are intending to hold. Screens will be built around the tables. There are good and bad ways to design screens, but this comes with practice. You may look back in later years to your early screen designs and laugh.

You will also want to ask questions and get answers from your database. In a sales system you may want to know how many widgets were sold last month in the south eastern region of the country. The way to do this is to create a query. Queries are great for giving you an instant snapshot of your data. From this you can spot trends and do forecasting.

Presenting data in a neat readable format is a common requirement. The way to do this is to create a report which can be sent to the printer. Designing a report is akin to designing a screen form. It's easy to create quick simple reports in MS Access, but you can go beyond this and look to creating something more dynamic. Imagine being able to output that report into MS Excel or Word. This is possible and is a great feature to have experience of.

As more and more companies switch from paper to computer based systems, it is important to keep up to date with your skills. If you can learn MS Access you will position yourself well in the job market, both at home and worldwide.