SIGN UP MEMBER LOGIN:
   
ARTICLE

How to create Database using Templates in Access 2010

Posted by Rupila Panday Articles | Microsoft Access June 20, 2011
Microsoft Access 2010 is the world-class relational database management system (RDBMS) for the Microsoft Windows platform and here you will learn how to create a new database using a template in Access 2010.
Reader Level:

Microsoft Access 2010 is the world-class relational database management system (RDBMS) for the Microsoft Windows platform, it is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as yourdata grows, designed for building small- to medium-scale database applications. It empowering you to make the most of your information- even if you're not a database expert. 

It offer plenty of templates that allow users to create databases, tables, queries, forms and reports with a simple one click action and you track inventory, customer information and data trends with ready-to-use templates. There are many standardized templates which can be used in creating commonly used documents.

The cool thing about this are:

  • It will Integrate your Access reports using multiple data connections.
  • Having professional designs using Office themes and faster and easier than ever before with more pre-built database templates.
  • Use the simplified Expression Builder.

Here I will share an example to create a new database using a template, the steps are:

  1. Select New tab from the left panel of Access 2010 and choose a Template from the available templates.( you can also choose templates from the Office.com templates)

    Untitled-1.gif

  2. After choosing the template (as I choose blank database) on the right panel of access 2010 you will see the create button click on button.

    Untitled-2.gif

  3. Now the new database will be opened in the Access client window.

    Untitled-3.gif

  4. By default you have 1 table named Table1, you can change the name of table by Right click on Table1 and choose design view, a pop-up will open contain the name of table you can change it give the name click ok to save the table.

    Untitled-4.gif

    Untitled-5.gif

  5. Now you Database is ready to use having one table named StudentRecord.

    Untitled-6.gif

Thank you..

Login to add your contents and source code to this article
This Feature is Sponsored By
post comment
COMMENT USING