JKPSC ARCS COMPUTER PORTION

BY MOHAMMAD SALEET BHAT

MS POWERPOINT

PowerPoint (PPT) is a powerful, easy-to-use presentation graphics software program that allows you to create professional-looking electronic slide shows.

PowerPoint presentation is divided into no. of slides.

Slide is a place holder for elements like test, audio, video, images, graphics and animations.

The extension for any PowerPoint presentation file is “ppt or .pptx”

ELEMENTS OF POWERPOINT

FEATURES OF POWERPOINT SLIDE LAYOUT Multiple options and layouts are available based on which a presentation can be created. This option is available under the “Home” section and one can select from the multiple layout options provided.

FEATURES OF POWERPOINT

Insert – Clipart, Video, Audio, etc. Under the “Insert” category, multiple options are available where one can choose what feature they want to insert in their presentation. This may include images, audio, video, header, footer, symbols, shapes, etc.

FEATURES OF POWERPOINT

Slide Design MS PowerPoint has various themes using which background colour and designs or textures can be added to a slide. This makes the presentation more colourful and attracts the attention of the people looking at it. This feature can be added using the “Design” category mentioned on the homepage of MS PowerPoint.

FEATURES OF POWERPOINT

Slide transitions and Animations During the slide show, the slides appear on the screen one after the other. In case, one wants to add some animations to the way in which a slide presents itself, they can refer to the “Slide transitions and Animations” category.

FEATURES OF POWERPOINT

Views of the slide During the slide show, the slides appear on the screen one after the other. In case, one wants to add some animations to the way in which a slide presents itself, they can refer to the “Slide transitions and Animations” category.

MS ACCESS Microsoft Access is a database management system (DBMS) that combines the relational

Microsoft Jet Database Engine with a graphical user interface and software-development tools.

A database is an organised collection of data.

Database management system is a program used to manipulate the database.

The extension for Microsoft database file is “.mdb or .accdb”

COMPONENTS OF MS ACCESS

The major components of MS Access are as follows:

Tables

Queries

Relationships

Forms

Reports

TABLES

A relational database like Access usually has several related tables. In a well-designed database, each table stores data about a particular subject, such as employees or products. A table has records (rows) and fields (columns). Fields have different types of data, such as text, numbers, dates, and hyperlinks.

PRIMARY KEY AND FOREIGN KEY

Primary key is any attribute or column in the database which uniquely identifies each record in a database. E.g. roll_no in a class, sid in a school, acc_no in a bank, reg_no in a college etc Foreign key is any attribute common in more than one tables which is used to connect these tables together so that data can be retrieved from these tables.

QUERIES

Queries: Once a table is created and the user or programmer is looking for a calculated output, then it is called queries. This may include filtering, calculating, sorting, updating, etc.

RELATIONSHIPS

As the name suggests, when more than one table is added, the relation or connection between them can be achieved. There three ways in which the connection between the tables can be determined:

One to one

One to Many

Many to Many

FORMS

A user interface for a database application can be created using forms.

REPORTS

A report consists of information that is pulled from tables or queries, as well as information that is stored with the report design, such as labels, headings, and graphics.

THANK YOU