Database in Access – How To Create A Database with a Template

Spread the love

Database In Access is simply an organized collection of information or data for quick access. Creating one is not difficult, follow the directives revealed in this write-up.

Database in Access

Ways Of Creating a Database in Access

  • Create using a blank database.
  • Through a template from
  • You can use a template installed with Access

How To Create A Database with A Template

A template is prepared to use a database that has all forms, tables, queries, and reports that will be used for task. Also, templates are in diverse forms, there are ones you can use to manage contacts and also track issues. Therefore there’s an already defined data structure embedded in the template.

Create using a template

  • Open database
  • Tap on the “file” button
  • Select “close”
  • A new tab appears with different templates
  • Navigate and choose the kind of a template you want for this task. Note; You can download an extra template if you want.
  • A “file name” will be displayed on the box, you can change the name if the one given by Access did not suit you.
  • If you desire to save the database in another folder apart from the folder shown below the “file name” Click on the “folder” icon and search for your preferred folder, then Press on “Ok” button
  • Navigate and click on “create” tab. In most templates forms are displayed for data to be keyed in. But if there are sample data on your template, you can remove it by tapping on “record selector” widget, then go to the “home” tab, select “Records”, and press on “Delete” icon
  • To Key in information or Data, select the first cell on the form without content, then start to enter your data

How To Create A Database in Access Without A Template

When you don’t want to make a Database with a template, all you need is to build tables, forms, reports, and lots more.

Create an Empty Database

  • Move to the “file” button
  • Tap on “new” widget, then Press on “blank database” tab
  • In the “filename” bar,  Key in a file name, to use another location different from the default, tap on “Browse for a location to put your database” link, when you find your desire location, click on “Ok” tab
  • Click on “Create” button, then include your data in the “click to add”

Add A table

  • Still, on the create page, go to the “tables” group, then select “table” icon
  • Choose the first blank cell in the “tap to add” column
  • Move to the “fields” tab, select “Add & Delete” button, then choose the field you desire, you can as well Press on “More Field” in case you can’t find the one you want.
  • When you select the field you want, it will be added to datasheet
  • You can start to add information in the empty cell
  • If you want to rename a field, double-click the “column header”,  then Key in the new name
  • If you want to move a column, click on the header, then select the column and drag it to your desired location.

More Related Content


Please enter your comment!
Please enter your name here