(CLASS X)
DATABASE BASICS
| S.NO. | TOPIC NAME | DOWNLOAD |
|---|---|---|
| 1. | INTRODUCTION TO DATABASE | DOWNLOAD |
| 2. | MSACCESS(FORM-QUERIES) | DOWNLOAD |
| 3. | SQL FUNDAMENTAL | DOWNLOAD |
UNIT 3: DATABASE MANAGEMENT SYSTEM
[SESSION:- 2020-2021]
| S.NO. | TOPIC NAME | SUB-TOPICS | DOWNLOAD |
|---|---|---|---|
| 1. | Appreciate the concept of Database Management System | Data and information Concept of database Advantages of database Features of database Relational database field, record, table, database Database Keys RDBMS | DOWNLOAD |
| 2. | Create and edit tables using wizard and SQL commands | Introduction to a RDBMS Database objects – tables, queries, forms, and reports Terms in database – table, field, record, Steps to create a table using table wizard, Data types in Base Option to set primary key Table Data View dialog box DDL Commands | DOWNLOAD |
| 3. | Perform operations on table | Inserting data in the table Editing records in the table Deleting records from the table Sorting data in the table, Referential integrity Creating and editing relationships – one to one, one to many, many to many Field properties | DOWNLOAD |
| 4. | Retrieve data using query | Database query, Defining query, Query creation using wizard, Creation of query using design view, Editing a query, Applying criteria in query – single field, multiple fields, using wildcard, Performing calculations, Grouping of data, Structured Query Language (SQL). | DOWNLOAD |
| 5. | Create Forms and Reports using wizard | Forms in Base Creating form using wizard Steps to create form using Form Wizard Options to enter or remove data from forms Modifying form Changing label, background Searching record using Form Inserting and deleting record using Form View Concept of Report in Base Creating Report using wizard Steps to create Report using Wizard. | DOWNLOAD |
