Wednesday, 27 January 2016

How to create new table

Create New Table

When new database created, Access automatically creates a new table in datasheet view. Tables are used to manage & store all raw data. You can create multiple tables in database as you need to store different types of information.
  • To create a new table click on the Create tab, there are two buttons to create new tables (Table & Table Design). We are using Table Design option for creating new table.







  • Table button: Create a new table in datasheet view mode.





  • Table Design button: Create a new table in design view mode.





We are using design method to create new table. To create new table click on Table Design in the Tables group. Access will create new table in design view mode.















Steps to create new fields:

  • Type the name of new field in Field Name column.


  • Select the appropriate data type to include in the new field from Data Type column drop down list.













  • Type detail description of the field in Description column.









Note: Repeat all above steps to add additional fields in table.