by: microsofttraining
Total views: 1
Word Count: 533

Of all the Microsoft products, Access is the one that most often requires outside training. It's not hard to understand typing text into Word or plugging numbers into Excel, but even experienced computer professionals require Access training. Often it is not enough to take an introductory course. For most users of Microsoft Access, advanced training is mandatory and even that is no substitute for experience. Here are a few tips that even many experienced users don't know. Database Design Simply sitting down and planning their applications on paper before ever touching the computer could solve most of the problems people have when designing databases. Designing a large project on they fly while sitting at the keyboard is doomed to fail. You may spend hours trying to fix problems that ten minutes of planning could have avoided. Never work on the production database. Work on a separate copy, the prototype, so that when you make a critical error (and we all do) you don't destroy all of the company's information. Only once the prototype is finished and well tested should it be put out live to other users. Some other pearls of wisdom from Microsoft Access advanced training to remember are to clearly understand all of your fields and relationships, choose naming convention for all elements and stick to them, never set up a database where users can edit fields directly, and always use forms. Code Writing Microsoft Access advanced training is where people learn to write SQL and VBA code. This gives them the ability to create powerful databases. It also gives them the ability to really mess things up. Document all code with comments. Don't document outside the application since those documents will inevitably be lost. Never write code with the idea that other developers or users will be able to come to you and ask what the code does. You may no longer be available, have moved on from a job or department, or just not have the time to explain. Look at other people's code for inspiration. You can even use the code in your application if the author's usage guidelines allow it. Before using it, understand how it works. You will learn how to code better in the future and you will avoid unpleasant surprises. Write custom error handlers so the users don't get unintelligible error message that will just confuse and frustrate them. Additionally, don't use SendKeys, Smart Codes, or GoTo. Very skilled database programmers may be able to make exceptions to this rule, but usually they just lead to bad code and future problems. The Most Important Rule of All You probably learned this in Microsoft Access advanced training. You may have learned it in introductory training and will most likely learn it again in the future. You may have even learned it the hard way when all of your data disappeared. It is the rule that even people who know better frequently violate: Keep regular backups! Back up not only the production database but any prototypes you are working on. Backup your databases often and occasionally restore the backups to ensure they are working properly.

About the Author

Author is a trainer with a Microsoft Office Training company, the UK industry leader in its sector. For more information on Microsoft Access advanced training, please visit http://www.microsofttraining.net/info-166-microsoft+access+training.html

---

View PDF | Print View

---

Rating: Not yet rated

--Choose-- 0 1 2 3 4 5

Comments

No comments posted.

Add Comment

You do not have permission to comment. If you log in, you may be able to comment.
Next Article - Tools From Advanced Excel Courses: Goal Seek and Solver
Previous Article - Advanced PowerPoint Training: A List of Do's and Don'ts

More Related Articles In This Category

1: Computer Problem Tips - Is Backing Up Your Sensitive Files a Pain in the Patoot?
2: Software Consultants to Avoid
3: Communication: An Essential Element in Customer Service
4: CGI Is Essential In Planning
5: Using Video Submitter Software To Save Time And Increase Website Traffic
6: How to Maximize Your Computer's Performance
7: What's New In The World Of Software Development
8: Removing Adware Made Simple: 3 Steps to Rid of Adware without a Trace
9: Reviews of Registry Easy, RegCure, and Registry Mechanic
10: The Role of Custom Software for a Mid-Sized Business
11: What's So Great About Recruitment Software?
12: Instantly Improve Your PC's Performance With Windows Repair Software
13: 6 Ways to Maximize Computer Performance
14: Key Features in the Best XP Registry Repair Software
15: Take Care of Your PC With A Reg Cleaner
16: How To Find The Best Registry Cleaners
17: The Right Business Process Improvement Tools Can Successfully Build Your Business
18: How to Get the Most Out of Utility Software
19: Restore Your PC To Full Functionality with Registry Repair Software
20: Ways to Repair Slow Running Computer
21: Resource Management using Microsoft Project
22: Fix Corrupt Registry the Easy Way
23: How To Completely Get Rid of Spyware Infections
24: Which Is Best: Training Dreamweaver Personnel Or Contracting for Web Design?
25: Tools From Advanced Excel Courses: Goal Seek and Solver

