1. Home
  2. GK Questions
  3. Computer Awareness
  4. MS-Access & MS-Outlook

MS-Access & MS-Outlook — GK Questions with Answers

10 Computer Awareness Questions20 Computer Awareness Questions50 Computer Awareness Questions100 Computer Awareness Questions Current Affairs 2026 Today's GK Quiz Static GK हिन्दी
31 questions
  1. How many primary keys can an MS-Access table have?
    1. One
    2. Two
    3. Three
    4. Four
    Show answer

    Answer: (A) One

    One primary key.

  2. Which of these is DBMS software?
    1. Access
    2. Excel
    3. Word
    4. PowerPoint
    Show answer

    Answer: (A) Access

    Access.

  3. How many kinds of relationship are there in MS-Access?
    1. 3
    2. 4
    3. 5
    4. 6
    Show answer

    Answer: (A) 3

    One-to-One, One-to-Many, Many-to-Many.

  4. Attributes can be defined for —
    1. Entity
    2. Switch board
    3. Macro
    4. Pages
    Show answer

    Answer: (A) Entity

    Entity.

  5. To hold picture data a field must be of type —
    1. OLE
    2. Hyperlink
    3. Yes/No
    4. Picture
    Show answer

    Answer: (A) OLE

    OLE object.

  6. The default size of a data type in MS-Access —
    1. 50
    2. 60
    3. 70
    4. 80
    Show answer

    Answer: (A) 50

    50.

  7. The key that invokes the spell checker in Access —
    1. F2
    2. F7
    3. Alt + F7
    4. F3
    Show answer

    Answer: (B) F7

    F7.

  8. The statement “we cannot make a query from the Insert menu” is —
    1. True
    2. False
    3. Cannot say
    4. Sometimes
    Show answer

    Answer: (B) False

    False.

  9. A template is a —
    1. Pattern of a worksheet
    2. Heading
    3. Title
    4. Theme
    Show answer

    Answer: (A) Pattern of a worksheet

    A ready pattern.

  10. The e-mail client is a feature of —
    1. MS-Word
    2. MS-Excel
    3. MS-PowerPoint
    4. MS-Access
    5. MS-Outlook
    Show answer

    Answer: (E) MS-Outlook

    MS-Outlook.

  1. The database component that stores the data —
    1. Table
    2. Query
    3. Report
    4. Form
    Show answer

    Answer: (A) Table

    Table.

  2. The interface that makes entering data into tables easy —
    1. Table
    2. Query
    3. Report
    4. Form
    Show answer

    Answer: (D) Form

    Form.

  3. The component that gets information from the data in tables —
    1. Query
    2. Report
    3. Form
    4. Macro
    Show answer

    Answer: (A) Query

    Query.

  4. To print data based on queries or tables —
    1. Table
    2. Report
    3. Form
    4. Macro
    Show answer

    Answer: (B) Report

    Report.

  5. Which query kind is used most often?
    1. Select query
    2. Parameter query
    3. Action query
    4. SQL query
    Show answer

    Answer: (A) Select query

    Select query.

  6. The query that prompts the user for values —
    1. Select
    2. Parameter
    3. Cross-tab
    4. Action
    Show answer

    Answer: (B) Parameter

    Parameter.

  7. Which query builds a new table or alters an old one —
    1. Select
    2. Parameter
    3. Cross-tab
    4. Action
    Show answer

    Answer: (D) Action

    Action.

  8. The Access template for keeping track of assets —
    1. Assets
    2. Contacts
    3. Events
    4. Faculty
    Show answer

    Answer: (A) Assets

    Assets.

  9. The maximum length of a Memo field —
    1. 255 characters
    2. 1024 characters
    3. 65535 characters
    4. 1 GB
    Show answer

    Answer: (C) 65535 characters

    65535.

  10. How much space does a Yes/No field take?
    1. 1 bit
    2. 1 byte
    3. 4 bytes
    4. 8 bytes
    Show answer

    Answer: (A) 1 bit

    1 bit.

  1. The field that identifies records uniquely —
    1. Foreign key
    2. Primary key
    3. Index
    4. Label
    Show answer

    Answer: (B) Primary key

    Primary key.

  2. The message shown when a validation rule fails —
    1. Required
    2. Validation Text
    3. Alert
    4. Hint
    Show answer

    Answer: (B) Validation Text

    Validation Text.

  3. The property that forbids a field being left blank —
    1. Validation
    2. Required
    3. Default
    4. Indexed
    Show answer

    Answer: (B) Required

    Required.

  4. The view that allows data entry and editing but not changing the structure —
    1. Design View
    2. Datasheet View
    3. Print View
    4. Layout View
    Show answer

    Answer: (B) Datasheet View

    Datasheet View.

  5. The view for creating a table and setting keys —
    1. Design View
    2. Datasheet View
    3. Print View
    4. Layout View
    Show answer

    Answer: (A) Design View

    Design View.

  6. Displaying only the records that meet a criterion —
    1. Sorting
    2. Filtering
    3. Indexing
    4. Joining
    Show answer

    Answer: (B) Filtering

    Filtering.

  7. The Access shortcut to sort in ascending order —
    1. Ctrl + Shift + A
    2. Ctrl + Shift + Z
    3. Ctrl + A
    4. Ctrl + F
    Show answer

    Answer: (A) Ctrl + Shift + A

    Ctrl + Shift + A.

  8. The shortcut that adds a new record —
    1. Ctrl + (+)
    2. Ctrl + (−)
    3. Ctrl + A
    4. Esc
    Show answer

    Answer: (A) Ctrl + (+)

    Ctrl + (+).

  9. The extension of an Access file —
    1. .accdb
    2. .xlsx
    3. .docx
    4. .pptx
    Show answer

    Answer: (A) .accdb

    .accdb.

  10. With which servers can Outlook work?
    1. Exchange and SharePoint
    2. Only FTP
    3. Only DNS
    4. None
    Show answer

    Answer: (A) Exchange and SharePoint

    Exchange and SharePoint.

  11. What kind of software is Outlook?
    1. E-mail client + personal information manager
    2. Spreadsheet
    3. Database
    4. Presentation
    Show answer

    Answer: (A) E-mail client + personal information manager

    An e-mail client.

More chapters in this subject