1 |
Getting data from a cell located in a different sheet is called … |
|
A. |
Accessing |
|
B. |
Referencing |
|
C. |
Updating |
|
D. |
Functioning |
|
|
2 |
You can use different page formatting within the same document by separating the differently formatted areas using – |
|
A. |
Page Break |
|
B. |
Column Break |
|
C. |
Formatting Break |
|
D. |
Section Break |
|
|
4 |
Which is not related to relationship? |
|
A. |
Avoid duplicate data |
|
B. |
Data can be entered into or viewed from one or more tables |
|
C. |
create inconsistency of data |
|
D. |
None |
|
|
|
|
|
|
6 |
Of the following options, which is/are valid report layout(s)? |
|
A. |
Stepped |
|
B. |
Block |
|
C. |
portrait |
|
D. |
Both A & B |
|
|
7 |
Which of the following views does not allow the form to be modified? |
|
A. |
Layout view |
|
B. |
Form View |
|
C. |
Design view |
|
D. |
All |
|
|
8 |
In which row of query design grid do we set conditions? |
|
A. |
Field |
|
B. |
sort |
|
C. |
criteria |
|
D. |
show |
|
|
9 |
What type of page orientation does a document have when it is laid out so that it is wider than it is tall? |
|
A. |
Landscape |
|
B. |
Side |
|
C. |
Horizontal |
|
D. |
Portrait |
|
|
10 |
Access 2007 supports which type of database system? |
|
A. |
DBMS |
|
B. |
RDBMS |
|
C. |
Flat file system |
|
D. |
ORDBMS |
|
|
11 |
To create a relationship what should you do? |
|
A. |
Click Insert menu and then click Relationship |
|
B. |
Click Database Tools tab and click Relationship button |
|
C. |
Click Edit menu and then click Relationship |
|
D. |
Press Ctrl + Shift + P |
|
|
12 |
You can insert automatic page numbering to the top of each page in MS Word by clicking on the – |
|
A. |
Home tab > Page Number > Top |
|
B. |
Insert tab > Page Number > Top of Page > Choose a style |
|
C. |
View tab > Paging > Number > Header |
|
D. |
Page Layout tab > Indent > Top |
|
|
13 |
Which one of the following statements is not correct related to Index? |
|
A. |
An index stores the location of records. |
|
B. |
Index may speed up searches, it can also slow the process of updating data within table. |
|
C. |
You can set index on a field which is seldom used |
|
D. |
You can set index on any fields except OLE objects or attachment fields. |
|
|
14 |
Updating all tables that are dependent upon a main or master table is called |
|
A. |
Cascade delete |
|
B. |
Cascade update |
|
C. |
Referential integrity |
|
D. |
None |
|
|
15 |
Which one is correct regarding relationships? |
|
A. |
You can not edit or delete relationship. |
|
B. |
Many to Many relationship between tables is considered as an ideal relationship. |
|
C. |
You can not edit table after establishing relationship |
|
D. |
None |
|
|
16 |
Filters remain in place until— |
|
A. |
they are removed |
|
B. |
the object is closed |
|
C. |
Both A & B |
|
D. |
Only A |
|
|
18 |
If you want to distribute your document to someone using a totally different word‐processing program from a different software manufacturer, such as WordPerfect, which file-format will you choose when saving the document? |
|
A. |
rtf |
|
B. |
doc |
|
C. |
xls |
|
D. |
pdf |
|
|
19 |
In Windows Explorer, for displaying the contents of a certain drive or folder we need to |
|
A. |
Click the drive or folder while holding down the Alt key. |
|
B. |
Triple-click the drive or folder. |
|
C. |
Double-click the drive or folder. |
|
D. |
Right-click the drive or folder. |
|
|
|
20 |
Which one of the following is not the form view? |
|
|
A. |
Form view |
|
B. |
Datasheet view |
|
C. |
Layout view |
|
D. |
Design view |
|
|
|
|
|
|
|
|
|
|
|
|
|