Practice Test: Question Set - 01
1. Which view is used to arrange table data in different graphical layouts to summarize data?
- (A) Table view
- (B) Design view
- (C) Data sheet
view
- (D) Pivot chart
view
2. Which combination of key zooms the content of active cell in Access table?
- (A) Ctrl + F2
- (B) Ctrl + F5
- (C) Shift + F2
- (D) Shift + F5
3. Which validation rule allows only positive numbers for fields in?
- (A) Is Null or
> = 0
- (B) Is Null or
Positive
- (C) Is Null or
< 0
- (D) None of the
above
4. Write the output when the data 'Primary Key' is set to the text < in Access?
- (A) Primary key
- (B) primary key
- (C) PRIMARY KEY
- (D) Primary Key
5. What is the maximum number of characters allowed in text field is access?
- (A) 255
- (B) 256
- (C) 64000
- (D) 65000
6. Which combination of key allows user to move to the first field in the first record in Access table?
- (A) Ctrl + Tab
- (B) Shift +Tab
- (C) Shift + Home
- (D) Ctrl + Home
7. Which validation rule allows exactly digits for number fields in Access?
- (A) Is Null or
Between 100000 and 99999
- (B) Is Null or
Like ??????
- (C) Is Null or
>= 0 AND< = 99999
- (D) Is Null or
< = 99999
8. What is the reason for not accepting zero in the fields of Access tables?
- (A) Fields is
set with is Null or > 0
- (B) Fields is
set with is Null or < = 0
- (C) Fields is
set with is Null or! [0]
- (D) Fields is
set with is Null or like ???
9. What is the expansion of OLE in Access?
- (A) Object
linking and embedding
- (B) Object
linking and encrypting
- (C) Object
linking and editing
- (D) Object
linking
10. Which object stores information about related data?
- (A) Document
- (B) Table
- (C) Page
- (D) Screen
Next Tests: