Article by KatieGatto: Design Your Own Basic Access Queries

Article by KatieGatto: Storing and Backing Up Your Access Database

Question by Amiz1122: Online Databases

Article by KatieGatto: Linking Two Tables in Seperate Databases

When you create a brand new Access Database, there is a lot more going on than you might think. To get the results that you need from your program, you have to give some careful consideration to the design of the database. Things that, at the beginning, seem simple can be very important decisions. Two common examples of this are the name and address fields. For name, you have 2 basic choices. You can put the whole name in one field or you can break down the name into two separate fields: first name and surname. When it comes to the address field however, you have more variables in play. You can do anything from placing the address in 1 field to breaking it down to the smallest elements: street number, street name, apartment number, city, zip code and state. What you choose will be based on your needs and how the organization will use the information. If you will be sending out sales flyers by where your clients live, then sorting by state or zip may be a realistic need.

So, you’ve spent all of this time and energy creating the perfect database. Don’t risk losing everything to a nasty virus or unexpected technology breakdown. We’ll show you how to safely and securely store and back up your information to prevent data loss.

If your supervisor has ever asked you to conduct research to answer a question about a particular topic, even something as simple as what will the weather be like in another city next week, you understand how important it is to know how to conduct research. Here is the first of a two-part article that will provide you some tips on how to track down research data.

In this second part of our two-part series, you will now find out how to take the data that you’ve gathered, analyze it and come up with an answer to the question(s) you asked at the beginning of your search. Here are some helpful tips on how to analyze research data.