Creating database and designing a simple tables in Access

🗃️ Creating a Database and Designing Simple Tables in Microsoft Access

Microsoft Access is a user-friendly Database Management System (DBMS) that allows users to create and manage databases efficiently. In this lesson, ITI students will learn how to create a new database and design simple tables in MS Access.

📥 Step-by-Step: Creating a New Database in MS Access

1. Open Microsoft Access.
2. Click on "Blank Database".
3. Enter a name for your database (e.g., StudentRecords).
4. Select the location to save the file and click Create.
5. Access opens a new database with a default table named Table1.

📋 Designing a Simple Table

A table is where data is stored in rows and columns. Each row is a record and each column is a field.

👉 Steps to Create and Design a Table:

1. In the database window, click on Table Design.
2. Enter the Field Name (e.g., StudentID, Name, Age, Course).
3. Select the Data Type for each field:
   • Short Text – for names, addresses
   • Number – for age, marks
   • Date/Time – for date of birth
4. Add a Description if needed (optional).
5. Choose a Primary Key (e.g., StudentID) by right-clicking on the field and selecting Set Primary Key.
6. Click Save and give the table a name (e.g., Students).

🧾 Example Table Design

💾 Saving and Entering Data

• After saving the table, double-click on the table name to open it in Datasheet View.
• Now, enter the data row by row.
• Each row is a new student record.

🎯 Learning Outcomes

• Understand how to create a basic database in MS Access.
• Design and structure tables with appropriate field types.
• Identify the importance of a primary key.
• Enter, manage, and view data records easily.

This foundational skill is essential for students aiming to work with data in offices, schools, or businesses using database systems like MS Access or SQL-based platforms.