220711130045_PRIYA_DAS_M.S___Access__ppt

M.S_Access

1. Guided By Dr. Aniket Sutradhar Department Of B.Ed Kalna College, Burdwan University Submitted By Name : Priya Das Semester- IV University Roll No -220711130045 SESSION-2022-2024 KALNA COLLEGE B. Ed Section Affiliated To The University Of Burdwan COURSE: EPC 3 (Assessment of the Learning Process) SEMESTER-IV Topic: MS Access

2. MICROSOFT ACCESS Microsoft Access is a  database management system  (DBMS) from  Microsoft  that combines the  relational   Access Database Engine  (ACE) with a  graphical user interface  and software development tools. Microsoft Access stores data in its own format based on the Access Database Engine (formerly Jet Database Engine). It can also import or link directly to  data  stored in other applications and databases.

3. HISTORY of MS ACCESS

4. FEATURES OF MICROSOFT ACCESS

5. KEY BENEFITS MICROSOFT ACCESS

6. BACKSTAGE VIEW The Microsoft Access Backstage view is what you see when you start the Access software but don’t open a database. With Microsoft Access Backstage view, users can perform numerous database management tasks, including opening an existing database and creating a new one.

7. DATABASE

8. RELATIONSHIPS By establishing relationships, you can create a connection between two different tables. A relationship involves fields of two tables containing corresponding data. For example, the Student ID field of the Student Data table can be connected with a field of the same name in the Student Results table. Relationships help prevent missing data and quickly determine the results of a query.

9. PRIMARY KEYS

10. TABLES

11. QUERIES

12. FORMS

13. REPORTS Reports offer a way to view, format, and summarise your Microsoft Access database information. You can use Access reports to format, compile and present data. Generally, it contains answers to a specific question. Run a report at any time to get the updated database information. You can create reports for your Access desktop database by following the steps below: Step 1: Choose a record source Step 2: Choose a report tool Step 3: Create the report

14. THANK YOU