How Do You Create a Database?

Create a database by using one of the free templates that come with Microsoft Access or creating one from scratch. Access is a part of the company's Office application bundle. You can then edit the templates according to your needs.

The free templates by Microsoft include tables, queries, forms and reports to fulfil specific roles. Because the templates have predefined data structures, you might need to edit the template to match the type of data you want to store.

To open a template, click the New button on the top left, and select a template from the pane on the right. Once you pick a template, the application automatically assigns a name to the database. Change the name in the File Name box. Click the yellow folder icon next to the name box to indicate a directory for the database, and click OK. Click Create to begin editing to database.

Once it loads the template, Access may offer a form to help you begin entering data. Alternatively, you can enter the data manually by clicking any of the cells. If the template already contains some placeholder data, you can delete them by clicking the Delete button under Records on the Home tab.

To create an empty database, click File, and then click New. Select Blank Database, indicate a name and a directory for the database, and click Create. You can then fill the cells manually to create a database.