Page 89 - Viva ICSE Computer Studies 7 : E-book

• Reports: The layouts designed for viewing or printing the data of a database are called
reports. By using reports, you can view the records of a table in a well-designed layout as
per your requirement.

Microsoft Access

Microsoft Access is a part of a Microsoft Offi ce Suite. It is a Relational Database Management
System (RDBMS) and provides graphical user interface. Here, data is stored in the form of
tables and the relationship between the tables is maintained using common fi elds. It prevents
duplication of data.

Let’s learn to build a relationship among tables.

EMP_ID Name Dept EMP_ID Salary

201 Rihana Computer 201 15000
302 Priya Electronics 302 10000

401 Jiya Computer 401 12000

In both the given tables, the EMP_ID is a common fi eld, hence relationship can be built among
these two tables.

Features of Microsoft Access

Let’s take a look at the features of Microsoft Access.
• Microsoft Access allows to export data and import it from word processing fi les,
spreadsheets or database fi les directly.
• Data is broken down to the smallest usable bit. For example, a person’s name would be
broken down into four separate sections namely, title, fi rst name, middle name and last
name.

• Each record has a unique identifi er. This distinguishes a particular record from any other
record.

• It helps in reducing the duplication of a data. This application makes sure that only one
copy of the data is available.
• It also provides data security features.
• Reports are used to present information in a meaningful format.

• Queries are used to access the required information from a database.

Components of MS Access 2016

Before learning how to perform various tasks in MS Access, let’s learn about the various
components of the application.

77