Don't Be Afraid Of Microsoft Access
In fact in an earlier article I have referred to the fact that people tend to use Microsoft Excel as an alternative. While this may not be a bad idea in the short term, it can lead to duplication of data and problems later on.
Here are some of the reasons why Access is such a useful package:
1) Part of Microsoft Office so easily available to business users at a reasonable price
2) Uses VBA and will combine easily with Excel and Word to create documents with ease such as mail merges
3) Eliminates data duplication
4) Helps prevents data entry errors
5) Can manage relational links between tables to ensure data is normalised
6) Can be shared amongst numerous users
7) Not overly difficult to learn
8) Can be set up by advanced users to make data entry quick and easy for less experienced users
Access can be difficult to teach yourself so it is advisable to attend training courses. If you are trying to teach yourself the basics I would recommend learning topics in the following order:
1) Designing basic tables
2) Validating fields
3) Input masks
4) Designing basic forms
5) Creating queries to ask questions of your data
6) Using the report wizard to design basic reports
7) Customising reports
Once you have mastered these topics you can then start to look at the advanced features of Access such as:
1) Relating tables together
2) Creating queries based on multiple tables
3) Customising forms
4) Customising reports
5) Creating calculated fields in queries, forms and reports
6) Adding in macros and VBA code
When you have mastered all these topics you should be able to easily design relational databases with ease.
Computer Training Solutions offers courses to address all these topics either at their training centre in Bristol or as a tailored couse at your premises anywhere in England and Wales.
Related Tags: training, microsoft, access, tables, importance, relational
Notes for editors: Claire Blinman is the training manager at Computer Training Solutions in Bristol. For more information visit our website at http://www.computertrainingsolutions.co.uk or call 01454 851770
Your Article Search Directory : Find in ArticlesRecent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul