OnlinePCTips.com

PC Tips and Tricks to make your life easier
Subscribe

Microsoft Access Database Functions.

February 25, 2010 By: lilybird Category: Software

Microsoft Access database is very functional and it comes with some pre-loaded database templates, which can be used to create many kinds of databases like contact databases, expense databases, inventory control databases and others. These templates can help you create a simple database in a matter of minutes and without any prior Microsoft Access training. Every database you create this way will include several tables, which also include various fields such as name, phone number, address, etc. But there are chances that you will have to add custom fields to your company’s tables in order to organize all the needed information properly.

If you want to have more control over this database application, you should consider taking a short Microsoft Access database training. But after reading this article you will learn how to add a couple more tables to your database and make a little more personalized.

But you might ask why not just add some fields to already existing tables. During many Access database courses you will learn that it is much better to create separate tables for every type of information instead of just adding too much of unrelated fields to one table.

So in order to start, you should open MS Access and create a new database by clicking on New and then selecting Blank Database. Give your new file a name and save it in the folder you want. You will see a database window appear in MS Access. Then, click on the New button in this database window and select New Table. The table wizard will appear. You should double click on it and take you time to look through the different table categories. You can select “customers” from the list of sample tables, for example.

Then, pick out the fields you want your customer database to include by selecting the field name and then moving it to the newly created table. If you want to add the field that is not in the field list, you should move one field over that you don’t want in your table, then highlight the field and click the appropriate button to rename the field. Leave the table name as Customers and choose the option so that you could set the primary key. When you are done click Next.

Make sure you leave the option to enter data directly into the table as a default and click Finish. You will see a new table appear with all the selected fields. You can look through the different categories and close the new table. After you close the table by clicking on the red cross in the right corner, you should see the dialogue box you have started with.

You have just created a new custom table by yourself and if this is your first time using the Access database, you might be amazed by how simple it can be done.

Need help with access database examples – this web site with microsoft access database advice and assistance can be the one that you’ve been looking for.

And some general tips – today the web technologies give you a truly unique chance to choose what you require at the best terms which are available on the market. Strange, but most of the people don’t use this chance. In real life it means that you should use all the tools of today to get the information that you need.

Search Google or other search engines. Visit social networks and have a look on the accounts that are relevant to your topic. Go to the niche forums and participate in the discussion. All this will help you to build up a true vision of this market. Thus, giving you a real chance to make a wise and nicely balanced decision.

P.S. And also sign up to the RSS feed on this blog, because we will everything possible to keep this blog tuned up to the day with new publications about microsoft access database industry.

Leave a Reply