OPERATING SYSTEMSOS Windows

How to create a Database using Microsoft Access


A Database is a structured store of computerized data that allows Access to retrieve and use data. Microsoft Access is a Database Management System that will enable you to create and modify data and use data to create Forms, Queries, and Reports of your Data.

How to create a Database using Access

In Access 365, there are two ways to create a new Database; these are:

  • Blank Database: If you know what fields you want in your Database, you can choose the Blank Database. This Database gives you a fresh start in creating a Database, and its appearance is an empty Database where you must make your fields by yourself.
  • Template: creating a Database using a Template takes less time to create a Database than to create a Database from scratch. In Access, there are various template designs to choose from. You can select Templates shown within the program or search for Templates Online. There is a search Online Search Engine in the template window.

In this article, we are going to discuss how to:

  1. How to create a Database using a Blank Database
  2. How to create a Database using Templates

1] How to create a Database using a Blank Database

  1. Open Microsoft Access.
  2. When open, click Blank Database.
  3. A Dialog Box will pop up.
  4. Name your file.
  5. Click Create, now you have a Database.
  6. Enter your Field names and data to create a Table, Form, Query, Report, whatever you want to design your data.

Then Save your work. In Microsoft Office 365, when you create a Database, it is saved in documents of File Explorer.

2] How to create a Database using Templates

  1. Open Microsoft Access.
  2. Click on a Template.
  3. If you want more Templates, select more Templates.
  4. It will take you to the Template Window, where you will see various Templates.
  5. You can search Online for more Templates or a unique Template by typing in the Search Engine.
  6. Select your Template.
  7. Name your file, then click Create.
  8. The Template will be downloaded, and now you have a Table with Field names already created, then add data to your Database Table.

That’s it!

Read next: How to create a Report using Microsoft Access.

Source link

Alice AUSTIN

Alice AUSTIN is studying Cisco Systems Engineering. He has passion with both hardware and software and writes articles and reviews for many IT websites.

Leave a Reply

Your email address will not be published. Required fields are marked *