ms access er diagram

MS-access & Entity relationship diagram (ER – Diagram)

Ms-Access & Entity relationship diagram (ER – Diagram)



MS-access is one type of powerful database management system which can be used to create a database that records the data in a well-structured manner and can be retrieved easily and flexible. In other words, it has the most powerful tools, to help to make a document manly, it used to create a new database file, create forms and calculate data. It also called database management system. 

Objects in MS-Access

ms-access objects figure
  • Table
  • Field
  •  Record
  • Form
  • Report
  • Query


A table is a collection of different fields and records. Each table has a unique name and purpose. Each table is made of different rows and columns. E.g. the name of the table is “student.”


It is the most basic unit of a table. Commonly a heading of the table is known as a field. Each filed has a unique name, data type and some other characteristics.


The record is a data presented in the table. It is a collection of the full set of information about a single item. If a group of records are selected at a time, it is called a record set.


The form is a graphical representation of the table. We can add, delete, and update records in the table by using s form.


A report is an effective way to present data in printed format. We have control over the size and appearance of the report.


A query is a command that let us access data from database or queries are the questions that we ask to the database and it turns to get the reply in the form of result.

Entity relationship diagram (ER – Diagram)

The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them. At view level, the ER model considered a good option for designing database.

An entity relationship diagram consists of an entity, attributes, and relationship. So,


An entity can be a real-world object, either animate or inanimate, that can be easily identifiable. For e.g. in a school database students, teachers, classes, and courses offered can be considered as entities. May an entity is a collection of similar types of entities. An entity set may contain entities with attribute sharing similar values.


Entities presented by means of their properties called attributes. All attributes have values. For e.g. a student entity may have name, class, and age as attributes. There exists a domain or range of values that can be assigned to attributes.

Another e.g. a student’s name cannot be a numeric value. It has to be alphabetic. A student’s or people age cannot be negative, etc.


The association among entities is a relationship. For e.g. an employee works at a department, a student enrolls in a course. Here, works and enrolls called relationships.

For offline read download PDF file below

Also, read

Database system definition & objectives

Solution of financial accounting PU 2018

Symbols used in Entity Relationship Diagram (ER – Diagram)

ms access entity relationship diagram symbols
ER-Diagram Symbols
ms access entity relationship diagram symbols
ER-Diagram Symbols

Example of Entity Relationship Diagram

PU 2016 Spring Q. No. 17

What is an ER Diagram? Draw ER Diagram of your choice with at least 3 entities and 4 attributes each.

ms access er diagram

Leave a Comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: