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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.