Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.0k views
in Accounting System Using Database Management System by (15.3k points)

Explain MS Access and its components.

Please log in or register to answer this question.

1 Answer

0 votes
by (15.9k points)

MS Access is one of the popularly used Database Management System (DBMS) to create, store and manage database. It is popularly called Access. Access is functionally available with the following seven object classes. Each of these object classes is capable of creating their respective object replicas.

1. Tables: This object class allows a database designer to create the data tables with their respective field names, data type, and properties.

2. Queries: The stored data is processed using the query facility to produce desired information.

3. Forms: This object class allows the designer to create an appropriate user interface to formally interact with back end database defined by the tables and queries.

4. Reports: This object class is used to create various reports. Such reports are designed in access according to the requirement of end user.

5. Pages: This object class is meant to create data access pages which can be posted on a website of an organisation using internet.

6. Macros: A macro is a list of macro-oriented actions that runs as a unit.

7. Modules: These are the foundation of any application and allow the designer to create a set of programming instructions called functions or sub-routines that can be used throughout the application.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...