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.

0 comments :

Post a Comment

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

Machine Learning

More

Advertisement

Java Tutorial

More

UGC NET CS TUTORIAL

MFCS
COA
PL-CG
DBMS
OPERATING SYSTEM
SOFTWARE ENG
DSA
TOC-CD
ARTIFICIAL INT

C Programming

More

Python Tutorial

More

Data Structures

More

computer Organization

More
Top