When entering field name, how many characters you can type in maximum?
A. 60
B. 64
C. 68
D. Any number of character
Select an option to see the answer and solution.
In a table to insert User's Voice, Data field should be
A. OLE Object
B. SoundField
C. VoiceField
D. Memo
Select an option to see the answer and solution.
In Access press to Complete the wizard
A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Select an option to see the answer and solution.
Which do you click to display the table's primary key and indexes in a separate window?
A. indexes button
B. primary key button
C. view datasheet button
D. view design button
Select an option to see the answer and solution.
Any report, including a basic report, can be modified in _________.
A. Form View
B. Layout View
C. Print Preview
D. Report View
Select an option to see the answer and solution.
The Search tool is best used when searching for ______ data.
A. simple
B. multiple
C. unique
D. formatted
Select an option to see the answer and solution.
Which of the following is not a database object in MS Access?
A. Tables
B. Query
C. Report
D. Relationship
Select an option to see the answer and solution.
This type of database contains multiple tables that are connected to produce combined output from all tables.
A. Bound
B. Linked
C. Relational
D. Joined
Select an option to see the answer and solution.
Which of the following is not a database application?
A. dBase
B. Flash
C. FoxPro
D. Access
Select an option to see the answer and solution.
Which is not a command that is selectable from right click menu of a field column?
A. Hide columns
B. Unhide columns
C. freeze columns
D. sort descending
Select an option to see the answer and solution.
A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A. The pin code
B. The last name
C. A compound key consisting of the first name and the last name
D. All of the above
Select an option to see the answer and solution.
__________ is used to build 'intuitive' queries.
Select an option to see the answer and solution.
What is the type of query that extracts data from a table and puts them into separate table?
A. Parameter query
B. Make table query
C. Update query
D. Put table query
Select an option to see the answer and solution.
Which of the following data types automatically generates a consecutive number?
A. Autonumber
B. Memo
C. Number
D. Text
Select an option to see the answer and solution.
Which of the following is invalid field name?
A. Student.Address
B. Student'sAddress
C. Student_Address
D. Student Address
Select an option to see the answer and solution.
Press the following keys in Access to Cancel Print Preview or Layout Preview
A. CTRL+P
B. P or CTRL+P
C. S
D. C or ESC
Select an option to see the answer and solution.
The filter by selection feature allows you to filter:
A. Those records that match an entity in a field
B. Records based on a criterion you specify
C. Records that meet any of several criteria you specify
D. All of above
Select an option to see the answer and solution.
The default and maximum size of text field in Access
A. 50 and 255 Characters
B. 8 and 1 GB
C. 266 characters & 64000 characters
D. None of above
Select an option to see the answer and solution.
Which of the following methods CANNOT be used to delete records from a table?
A. Selecting records and pressing [Delete]
B. Pressing [Ctrl]+[']
C. Clicking the Delete Record button
D. From the ribbon, selecting Delete Record
Select an option to see the answer and solution.
How can you display the related records from other tables in datasheet view?
A. Click on the expand indicator next to the record
B. Double click on the record to expand it
C. Apply filter by command to display related records
D. All of above
Select an option to see the answer and solution.