MCQ Questions
Q.1.
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
  • 0%
    Rename Field
  • 0%
    Long Text
  • 0%
    Design View
  • 0%
    Criteria
Q.2.
To import data to a table, tap or click the ____ tab on the ribbon.
  • 0%
    Back Up Database
  • 0%
    EXTERNAL DATA
  • 0%
    Shutter Bar Open/Close
  • 0%
    Compact & Repair
Q.3.
To open the Navigation Pane, tap or click the ____ Button.
  • 0%
    EXTERNAL DATA
  • 0%
    Back Up Database
  • 0%
    Shutter Bar Open/Close
  • 0%
    Square Brackets []
Q.4.
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
  • 0%
    Back Up Database
  • 0%
    row selector
  • 0%
    Compact & Repair
  • 0%
    Report
Q.5.
In the accompanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.
  • 0%
    row selector
  • 0%
    primary key
  • 0%
    Join Properties
  • 0%
    Show Table
Q.6.
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
  • 0%
    Insert Field
  • 0%
    primary key
  • 0%
    Rename
  • 0%
    Design View
Q.7.
Access is a ____.
  • 0%
    EXTERNAL DATA
  • 0%
    Shutter Bar Open/Close
  • 0%
    database management system
  • 0%
    Square Brackets []
Q.8.
In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.
  • 0%
    Show Table
  • 0%
    primary key
  • 0%
    relational
  • 0%
    row selector
Q.9.
A(n) ____ contains information about a given person, product, or event.
  • 0%
    DELETE
  • 0%
    Rename
  • 0%
    record
  • 0%
    Report
Q.10.
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.
  • 0%
    primary key
  • 0%
    Delete
  • 0%
    Design View
  • 0%
    Insert Field
Q.11.
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency
  • 0%
    Create
  • 0%
    MAX
  • 0%
    Format
  • 0%
    Open
Q.12.
A field whose data type is ____ can contain any characters.
  • 0%
    OLE object
  • 0%
    Design view
  • 0%
    Short Text
  • 0%
    > 1000
Q.13.
To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.
  • 0%
    Design View
  • 0%
    Rename Field
  • 0%
    Insert Field
  • 0%
    Rob?n
Q.14.
In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.
  • 0%
    Criteria
  • 0%
    row selector
  • 0%
    primary key
  • 0%
    Join Properties
Q.15.
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
  • 0%
    > 1000
  • 0%
    Create
  • 0%
    $0.00
  • 0%
    Design view
Q.16.
To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.
  • 0%
    Options
  • 0%
    Rename
  • 0%
    relational
  • 0%
    Design View
Q.17.
To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.
  • 0%
    DELETE
  • 0%
    Report
  • 0%
    record
  • 0%
    Create
Q.18.
To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.
  • 0%
    MAX
  • 0%
    Run.
  • 0%
    Format
  • 0%
    Undo
Q.19.
When you create a table in Datasheet view, automatically adds a field called ___ as the first field in the table.
  • 0%
    ID
  • 0%
    MAX
  • 0%
    Yes
  • 0%
    Undo
Q.20.
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
  • 0%
    MAX
  • 0%
    Run.
  • 0%
    Format
  • 0%
    Undo
Q.21.
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table
  • 0%
    Attachment
  • 0%
    OLE object
  • 0%
    AutoNumber
  • 0%
    Design view
Q.22.
To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu
  • 0%
    Query Design
  • 0%
    Delete
  • 0%
    Insert Field
  • 0%
    Design View
Q.23.
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
  • 0%
    MAX
  • 0%
    DELETE
  • 0%
    Close
  • 0%
    Yes
Q.24.
A field whose data type is ____ can store text that can be used as a hyperlink address.
  • 0%
    Hyperlink
  • 0%
    Attachment
  • 0%
    OLE object
  • 0%
    database management system
Q.25.
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%
    EXTERNAL DATA
  • 0%
    Square Brackets []
  • 0%
    Back Up Database
Q.26.
To delete 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%
    Rename
  • 0%
    Create
  • 0%
    Report
Q.27.
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
  • 0%
    Format
  • 0%
    MAX
  • 0%
    Report
  • 0%
    Create
Q.28.
In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
  • 0%
    relational
  • 0%
    primary key
  • 0%
    Show Table
  • 0%
    Long Text
Q.29.
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
  • 0%
    Format
  • 0%
    Yes
  • 0%
    Undo
  • 0%
    Run.
Q.30.
In the accompanying figure, the small box or bar to the left of each field is called the ____.
  • 0%
    row selector
  • 0%
    Design view
  • 0%
    Join Properties
  • 0%
    Show Table
Q.31.
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
  • 0%
    record
  • 0%
    ID
  • 0%
    MAX
  • 0%
    Undo
Q.32.
To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.
  • 0%
    Rob?n
  • 0%
    Design View
  • 0%
    Rename Field
  • 0%
    Open
Q.33.
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%
    Rename
  • 0%
    Design View
  • 0%
    Report
Q.34.
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
  • 0%
    Insert Field
  • 0%
    Square Brackets []
  • 0%
    Rename Field
  • 0%
    Rename
Q.35.
To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.
  • 0%
    EXTERNAL DATA
  • 0%
    Query Design
  • 0%
    Design View
  • 0%
    Delete