How To Create a Blank Database in MS Access

CREATING BLANK DATABASE IN MS ACCESS

You can create a blank database by the following method:

Step1: open Microsoft office access. Microsoft access window will appear.

Step2: click on blank database option under new blank database.

Step 3: click on browse folder at the right side of the pane.

File new database window will appear.


Step 4: select drive, where you want to create your new database.

5: click on new folder option on the command bar.

6: To open the folder, double click on it.

Step 7: Enter the file name in file name option and click on OK.



Step 8: now, click on create button on the getting started with Microsoft office access page. As a result, anew dialog box will appear.

The window for the database will appear on the screen.


CREATING A TABLE IN MS ACCESS

When you create a database, you store your data in tables. You can create a contacts table to store a list of names, addresses, and telephone numbers, or a products table to store information about products.

To create a table, follow these steps:

1. Click on datasheet tab.



2. On the ribbon click on view group. A menu will appear, click on design view. In the design view, you can name your feeds, assign data type for each field, and format your fields.

3. A save as window will appear. Enter the name in the table name box and click on OK.Table1 will be created.



4. Place the cursor in the second box beneath fieldname.



5. Type first name and press enter key on the keyboard.



6. Like above, click in the next box beneath first name and type last name and press enter key on the keyboard.

7. You can also type other information, e.g. city, address, phone number, etc.