Discount Domain Names

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 materials, all sorts of business products (that can be tailored for the specifics of your business), special microsoft access database blog with hints, tips and tricks about MA databases.

All this and more from a reputable UK based company which majors at microsoft access database and is assisting clients round the globe.

Comments are closed.