Creation of Database In MS-Access

 

Creating a Database:

              Database can be created in two different ways. Those are:

·       Selecting “open blank database”

·       Selecting “database wizard”

v  Selecting “open blank database”

o   Choose File/New or Ctrl+N (or) click on new button on database tool bar

o   In new dialog box double click on blank database

o   When you see file new database dialog box type a filename.

o   Choose the folder name. By default it is stored in My documents

o   Click “create”.

o   You can see a new empty database window.

o   Click the New, you will be offered a number of choices. Select table wizard and click ok.

v  Selecting “database wizard”:

o   Select database wizard option.

o   It is a method of design databases by a step by step procedure.

o   Choose some of the readymade databases like ledger, accounts.

o   When you see file new database dialog box type a file name.

o   Choose the folder name. By default it is stored in My documents.

o   Click “create”

o   Choose columns and sample data if required for your database.

o   Choose ready-made templates for applying styles to the forms and reports.

o   Click “finish”.