Multiple Choice Questions

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.
  • Rename Field
  • Long Text
  • Design View
  • Criteria
To import data to a table, tap or click the ____ tab on the ribbon.
  • Back Up Database
  • EXTERNAL DATA
  • Shutter Bar Open/Close
  • Compact & Repair
To open the Navigation Pane, tap or click the ____ Button.
  • EXTERNAL DATA
  • Back Up Database
  • Shutter Bar Open/Close
  • Square Brackets []
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
  • Back Up Database
  • row selector
  • Compact & Repair
  • Report
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.
  • row selector
  • primary key
  • Join Properties
  • Show Table
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.
  • Insert Field
  • primary key
  • Rename
  • Design View
Access is a ____.
  • EXTERNAL DATA
  • Shutter Bar Open/Close
  • database management system
  • Square Brackets []
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.
  • Show Table
  • primary key
  • relational
  • row selector
A(n) ____ contains information about a given person, product, or event.
  • DELETE
  • Rename
  • record
  • Report
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.
  • primary key
  • Delete
  • Design View
  • Insert Field
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency
  • Create
  • MAX
  • Format
  • Open
A field whose data type is ____ can contain any characters.
  • OLE object
  • Design view
  • Short Text
  • > 1000
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.
  • Design View
  • Rename Field
  • Insert Field
  • Rob?n
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.
  • Criteria
  • row selector
  • primary key
  • Join Properties
To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
  • > 1000
  • Create
  • $0.00
  • Design view
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.
  • Options
  • Rename
  • relational
  • Design View
To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.
  • DELETE
  • Report
  • record
  • Create
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.
  • MAX
  • Run.
  • Format
  • Undo
When you create a table in Datasheet view, automatically adds a field called ___ as the first field in the table.
  • ID
  • MAX
  • Yes
  • Undo
To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.
  • MAX
  • Run.
  • Format
  • Undo
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table
  • Attachment
  • OLE object
  • AutoNumber
  • Design view
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
  • Query Design
  • Delete
  • Insert Field
  • Design View
To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.
  • MAX
  • DELETE
  • Close
  • Yes
A field whose data type is ____ can store text that can be used as a hyperlink address.
  • Hyperlink
  • Attachment
  • OLE object
  • database management system
To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
  • Quick Access Toolbar
  • EXTERNAL DATA
  • Square Brackets []
  • Back Up Database
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.
  • Delete
  • Rename
  • Create
  • Report
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
  • Format
  • MAX
  • Report
  • Create
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.
  • relational
  • primary key
  • Show Table
  • Long Text
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
  • Format
  • Yes
  • Undo
  • Run.
In the accompanying figure, the small box or bar to the left of each field is called the ____.
  • row selector
  • Design view
  • Join Properties
  • Show Table
When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
  • record
  • ID
  • MAX
  • Undo
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.
  • Rob?n
  • Design View
  • Rename Field
  • Open
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
  • Rename
  • Design View
  • Report
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 ____.
  • Insert Field
  • Square Brackets []
  • Rename Field
  • Rename
To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.
  • EXTERNAL DATA
  • Query Design
  • Design View
  • Delete
0 h : 0 m : 1 s

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