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.
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.
0 comments :
Post a Comment
Note: only a member of this blog may post a comment.