March 10, 2010
Find Out More Information About A Short MS Access Training Inside This Blog
Microsoft Access comes with different database templates. You can use them to create some kinds of databases like contact database, expense databases, inventory control databases and many more. All of the templates can be set up in the matter of minutes and even without the MS Access training. The database you will create with one of these wizards includes tables that are comprised of different fields with name, address and other data. But it might happen that your company will need a custom made database in order to organize your data.
It might be good for you to take a short MS Access training. There you will learn how to master this complex database program. But in this article you will find out how to add tables to your database in order to personalize it.
What you will learn in MS Access training is that it is better to create separate tables for each type of data like customer information or employee information, instead of adding lots of unrelated fields to the table.
So, in order to start, open MS Access, select “New” and create a new database by clicking on “Blank Database”. Give the file a name and save it. Inside of the Microsoft Access you will see a database window. In this window, click on “New” in order to display “New Table” dialogue window. Open the wizard and look through the categories. From the sample tables list, select “customers”. Then, choose the fields you want to be included to your customer database. You do it by selecting the field name and click the button to move it to your table.
If there is a field you want to add but it is not on the list, you should bring over the field you don’t want to be in your table and then highlight it and click on “rename field” button. Leave the name of the table as “customers” and select the option to set the primary key. Click next and then select the option to enter data directly to the table. Click finish. You will see that a new table appeared with all the fields you’ve selected. You can check out the different categories. When you close the table, you will see that there is that dialogue window again you started with.
This is how you add a new custom table to your database. Even if you have worked with MS Access before, you should be surprised how easy it was to create database. You can create simple databases and tables even without special Access training. But if you want to design more complicated databases, it is better to take a short Microsoft Access database training course. After spending a couple of days in classroom, you will never be intimidated by Access anymore.
All you need about microsoft access database: great training info, all sorts of business products (customized for your needs), special microsoft access database blog with tips and advice about MA databases.
All this and more from a trustworthy UK based company which specializes in microsoft access database and is helping clients all over the world.
Nowadays we are living in the world where info makes life easier.
Due to this if you are properly armed with the info in your sphere of interest you can be sure that you will always find the way out from any bad situation. So, please make sure to track this site on a regular basis or - the least time consuming way of doing it - sign up to its RSS feed. In such an easy way you will have your hand on the pulse of the latest informational updates here. Blogging can be helpful, you just need to understand how to use them.
Tags
Related posts
Filed under Bug Fixes and Tips by softwaredude