Multiple Choice Questions

To view the results of a saved query, right click the query in the Navigation Pan and then click ______ on the shortcut menu.
  • Delete
  • Format
  • Open
  • Close
To delete a field in the table, right-click the column heading for the field, and then right click _______ on the shortcut menu.
  • Delete
  • Insert Field
  • Design view
  • Delete Field
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.
  • Attachment
  • Long Text
  • Design view
  • AutoNumber
One way to create a table, is to click _____ on the Ribbon and then click the Table button.
  • Format
  • Rename
  • Create
  • Delete
To delete a database object, right-click the object in the Navigation Pane and then click ____ on the shortcut menu.
  • Delete Field
  • Rename
  • Delete
  • Create
To create a query using the Query Wizard, click ______ on the Ribbon and then click Query Wizard button.
  • Rename
  • Report
  • Create
  • Delete
______ words are words that have a special meaning to Access and cannot be used for the names of fields.
  • Report
  • reserved
  • record
  • Long Text
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.
  • Relational
  • Delete Field
  • Insert Field
  • Rename
To compact and repair a database, click _______ button in the Information gallery in the backstage view.
  • Back Up Database
  • Compact and Repair
  • Click To Add
  • Create
A ____ data type can store a variable amount of text or combination of text and numbers where the total number may exceed 255.
  • AutoNumber
  • Attachment
  • Long Text
  • reserved
To change to the design of a query, right-click the query in the Navigation Pane and then click _______ on the shortcut menu.
  • Delete Field
  • Long Text
  • Design view
  • Insert Field
Access is a ______________.
  • Shutter Bar Open/Close
  • database management system
  • External data
  • Compact and Repair
A field whose data type is ________ can store OLE object, which is an object is linked to or embedded in the table.
  • OLE Object
  • Hyperlink
  • short text
  • database management system
To define an additional field in Datasheet view, tap or click the ______ column heading.
  • Delete Field
  • Compact and Repair
  • Click To Add
  • Quick Access Toolbar
To open the Navigation Pane, tap or click the _______ button.
  • External data
  • Quick Access Toolbar
  • Compact and Repair
  • Shutter Bar Open/Close
To add a record to a table, click the ____ record button.
  • New (Blank)
  • Click To Add
  • Design view
  • External data
To import Data, click the _______ tab on the Ribbon.
  • Shutter Bar Open/Close
  • New (Blank)
  • Click To Add
  • External data
Database _______ refers to the arrangement of data into tables and fields .
  • record
  • design
  • Report
  • Delete
A field whose data type is ______ can store text that can be used as a hyperlink address.
  • Hyperlink
  • database management system
  • short text
  • OLE Object
To open a table in Design view, right-click the table in the Navigation Pane and then click on the ______short cut menu.
  • Delete
  • Insert Field
  • Design view
  • Delete Field
To back up the database that is currently open, use the _____ command on the Save As tab in the Backstage View.
  • Quick Access Toolbar
  • Back Up Database
  • Compact and Repair
  • Click To Add
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.
  • Insert Field
  • Design view
  • Relational
  • Delete Field
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.
  • Delete
  • Report
  • Create
  • Rename
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0