CRETE TABLE IN MS ACCESS

MS ACCESS IS THE GREATE SOFTWARE TO MANAGE THE DATABASE IT HELP US IN THE MANAGMENT OF OUR DATA . WE CAN EASILY MANAGE OUR DATA THROUGH MS ACCESS SOFTWARE, SO TODAY WE LEARN THAT ,HOW WE CAN MAKE A TABLE IN MS ACCESS BY USING QUERY DESIGN OPTION IN MY SQL VIEW. STEPS TO CREATE TABLE BY USING QUERY DESIGN OPTION * OPEN THE MS ACCESS OFFICE *CLICK ON CREATE BLANK, WRITE THE NAME OF THE DATABASE AND CLICK ON CREATE *A NEW BLANK DATABASE SHEET IS CREATED *NOW,CLICK ON THE CREATE TAB OPTION *THEN CLICK ON THE QUERY DESIGN OPTION IN OTHERS GROUP * A DROPDOWN MENU WILL APPEAR, CLICK ON ADD AND THEN CLICK ON CLOSE OPTION WHICH WILL APPER IN BOTTOM OF DROP DOWN MENU * NOW CLICK ON THE VIEW MENU WHICH IS IN THE EXTREME LEFT SIDE OF THE WINDOW *A NEW DIALOGBOX WILL APPEAR ,CHOOSE THE SQL VIEW OPTION *A NEW SLIDE WILL APPEAR. NOW HERE WE CAN WRITE A STATEMENT TO CREATE OUR TABLE , BUT BEFORE WRITING WE SHOULD NOW ABOUT THE FIELD NAME AND THERE DATA TYPE . SO ,HERE IS THE IS THE LIST OF THE FIELD NAME WITH THERE DATA TYPE. FIELD NAME = DATATYPE Name = VARCHAR Rollno = INT phone = INTEGER FOR EXAMPLE .......... TABLE NAME STUDENT Create Table Student ( roll_number int not null primary key, firstname varchar(20), lastname varchar(30), DOB date(DD/MM/YY), fathername varchar(67), mothername varchar(34), class char(1), phone integer(10), address varchar(23), email varchar(56) ) NOW CLICK ON THE RUN! OPTION THE TABLE IS CREATED. THANKYOU.