Home » Computers » Databases

Microsoft Access Mistakes to Avoid

Oct 12, 2007
You finish Microsoft Access database training and head back to work, confident you can create powerful databases that will make your job easier. You quickly discover that the workplace is not the classroom and things aren't as easy as when the instructor did it.

Your Access database training doesn't stop after one course. Further courses introduce new techniques, but nothing substitutes for experience. To save you headaches, here are some common mistakes to avoid.

Making a field the wrong data type
Your Access database training showed you the different data types but sometimes the obvious type is not the correct one. A telephone number is made up of numbers so should be a numeric field, right? Wrong. Numeric fields are for values that might be used in calculations. A telephone number field should actually be assigned a text data type.

Using one table for all data
Many people new to Access database training have trouble embracing the concepts of a relational database. For example, an invoice contains customer information, the list of products purchased, and the invoice information such as date of purchase. New users picture an invoice in their heads and try to fit all that information into one table.

This creates redundant information and wasted space. Customer and product information are repeated for every invoice rather than just entered once.

Advanced Access database training illustrates that the correct way to accomplish this is by creating three tables: invoices, customers, and products. Each item has a unique identifier, such as InvoiceID, CustomerID, and ProductID respectively. Each item is entered only once but the invoice objects tie them all together.

Putting too much data into a field
Another error made by new users is to combine too much information into one field. For example a car mechanic might put the year, make, and model of customer cars all into one field. This becomes a problem if he wants to find all vehicles made before 1995 or all Subaru owners. Your Access database training shows how easy it is to combine fields on an invoice or report, so always ask yourself if this information might be better separated into different fields.

Using default field sizes
You may have learned in your Access database training that text fields have a default length of 50. Consider how long a field needs to be and set the field length accordingly rather than taking the default. If your customer ID is 8 characters long, then allotting 50 characters is just wasteful. It may not seem like much but over many fields in many customer records your database will become huge and slow to load.

A similar concern applies to number fields. Number fields default to long integer which, as you may have learned in your Access database training, means it holds no decimal places and holds values in the approximate range of +/- 2,000,000. If you are storing smaller numbers, an integer or even a byte value will save space. If you need to store decimal places, then a single or double is more appropriate.
About the Author
Author is a freelance copywriter. For more information on Access database training, please visit http://www.microsofttraining.net
Rating:
Please Rate:
(Average: Not rated)
Views: 900
Print Email Report Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Accounting
    • Credit
    • Currency Trading
    • Debt Consolidation
    • Insurance
    • Investing
    • Leasing
    • Loans
    • Mortgage
    • Mutual Funds
    • Personal Finance
    • Stock Market
    • Structured Settlements
    • Taxes
    • Wealth Building
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources