in MS Access you create a new table in Three different method:
Creating a table in Design
Creating a table in Datasheet View
Creating a Table Through Table Templates
In this tutorials we discuses each above method in detail.
Create A new database or open an existing database in MS excel 2007
Click on CREATE Tab on the Access ribbon.
Select Table Design Option from Tables Group of office Ribbon.
In next appearing screen Add Field Name and Select its Data type and add the description if you want other wise leave description. For example Rno as filed name and Number as Data type.
Set The Some properties of each field form Field Properties Windows Section by clicking onGeneral tab. For example Field Size Field format, default value etc. You can also set a Primary key from one filed.
Now Save This Table by click on Save Icon form Quick Access tool Bar or Form Office Button or Press CTRl + S key form Keyboard.
Give a name to your table and Click Ok Button.
The process of Creating a new table in datasheet view is given below:
Create A new database or open an existing database in MS excel 2007
click on CREATE Tab on the Access ribbon.
Select Table from Tables Group of office Ribbon.
Datasheet view will be open .The new table opens automatically in Datasheet view. You can add your fields by double-click the first field header and enter the Name for the field. When you finish, press ENTER.
Now Save This Table by click on Save Icon form Quick Access tool Bar or Form Office Button or Press CTRl + S key form Keyboard.
Give a name to your table and Click Ok Button.
In MS Access you can also create a new table Through Table Templates. Datasheet view which provides a visual way to create a new table. A Table template are Pre design Tables in which Fields and properties are already set you just select category of table.
Create A new database or open an existing database in MS excel 2007
click on CREATE Tab on the Access ribbon.
Click Little arrow on Table Templates from Tables Group of office Ribbon.
Select The Category.
The New table is Created .
Now Save This Table by click on Save Icon form Quick Access tool Bar or Form Office Button or Press CTRl + S key form Keyboard.
Give a name to your table and Click Ok Button.
Creating Split Forms in MS Access 2007
Cross tab query in Microsoft Access
How We Set a Default Form In Access 2007
Creating a Parameter Query In MS Access 2007
How We Pass String parameter in MS Access Query
Creating a Form In design View In MS Access
Creating a Check Box in Access 2007
Create a list box or a combo box by in MS Access
Creating a New Form through Wizard In Access 2007
How To Create A Table in Access 2007
How to Create a New Database Access 2007