MS Access, Outlook and Office Tools: Exam Notes
Notes on MS Access, Outlook, Publisher, OneNote, Visio and Project for computer awareness: objects, keys, mail folders, protocols and file extensions.
By GK24 Editorial Team· Published · 4 min read

Most candidates prepare only three members of the Microsoft Office family, namely Word, Excel and PowerPoint, and then lose easy marks when a paper asks about Access, Outlook, Publisher, OneNote, Visio or Project. These programs are set in the computer awareness section of SSC, Railway and banking papers precisely because they are the part of the suite that is skipped. The questions are never deep: they ask what a program is for, which file extension it writes, or what one of its objects or fields is called. The notes below cover exactly that ground.
MS Access: the database of the Office suite
MS Access is a relational database management system, so it stores data in linked tables rather than in a single sheet, and it is supplied with the professional editions of Office. A database file written by Access 2007 and later versions carries the extension .accdb, while the older format up to Access 2003 used .mdb. Its work is organised into objects. Tables hold the data in rows called records and columns called fields. Queries ask questions of the data. Forms give a friendly screen for entering and viewing one record at a time. Reports lay data out for printing. Macros and modules automate tasks, the modules being written in Visual Basic for Applications.
A field that identifies every record uniquely is the primary key; a field that points to the primary key of another table is the foreign key, and that link is what makes a relationship. Access supports one-to-one, one-to-many and many-to-many relationships, the one-to-many being the commonest. A table may hold up to 255 fields. Tables are seen in two main views: Datasheet View, which looks like a grid of rows and columns, and Design View, where field names, data types and properties are set. The data types asked most often are Short Text, Long Text, Number, Date and Time, Currency, AutoNumber, which generates a serial value by itself, Yes or No for a logical value, OLE Object for an embedded file and Hyperlink. Queries come as select queries, parameter queries, crosstab queries and action queries, the last group covering append, update, delete and make-table queries.
MS Outlook: email and a personal organiser
MS Outlook is an email client and, more than that, a personal information manager, since it combines Mail, Calendar, People or Contacts, Tasks and Notes in one window. Its local data is kept in a personal storage table with the extension .pst, while a cached copy of a server mailbox is stored in an offline file with the extension .ost, and a single saved message has the extension .msg. The standard folders are Inbox, Outbox, Sent Items, Drafts, Deleted Items and Junk Email: a message waiting to go out sits in the Outbox and moves to Sent Items once it has left.
Three address fields appear on every new message. To carries the main recipients, Cc, which stands for carbon copy, sends a visible copy to others, and Bcc, which stands for blind carbon copy, sends a copy whose address the other recipients cannot see. Outlook also holds rules, which file or forward messages automatically, signatures, which are appended to outgoing mail, and the out of office or automatic reply. On the protocol side, SMTP is the protocol that sends mail out, while POP3 and IMAP retrieve it; POP3 normally downloads and removes mail from the server, whereas IMAP keeps it on the server so that several devices see the same mailbox.
The other programs and the file extensions
Publisher is the desktop publishing program of the suite, used for brochures, cards and newsletters, and it writes files with the extension .pub. OneNote is a digital notebook for free-form notes, with the extension .one. Visio draws flowcharts, organisation charts and network diagrams and writes .vsdx. Project handles project schedules and draws the Gantt chart, writing files with the extension .mpp. Teams is the collaboration and meeting program, and OneDrive is the cloud storage that comes with a Microsoft account.
| Program | Used for | Extension |
|---|---|---|
| Access | Relational database | .accdb, earlier .mdb |
| Outlook | Email and personal organiser | .pst, .ost, .msg |
| Publisher | Desktop publishing | .pub |
| OneNote | Digital notebook | .one |
| Visio | Diagrams and flowcharts | .vsdx |
| Project | Project scheduling, Gantt charts | .mpp |
| Word, Excel, PowerPoint | Documents, spreadsheets, slides | .docx, .xlsx, .pptx |
Points that travel across the whole suite
Microsoft Office was first released in 1990. The release of Office 2007 is the dividing line that papers like to ask about: it replaced the menu and toolbar with the Ribbon, organised into tabs and groups, and it introduced the Office Open XML formats, which is why the newer extensions carry an extra x or b, as in .docx, .xlsx, .pptx and .accdb. The Quick Access Toolbar sits above or below the Ribbon and holds commands such as Save and Undo. Office Online and Microsoft 365 are the browser-based and subscription forms of the same programs, with the files kept on OneDrive. Free alternatives worth knowing by name are LibreOffice Base and MySQL against Access, and Mozilla Thunderbird against Outlook, since comparison questions do appear.
Exam Point of View
Expect one straight question from this topic in computer awareness. The usual forms are the extension of an Access database, the name of the object or key being described, the meaning of Cc against Bcc, the Outlook data file, the protocol that sends mail against the two that receive it, and matching Publisher, Visio, Project and OneNote with their purposes and extensions. The deliberate traps are .mdb offered against .accdb, Excel offered against Access, Word offered against Publisher, and POP3 offered against SMTP. The Ribbon and the Office Open XML formats date from Office 2007.
Important Facts
| MS Access | Relational database management system in the Office suite |
|---|---|
| Access file extension | .accdb from Access 2007; .mdb up to Access 2003 |
| Access objects | Tables, queries, forms, reports, macros, modules |
| Record and field | A row is a record, a column is a field |
| Primary key | Field whose value is unique in every record and never blank |
| Maximum fields in a table | 255 |
| Access views | Datasheet View for the grid, Design View for field settings |
| Action queries | Append, update, delete and make-table queries |
| MS Outlook | Email client and personal information manager |
| Outlook data files | .pst local store, .ost offline cache, .msg single message |
| Cc and Bcc | Carbon copy is visible; blind carbon copy is hidden from others |
| Mail protocols | SMTP sends; POP3 and IMAP receive, IMAP keeping mail on the server |
| MS Publisher | Desktop publishing; .pub |
| MS Visio | Flowcharts and diagrams; .vsdx |
| MS Project | Project schedules and Gantt charts; .mpp |
| Ribbon introduced in | Office 2007, along with the Office Open XML formats |
Practice MCQs on this topic
Which program of the Microsoft Office suite is a relational database management system?
- A.MS Excel
- B.MS Access
- C.MS Publisher
- D.MS OneNote
Show answer
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.
Read the full explanation →What is the file extension of a database created in MS Access 2007 and later versions?
- A..mdb
- B..accdb
- C..adb
- D..dbf
Show answer
From Access 2007 onwards, the default database format changed and files are saved with the extension.accdb, which stands for Access database and supports features such as multivalued fields and attachment data types.
Read the full explanation →In MS Access, the field that uniquely identifies each record in a table is called the ______.
- A.Foreign key
- B.Primary key
- C.Index field
- D.Lookup field
Show answer
A primary key is a field, or a combination of fields, whose value is different in every record and never left empty, so it can be used to pick out one record with certainty; an AutoNumber field is the usual choice because Access fills it in by itself.
Read the full explanation →In MS Outlook, which field is used to send a copy of a message without the other recipients seeing that address?
- A.To
- B.Cc
- C.Bcc
- D.Reply To
Show answer
Bcc stands for blind carbon copy. Everyone listed in Bcc receives the message, but their addresses are hidden from the people in the To and Cc fields and from one another, which is why it is used for circulars sent to a long list.
Read the full explanation →MS Outlook keeps its mail, calendar and contacts on the local computer in a file with which extension?
- A..pst
- B..ppt
- C..pdf
- D..pub
Show answer
The letters stand for personal storage table, and this single file holds the messages, calendar entries, contacts, tasks and notes of an Outlook account on the computer, which is why backing up the.pst file backs up the whole mailbox.
Read the full explanation →Which protocol is used to send an outgoing email message?
- A.POP3
- B.IMAP
- C.SMTP
- D.FTP
Show answer
SMTP, the Simple Mail Transfer Protocol, is the protocol that carries a message out of the sender's program and between mail servers until it reaches the recipient's mailbox.
Read the full explanation →Which Microsoft Office program is meant for desktop publishing work such as brochures, cards and newsletters?
- A.MS Visio
- B.MS Publisher
- C.MS Project
- D.MS Access
Show answer
Publisher is built around page layout rather than around text flow: the user places text boxes, images and shapes exactly where they are wanted on the page, which suits brochures, greeting cards, certificates, labels and newsletters, and its files carry the extension.pub.
Read the full explanation →Which Office program is used to prepare a project schedule and draw a Gantt chart?
- A.MS Project
- B.MS Excel
- C.MS OneNote
- D.MS Teams
Show answer
Project is the project management program of the Microsoft family. The user enters tasks with their durations and the dependencies between them, assigns people and costs, and the program draws the Gantt chart, a bar chart of time against task, and works out the critical path and the resource loading.
Read the full explanation →MS Visio is used mainly for which of the following?
- A.Editing photographs
- B.Drawing flowcharts and diagrams
- C.Recording video lectures
- D.Managing email accounts
Show answer
Visio supplies ready-made shape sets, called stencils, for flowcharts, organisation charts, network diagrams, floor plans, electrical schematics and entity relationship diagrams, and connectors that stay attached to a shape when it is moved, which is what distinguishes a diagramming program from a drawing program.
Read the full explanation →In MS Access, which object gives a user-friendly screen for entering and viewing one record at a time?
- A.Table
- B.Query
- C.Form
- D.Report
Show answer
A form is the object designed for data entry and viewing: it presents the fields of a single record in a neat layout with labels, boxes, drop-down lists and buttons, so the person entering data never has to work directly in the raw grid of a table.
Read the full explanation →Which version of Microsoft Office first replaced the traditional menus and toolbars with the Ribbon interface?
- A.Office 97
- B.Office 2003
- C.Office 2007
- D.Office 2013
Show answer
Office 2007 introduced the Ribbon, a band of tabs such as Home, Insert and Page Layout, each divided into groups of related commands, in place of the drop-down menus and floating toolbars of earlier releases.
Read the full explanation →Frequently Asked Questions
What is the difference between MS Excel and MS Access?
Excel is a spreadsheet and keeps data in one grid, where it is calculated, sorted and charted. Access is a relational database and keeps data in several tables joined by keys, with forms for entry, queries for asking questions and reports for printing. Large, structured and repeatedly updated data belongs in Access.
What are the objects of an Access database?
Tables store the data, queries select and change it, forms give a friendly screen for entry and viewing, reports lay it out for printing, and macros and modules automate tasks, modules being written in Visual Basic for Applications.
What is the difference between Cc and Bcc in an email?
Cc means carbon copy: the people listed get a copy and everyone can see their addresses. Bcc means blind carbon copy: they also get a copy, but their addresses are hidden from the other recipients, which is why Bcc is used for mail sent to a long list.
Which protocols does email use?
SMTP, the Simple Mail Transfer Protocol, carries a message out and between servers. POP3 downloads mail to one device and usually removes it from the server. IMAP keeps mail on the server so that several devices show the same mailbox with the same read and unread marks.
Which file extension belongs to which Office program?
Word writes .docx, Excel .xlsx, PowerPoint .pptx, Access .accdb, Publisher .pub, OneNote .one, Visio .vsdx and Project .mpp, while Outlook stores its data in .pst and .ost files and a single message in .msg.
When did the Ribbon appear in Microsoft Office?
In Office 2007, which replaced the drop-down menus and floating toolbars with tabs and groups of commands. The same release introduced the Office Open XML file formats, which is why the extensions of that generation carry an extra letter, as in .docx and .accdb.





