MCQ Questions
Q.1.
To view the results of a saved query, right click the query in the Navigation Pan and then click ______ on the shortcut menu.
  • 0%
    Delete
  • 0%
    Format
  • 0%
    Open
  • 0%
    Close
Q.2.
To delete a field in the table, right-click the column heading for the field, and then right click _______ on the shortcut menu.
  • 0%
    Delete
  • 0%
    Insert Field
  • 0%
    Design view
  • 0%
    Delete Field
Q.3.
A field with the _____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
  • 0%
    Attachment
  • 0%
    Long Text
  • 0%
    Design view
  • 0%
    AutoNumber
Q.4.
One way to create a table, is to click _____ on the Ribbon and then click the Table button.
  • 0%
    Format
  • 0%
    Rename
  • 0%
    Create
  • 0%
    Delete
Q.5.
To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.
  • 0%
    Delete Field
  • 0%
    Rename
  • 0%
    Delete
  • 0%
    Create
Q.6.
To create a query using the Query Wizard, click ______ on the Ribbon and then click Query Wizard button.
  • 0%
    Rename
  • 0%
    Report
  • 0%
    Create
  • 0%
    Delete
Q.7.
______ words are words that have a special meaning to Access and cannot be used for the names of fields.
  • 0%
    Report
  • 0%
    reserved
  • 0%
    record
  • 0%
    Long Text
Q.8.
In a ______ database such as those maintained by Access, a data base consists of a collection of tables, each of which contains information on a specific subject.
  • 0%
    Relational
  • 0%
    Delete Field
  • 0%
    Insert Field
  • 0%
    Rename
Q.9.
To compact and repair a database, click _______ button in the Information gallery in the backstage view.
  • 0%
    Back Up Database
  • 0%
    Compact and Repair
  • 0%
    Click To Add
  • 0%
    Create
Q.10.
A ____ data type can store a variable amount of text or combination of text and numbers where the total number may exceed 255.
  • 0%
    AutoNumber
  • 0%
    Attachment
  • 0%
    Long Text
  • 0%
    reserved
Q.11.
To change to the design of a query, right-click the query in the Navigation Pane and then click _______ on the shortcut menu.
  • 0%
    Delete Field
  • 0%
    Long Text
  • 0%
    Design view
  • 0%
    Insert Field
Q.12.
Access is a ______________.
  • 0%
    Shutter Bar Open/Close
  • 0%
    database management system
  • 0%
    External data
  • 0%
    Compact and Repair
Q.13.
A field whose data type is ________ can store OLE object, which is an object is linked to or embedded in the table.
  • 0%
    OLE Object
  • 0%
    Hyperlink
  • 0%
    short text
  • 0%
    database management system
Q.14.
To define an additional field in Datasheet view, tap or click the ______ column heading.
  • 0%
    Delete Field
  • 0%
    Compact and Repair
  • 0%
    Click To Add
  • 0%
    Quick Access Toolbar
Q.15.
To open the Navigation Pane, tap or click the _______ button.
  • 0%
    External data
  • 0%
    Quick Access Toolbar
  • 0%
    Compact and Repair
  • 0%
    Shutter Bar Open/Close
Q.16.
To add a record to a table, click the ____ record button.
  • 0%
    New (Blank)
  • 0%
    Click To Add
  • 0%
    Design view
  • 0%
    External data
Q.17.
To import Data, click the _______ tab on the Ribbon.
  • 0%
    Shutter Bar Open/Close
  • 0%
    New (Blank)
  • 0%
    Click To Add
  • 0%
    External data
Q.18.
Database _______ refers to the arrangement of data into tables and fields .
  • 0%
    record
  • 0%
    design
  • 0%
    Report
  • 0%
    Delete
Q.19.
A field whose data type is ______ can store text that can be used as a hyperlink address.
  • 0%
    Hyperlink
  • 0%
    database management system
  • 0%
    short text
  • 0%
    OLE Object
Q.20.
To open a table in Design view, right-click the table in the Navigation Pane and then click on the ______short cut menu.
  • 0%
    Delete
  • 0%
    Insert Field
  • 0%
    Design view
  • 0%
    Delete Field
Q.21.
To back up the database that is currently open, use the _____ command on the Save As tab in the Backstage View.
  • 0%
    Quick Access Toolbar
  • 0%
    Back Up Database
  • 0%
    Compact and Repair
  • 0%
    Click To Add
Q.22.
To insert a field between existing fields, right-click the column heading for the field that will follow the new field, then click ______on the shortcut menu.
  • 0%
    Insert Field
  • 0%
    Design view
  • 0%
    Relational
  • 0%
    Delete Field
Q.23.
To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ________ on the shortcut menu.
  • 0%
    Delete
  • 0%
    Report
  • 0%
    Create
  • 0%
    Rename