Skip to content
GK24
Computer AwarenessEasy

Which program of the Microsoft Office suite is a relational database management system?

  1. A.MS Excel
  2. B.MS Access
  3. C.MS Publisher
  4. D.MS OneNote

Correct answer

B. MS Access

Explanation

The correct answer is B, MS Access. Access stores data in separate tables that are joined to one another through keys, which is what makes it relational, and it provides tables, queries, forms, reports, macros and modules to work with that data. It ships with the professional editions of Office. Option A, MS Excel, is a spreadsheet; it arranges data in a single grid of rows and columns and can sort, filter and calculate, but it has no concept of a relationship between tables and is not a database management system. Option C, MS Publisher, is a desktop publishing program for brochures, cards and newsletters. Option D, MS OneNote, is a digital notebook for loose notes, clippings and sketches. Papers often set Excel against Access on purpose, so remember the dividing line: a spreadsheet keeps one table, a database keeps many tables and the links between them.

Read the full article: MS Access, Outlook and Office Tools: Exam Notes

View all