MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Practice
Access Quiz
«
Multiple Choice Questions
»
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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
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
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 []
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
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
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
Access is a ____.
0%
EXTERNAL DATA
0%
Shutter Bar Open/Close
0%
database management system
0%
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.
0%
Show Table
0%
primary key
0%
relational
0%
row selector
A(n) ____ contains information about a given person, product, or event.
0%
DELETE
0%
Rename
0%
record
0%
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.
0%
primary key
0%
Delete
0%
Design View
0%
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
0%
Create
0%
MAX
0%
Format
0%
Open
A field whose data type is ____ can contain any characters.
0%
OLE object
0%
Design view
0%
Short Text
0%
> 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.
0%
Design View
0%
Rename Field
0%
Insert Field
0%
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.
0%
Criteria
0%
row selector
0%
primary key
0%
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.
0%
> 1000
0%
Create
0%
$0.00
0%
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.
0%
Options
0%
Rename
0%
relational
0%
Design View
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
0 h : 0 m : 1 s
«
Multiple Choice Questions
»
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
0
Answered
0
Not Answered
0
Not Visited
Correct : 0
Incorrect : 0
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page