‘Organising the data in a software so that the information is relative to…

Concept: software packages differ by the data model they impose, and retrieval differs by how a match is specified. A word processor or a presentation program keeps content as a formatted document or as slides, while a database management system keeps data as tables of records and fields that are linked to one another through key fields. Retrieval likewise has two levels: a plain text search matches a literal string inside the item that is currently open, whereas a query is a saved instruction that states conditions, joins and sort order and is evaluated by the database engine over the linked tables to return a filtered set of records.

Application: the statement in the question asks for two things at once — data organised so that the information is relative to multiple files, and a search method that filters that data. The first requirement is the relational-database role, which in Microsoft Office is filled by Access: tables are stored as separate objects and joined on key fields so a single request can reach data held in more than one of them. The second requirement is condition-based retrieval, which is the query object: criteria such as Marks > 60 or Department = 'Sales' are written once, saved, and re-run to return only the matching records.

Contrast — what each named item actually does:

• Access — the relational database program: stores tables of records, defines primary and foreign keys, and links tables so data spread across them can be read together.

• Query — a saved, condition-based request evaluated by the database engine; it returns a record set filtered by the stated criteria.

• Word — the word processor: stores a document as formatted text, paragraphs and styles.

• PowerPoint — the presentation program: stores content as slides holding text boxes, images and animations.

• Find — a literal text search: it matches a string inside the item currently open and moves to each occurrence in turn.

• Selection — a highlighting action: it marks an object or a block of text already on screen so that a following command such as copy or format applies to it.

Result: the pair that supplies both the multi-file organisation and the condition-based filtering is Access with Query.