How to Create a Database in MS Access

Creating a database means making a new database file where related information can be stored and managed.

For example, a computer institute can create a database to maintain student details, courses, fees, and attendance.

Before creating a database, decide the following:

• The purpose of the database.
• The information you want to store.
• The tables you may need.
• A suitable database name.
• A folder where the database will be saved.

Planning these items first helps you build a more organized database.

1. Open Microsoft Access.
2. Choose Blank Database.
3. Enter a database name.
4. Select the folder where you want to save the file.
5. Click the Create button.
6. Wait for Access to create and open the database.

A database name should clearly describe the purpose of the database.

Examples of good names:

• StudentManagement
• LibraryManagement
• SchoolDatabase
• EmployeeRecords
• InventoryManagement

Avoid confusing names such as New1, Test2, or Database123 for important projects.

Modern Microsoft Access databases commonly use the .accdb file extension.

For example, a database named StudentManagement may be saved as:

StudentManagement.accdb

Older Access database versions commonly used the .mdb extension.

The save location is the folder where Access stores the database file.

For example, you could save the file in:

Documents\AccessProjects\StudentManagement.accdb

Choose a folder that is easy to find and make sure you have permission to save files there.

Access creates the database file and opens it. A new blank database may include a default table in Datasheet View.

You can then:

• Create tables.
• Define fields and data types.
• Set primary keys.
• Enter records.
• Create queries, forms, and reports.

Suppose you want to maintain student information for a computer institute.

Database name: SooproStudents

Purpose: Store student records.

Possible fields for the Students table:

You will learn how to create and design these fields in the upcoming lessons.

Access saves many record changes automatically as you move between records or close an object. However, changes to the design of database objects may require you to save the object.

Use the Save command when needed, and check for any confirmation messages before closing Access.

• Choosing a confusing database name.
• Saving the file in an unknown location.
• Creating unnecessary tables.
• Using unclear field names.
• Not planning the database structure.
• Failing to make backup copies of important data.

Task: Create a database for Soopro Pathshala.

1. Open Microsoft Access.
2. Select Blank Database.
3. Enter the name SooproStudents.
4. Choose a suitable save location.
5. Click Create.
6. Observe the newly opened database.
7. Identify the Navigation Pane and work area.
8. Close the database after saving any required changes.

1. What does creating a database mean?
2. Which option is used to create a blank database?
3. What is the common file extension for modern Access databases?
4. Why should you choose a meaningful database name?
5. What is a save location?
6. What happens when you click Create?
7. Name three possible fields in a Students table.
8. Why should you plan a database before creating it?
9. How can you protect important database information?
10. What can you create after opening a blank database?