SAHIL KUMAR DATABASE MS AbhhhhhCCESS.ppt

JDBNVSCKJNMDLKBFJJK';LGJ

1. Swami Vivekananda Utkrist College
Ghumarwin
Presented by:Presented by:
Sahil kumarSahil kumar
PERSANTION OF DATABASE PERSANTION OF DATABASE
Topic Name- MS ACCESSTopic Name- MS ACCESS
CLASS-BCA CLASS-BCA
2ND2ND
SEM SEM
ROLLNO-24BCA11ROLLNO-24BCA11
SUBJECT CODE-0205SUBJECT CODE-0205
Submitted to:Submitted to:
Prof.Amar Paul SinghProf.Amar Paul Singh
Dept Of BCA/PGDCADept Of BCA/PGDCA

2. 2
OVERVIEW
DATABASE Introduction.
Microsoft Access Introduction.
COMPONETS OF MICROSOFT Access DATABASE.
 Tables
 Forms
 Queries
 Reports

3. 3
DATABASE Introduction
What is a Database?
A database is an organized collection of data that can be easily accessed,
managed, and updated. It helps store, retrieve, and manipulate data efficiently.
Examples of Databases in Daily Life:
•Banking – Stores customer accounts, transactions, and loans.
•E-commerce – Stores product details, orders, and customer information.
•Social Media – Stores user profiles, posts, and interactions.

4. Microsoft Access Introduction.

5. COMPONENTS OF MICROSOFT
DATABASE
 A Microsoft Access database is made up
serval components or object including:
 Tables
 Forms
 Queries
 Reports

6. TABLE
- Open Microsoft Access
- Select 'Table Design' or 'Datasheet View'
- Define field names and data types
- Save the table with a unique name
Creating a Table

7. 7

8. - Go to 'External Data' tab
- Choose 'Import' from various
sources (Excel, CSV, etc.)

9. 9

10. Forms are used to customize formats for
adding, editing, deleting or displaying data.
They help in data integrity and simplify data
interaction.
Forms

11. Creating a Form Using the Form Wizard
11
• Open the 'Form Wizard' from the 'Create' tab.
• Select the fields to include.
• Choose a layout and style.
• Finish and modify as needed.

12. 12

13. Queries

14. 14
Open MS Access and go to the 'Create' tab.
Select 'Query Design' and Click on SQL
View.
• Write your query and click on run button.

15. 15

16. 16

17. Reports
A report is an object in Microsoft Access that is
used to display and print your data in an organized
manner.
A report consists of information that is pulled from
tables or queries, as well as information that is
stored.

18. 18
• Go to the 'Create' tab and select 'Report
Wizard.'
• Choose fields to display in the report.
• Adjust formatting and layout as needed.
• Save and preview the report.
Creating Reports

19. 19