[go: up one dir, main page]
Scribd
Upload
79 views2 pages

MS-Access 2019 Basics & Table Management

MS-Access 2019 is a Database Management System designed to efficiently store and manage data through tables, records, and fields. Users can create, modify, and delete tables and records, with the Primary Key serving as a unique identifier for each record. The document outlines steps for creating a table, adding records, and modifying data within MS-Access 2019.

Uploaded by

anupriyasoundararaj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
79 views2 pages

MS-Access 2019 Basics & Table Management

MS-Access 2019 is a Database Management System designed to efficiently store and manage data through tables, records, and fields. Users can create, modify, and delete tables and records, with the Primary Key serving as a unique identifier for each record. The document outlines steps for creating a table, adding records, and modifying data within MS-Access 2019.

Uploaded by

anupriyasoundararaj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

9.

Introduction to MS-Access 2019


WALT:

• Understand what MS-Access 2019 is and its purpose.


• Learn about databases, tables, records, and fields.
• Explore the MS-Access interface.
Keywords:
1. Database – A collection of related data.
2. Table – A collection of rows (records) and columns (fields).
3. Record – A single row of data in a table.
4. Field – A column in a table that stores specific data.
5. Primary Key – A unique identifier for each record.
Introduction to MS-Access 2019:

→ MS-Access 2019 is a Database Management System (DBMS) used to store and manage data efficiently.
→ A database consists of one or more tables.
→ Each table contains records (rows) and fields (columns).
→ The Primary Key is a unique field that identifies each record in a table.
Example:

StudentID Name Age Grade


101 Anand 13 7
102 Rohan 13 7
103 Sara 12 7

Tables in MS-Access 2019 (Adding, Modifying, and Deleting)


WALT:

• Create a new table in MS-Access 2019.


• Add, modify, and delete records in a table.
Keywords:
1. Data Type – The type of data stored in a field (e.g., text, number, date).
2. Design View – A view to define and modify the table structure.
3. Datasheet View – A view to enter, edit, and delete records.
Creating a Table in MS-Access 2019:
Steps to create a table:
1. Open MS-Access 2019 and create a new database.
2. Click on Table Design to define fields.
3. Set the Primary Key for a unique record identifier.
4. Save the table with a meaningful name (e.g., "Students").
Adding Records to a Table:
1. Open the table in Datasheet View.
2. Click on the first empty row and enter data.
3. Press Tab or Enter to move to the next field.
Modifying Records in a Table:
1. Open the table in Datasheet View.
2. Click on the field that needs to be updated.
3. Edit the value and press Enter to save changes.
Deleting Records from a Table:
1. Select the row by clicking the left margin.
2. Press Delete or right-click and choose Delete Record.
Example:
Adding a new student to the "Students" table:

StudentID Name Age Grade


104 Anas 13 7

Tasks:
Task 1:
Open MS-Access and create a new database.
Create a simple table with fields: StudentID, Name, Age, Grade.
Task 2:
Enter 5 records in the table.
Modify the age of one student.
Delete one student’s record.
Task 3:
Add a new field Phone Number to the table.
Change the data type of the Age field to Number.
Set StudentID as the Primary Key.

You might also like