Monday, 15 June 2015

How To Create a Database Using Wizard

A database is a collection of useful information. One use many number of types of databases to store their data. But the simple and easy way to maintain a database is using Ms Access provided by Microsoft office.
Here is simple and easiest way How To Create a Database Using Wizard.

First start the excel from your programs

start-> all programs->Microsoft office->Microsoft Office Access Application. Then you will get the following window. Select new file from the file menu

 It will navigate you to the following window

As shown in the above figure, from the right side you will see new file option window. Select the Blank database then it will return to you as

 and save the database with the name you want, don't worry we can change it in feature if required.and click on create button, Then you can see the following window

From this window on the left side select table and select the option "Creating table by using wizard" then click on new option(available above). Then you can see new table window

From the options available in new table window select "Table Wizard" and click ok. Then you will see a table wizard as

Select the required sample table and it will display the sample fields for that table. By using > symbol one can select the fields required for your table as

And then click the next button, you can see the following window containing two options. one for the table name and second for the Primary key. set the primary with first option and table name as you wish.

 click on next button you will see

 Then you have three options for entering the data into the created table. Select the one what you wish. I have select the second option, then click on finish, it will create a table(database) for as

That's all now you have done.

Note:- If you like my article please share with your friends and also like us at Facebook.


Post a Comment

Note: only a member of this blog may post a comment.

Find Us On Facebook

python tutorial


C Programming


Java Tutorial


Data Structures


MS Office


Database Management