If you are not used to working with databases, Microsoft Access can seem difficult and intimidating to you. You can be confused in terminology that is why it is usually the first topic you learn on your Access training courses. One of the main objects in Access is a table. Tables contain information in MS Access and each table generally represents one entity such as a place, a person, etc. Every table also contains fields that provide categories like a name, date of birth, phone number etc.

It is possible to link tables together to avoid data duplication. And it is one of the reasons why many people prefer using Access over Excel. Breaking your data for avoiding duplication is called Normalization. It is a different topic to grasp and in this article we will cover how to create a table in Access.

So, launch Access and create a blank database. Name your new database and click Create. You have created a database, but not a table to store data there. There are three ways to create a table in Access. You can use the datasheet view, the table design view or to import data from another application, where information is already stored in a tabular format.

In order to create a new table, you should select Create and then click Table. You will see a new tab with your table and an active column Add New Field. There are also table templates for you to use in Access. You will see a list of available table templates, if you go to Create and then Table Templates. You can choose one and create a table this way. This table will contain the default fields, but you will be able to add other fields as well. You can add fields and enter data into them. When you are done adding fields and data in them, don’t forget to save your table. Select Save and give the name to your table. Keep in mind that table and database are different structures, even though they are related. You can create any number of tables in your database and repeat the steps.

If you want to specify field description in your table, you would want to use Design view to create it. Field description can be seen when you move your mouse over a certain field and it is useful if your database will be used by many people. You will also be able to specify custom data formats. These features are not available when you create a table using a Datasheet view. To create a table, go to Create and select Table Design. You will see a new tab when you will be able to set up your data fields. Then you can assign properties, data type and description to every field you create.

Anything about microsoft access database: great training information, all sorts of business products (customized for your needs), special microsoft access database blog with tips and tricks about MA databases.

All this and more from a reputable UK based company which specializes in microsoft access database and is helping clients round the globe.

Right now we live in the world where information quickly enhances the quality of our life.

That is why if you are properly armed with the information in your topic you can rest assured that you will in any case find the solution to any bad situation. So, please make sure to track this web site on a regular basis or – best of all – sign up to its RSS. In such an easy way you will have your hand on the pulse of the latest informational updates here. Blogs can be helpful, you just need to understand how to use them.

Be Sociable, Share!

Tagged with: • •

Filed under: Ebay Auction Software

Like this post? Subscribe to my RSS feed and get loads more!