Introduction to MS-Access


MS-Access is a Relational Database Management System (RDBMS) that is used to store and manipulate large amount of information. The extension name of Ms-Access file is .mdb.


An Access Database consists of 7 different Database objects.

1. Tables : Store database data in Rows (records) and columns (fields). Every row represents a Record. Each piece of information in a record is called a Field.

Ex: A table can contain personal information about all the students in a college. Every row containing information about a student represents a record. The records in the student table can include fields such as Admission number, Student name, Address, Phone number etc.


2. Queries : used to retrieve information from a database based on specific conditions.

Ex: A Query can be used to extract details about students studying in a particular class.


3. Forms : used as interfaces for users to enter, view and modify data in a Table.


4. Reports : used to present data from tables or Queries in a format of our choice. i.e the printable form of the table or query or form. We cannot make changes to the data in a report. We can format the data in a report.


5. Pages : display shortcuts to data access pages in the database. A data access page displays data stored in a database over the internet.


6. Macros : used to automate frequently performed tasks.

Ex: we can create a macro to print a report automatically.

7. Modules : used to perform advanced database operations, such as validating data against complex conditions.






A password will be e-mailed to you.

Feedback Form

[contact-form-7 id="98" title="Feedback Form"]