Skip to content
GK24
GK NotesComputer AwarenessMS Office: Access, Outlook and Other Tools

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 · Published · 4 min read

MS Access, Outlook and Office Tools: Exam Notes — GK24 title card
MS Access, Outlook and Office Tools: Exam Notes — GK24 title card

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.

ProgramUsed forExtension
AccessRelational database.accdb, earlier .mdb
OutlookEmail and personal organiser.pst, .ost, .msg
PublisherDesktop publishing.pub
OneNoteDigital notebook.one
VisioDiagrams and flowcharts.vsdx
ProjectProject scheduling, Gantt charts.mpp
Word, Excel, PowerPointDocuments, 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 AccessRelational database management system in the Office suite
Access file extension.accdb from Access 2007; .mdb up to Access 2003
Access objectsTables, queries, forms, reports, macros, modules
Record and fieldA row is a record, a column is a field
Primary keyField whose value is unique in every record and never blank
Maximum fields in a table255
Access viewsDatasheet View for the grid, Design View for field settings
Action queriesAppend, update, delete and make-table queries
MS OutlookEmail client and personal information manager
Outlook data files.pst local store, .ost offline cache, .msg single message
Cc and BccCarbon copy is visible; blind carbon copy is hidden from others
Mail protocolsSMTP sends; POP3 and IMAP receive, IMAP keeping mail on the server
MS PublisherDesktop publishing; .pub
MS VisioFlowcharts and diagrams; .vsdx
MS ProjectProject schedules and Gantt charts; .mpp
Ribbon introduced inOffice 2007, along with the Office Open XML formats

Practice MCQs on this topic

Q7.Computer AwarenessMedium

Which Microsoft Office program is meant for desktop publishing work such as brochures, cards and newsletters?

  1. A.MS Visio
  2. B.MS Publisher
  3. C.MS Project
  4. D.MS Access
Show answer
Correct answer: B. MS Publisher

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.

Q8.Computer AwarenessMedium

Which Office program is used to prepare a project schedule and draw a Gantt chart?

  1. A.MS Project
  2. B.MS Excel
  3. C.MS OneNote
  4. D.MS Teams
Show answer
Correct answer: A. MS Project

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.

Q9.Computer AwarenessEasy

MS Visio is used mainly for which of the following?

  1. A.Editing photographs
  2. B.Drawing flowcharts and diagrams
  3. C.Recording video lectures
  4. D.Managing email accounts
Show answer
Correct answer: B. Drawing flowcharts and diagrams

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.

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.

Sources

View all