Microsoft Access Beginners' Training: Getting to Grips with Databases
Fri 8th August 2008
In this day and age of powerful personal computers it is amazing that some small businesses still use paper filing systems or at best Excel to keep track of critical business information. If you or your organisation are struggling to manage, maintain and understand your data then Microsoft Access is offers a highly cost-effective and useful solution, in a format similar to other Office products like Word and Excel that most users are familiar with, that once mastered will improve your business's efficiency. Migrating your data to a database management system such as Access is a quick way to revolutionise the way you do business.
Microsoft Access Introduction Courses will give an introduction into database creation, manipulation and analysis. Once successfully completed, you will be able to take your newly acquired skills and knowledge and produce a database that will become a valuable tool for your business.
On the course, which can be tailored to suit your individual needs, certified Microsoft trainers will help you to discover the basic concepts and terminology associated with databases. You will be introduced to the Access graphical user interface and will soon be able to navigate through the menus with ease, create new databases, save changes to existing ones and get help from Access's inbuilt help function if needed. The next step involves learning the fundamentals of successful planning and designing of databases to meet your unique business goals and requirements.
Once comfortable with the basic operation of Access, you will progress to building your first database, discovering that the building block of any database is the table. Using the design view or table wizard you will rapidly become adept at creating tables with all the necessary date fields to form your databases framework and will soon come to appreciate the ease with which you can add, delete, modify, restrict, sort, filter and find records in the database.
To improve the presentation of your databases you will learn to create forms, data entry screens that facilitate entry and viewing of your records as well as providing security for sensitive information that you may wish not to make available to all within your business. To assist you in better understanding your data you will discover and print reports, which summarise desired data, and queries, which retrieve specific information, allowing you to easily extract key information from your database with a few clicks of the mouse. At the end of the Microsoft Access course you will be in a position to return to you business and use Access to create a flexible database that will help the performance of your business.
You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.
"Course was really great, trainer v enthusiastic and really knows his stuff.
Couple of minor comments:
1. might have been helpful for some participants if we had more time doing exercises without step by step instructions, to check that we have definitely learned how to do things. we did do some of this, but I might have preferred more
2. sometimes it wasn't really clear what the end goal of a process was, we went through following step by step instructions and didn't realise where we were going until the end...
but generally the trainer's style was great"
Unilever Global R2R Operations Manager
"My instructor was brilliant. Really personalable and knowledgable. He was great at explaining things in a simple and understandable way."
Sotheby's PA/Admin Nat Madden
"Thanks so much to the trainer! I did not expect a Powerpoint course to be so exciting. Time just flew by! I was also amazed that you found the time to advise individual course attendees instead of just galloping on. It also helps that you put everyone at ease and no one hesitated to ask questions - well done!"
Access articles
