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 templates)


  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.


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


  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.



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


Thank you..

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