MS Access | Easy Tutorials

To create a database using MS Access

MS Access is a path of Microsoft Office Suite. MS Access has an .mdb extension by default. From 2007 MS Access extension is '.accdb'.

Procedure::

1. Click on the windows button.

2. Click on all programs. Then click on the Microsoft Office folder and open MS Access. (or)

You will find Access on the windows menu or you can search MS Access in the search bar provided. Open MS Access.

3. Clink on Blank database to create a new one.

4. Filename box will appear with the default name.

5. Give the name of your database and click on Create.

   
   

You can also select the storage location of your database by clicking on the file icon shown beside the File Name. By default your database is stored in C drive under documents.

6. Now I have created my database with name '20022-CM-026'

There are two ways to create a table in a database. They are

1. From Design View

2. From Datasheet View

Creating Table through Datasheet view::

1. Click on the 'Create' Tab shown above then click 'Table'.

2. System will display the default table created with the name 'Table1'.

3. You will find the default 'ID' column. To rename the column, double click on the column header and enter the new column name.

4. You can add a column by clicking on 'Click to Add'.

5. A set of data types will be displayed to you. You need to select the data type that the column needs.

6. A new column will be added with the default name 'Field1'. You can change it by double clicking on it.

7. You can add many fields or columns.

Well, Now I need to change Name of the particular column.

1. In the top select 'Fields' then click 'Name and Caption'.

2. A dialog will open.

The Easiest to create table is done using Design View.

Creating Tables using Design View

1. Click on the 'Create' Tab.

2. Then click on the 'Table Design'.

3. The below dialog box appears.

4. In this you add field name, data type and description.

How to have a Design view of my table?

1. Open your table first.

2. In the top you would be able to see the 'View'. Now click on 'View' then select 'Design View' from options.

3. Now you would be able to see the design view. Design view is very easy to create Tables.