---

For WebMasters

Link This Article - HTML Code -

<a href="http://americanahost.com/articles/computers/software/ms-access-top-tips-takeaways-from-microsoft-access-advanced-training.html" target=_blank>MS Access Top Tips: Takeaways From Microsoft Access Advanced Training</a>

Link This Article - BBcode -

[url=http://americanahost.com/articles/computers/software/ms-access-top-tips-takeaways-from-microsoft-access-advanced-training.html]MS Access Top Tips: Takeaways From Microsoft Access Advanced Training[/url]

Copy This HTML Code To Put This Article In Your Web Site.

<h1>MS Access Top Tips: Takeaways From Microsoft Access Advanced Training</h1><br><br> <br><br> Of all the Microsoft products, Access is the one that most often requires outside training. It's not hard to understand typing text into Word or plugging numbers into Excel, but even experienced computer professionals require Access training. Often it is not enough to take an introductory course. For most users of Microsoft Access, advanced training is mandatory and even that is no substitute for experience. Here are a few tips that even many experienced users don't know. Database Design Simply sitting down and planning their applications on paper before ever touching the computer could solve most of the problems people have when designing databases. Designing a large project on they fly while sitting at the keyboard is doomed to fail. You may spend hours trying to fix problems that ten minutes of planning could have avoided. Never work on the production database. Work on a separate copy, the prototype, so that when you make a critical error (and we all do) you don't destroy all of the company's information. Only once the prototype is finished and well tested should it be put out live to other users. Some other pearls of wisdom from Microsoft Access advanced training to remember are to clearly understand all of your fields and relationships, choose naming convention for all elements and stick to them, never set up a database where users can edit fields directly, and always use forms. Code Writing Microsoft Access advanced training is where people learn to write SQL and VBA code. This gives them the ability to create powerful databases. It also gives them the ability to really mess things up. Document all code with comments. Don't document outside the application since those documents will inevitably be lost. Never write code with the idea that other developers or users will be able to come to you and ask what the code does. You may no longer be available, have moved on from a job or department, or just not have the time to explain. Look at other people's code for inspiration. You can even use the code in your application if the author's usage guidelines allow it. Before using it, understand how it works. You will learn how to code better in the future and you will avoid unpleasant surprises. Write custom error handlers so the users don't get unintelligible error message that will just confuse and frustrate them. Additionally, don't use SendKeys, Smart Codes, or GoTo. Very skilled database programmers may be able to make exceptions to this rule, but usually they just lead to bad code and future problems. The Most Important Rule of All You probably learned this in Microsoft Access advanced training. You may have learned it in introductory training and will most likely learn it again in the future. You may have even learned it the hard way when all of your data disappeared. It is the rule that even people who know better frequently violate: Keep regular backups! Back up not only the production database but any prototypes you are working on. Backup your databases often and occasionally restore the backups to ensure they are working properly.<br><br> <h3>About The Author</h3> Author is a trainer with a Microsoft Office Training company, the UK industry leader in its sector. For more information on Microsoft Access advanced training, please visit http://www.microsofttraining.net/info-166-microsoft+access+training.html<br><br> Keywords: <b>microsoft access advanced training</b> <br><br>Article Source : <a href="http://americanahost.com/articles"><b>Articles Directory</b></a></br> Article URL : <a href="http://americanahost.com/articles/computers/software/ms-access-top-tips-takeaways-from-microsoft-access-advanced-training.html" target=_blank>MS Access Top Tips: Takeaways From Microsoft Access Advanced Training</a></br> Article Category : <a href="http://americanahost.com/articles/computers/software/">Software</a></br> Article Author : <a href="http://americanahost.com/articles/profile/microsofttraining-170.html">microsofttraining</a>

---

Article URL : MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
Article Category : Software
Article Author : microsofttraining