MS Access Section 1 Page 2


26.
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
Answer: Option

27.
Append from command is used to…..
Add record from a file
Add record from a variable
Add record from stock
Add record from information in an array
Answer: Option

28.
Both conditions, display on the same row in the design grid when ……operator is in use.
OR
IN
AND
LIKE
Answer: Option

29.
Referential integrity means……
Don't enter a value in the foreign key field of a child table if that value doesn't exist in the primary key of the parent table
Enter a value in the primary key field of child table if that value doesn't exist in the primary key of the parent table
Don't enter a value in the foreign key field of a parent table if that value doesn't exist in the primary key of the child table
All of the above
Answer: Option

30.
Data can be imported into Access Database from……
Notepad Files
PowerPoint Files
Word Files
Excel Files
Answer: Option

31.
Which of the following is a type of relationship that can be applied in access database?
One to One
One to Many
Many to Many
All of the above
Answer: Option

32.
In a database table, the category of information is called…..
Tuple
Field
Record
All of the above
Answer: Option

33.
Which of the following is not a type of relationship that can be applied in MS Access database?
One to One
One to Many
Many to Many
Many to One
Answer: Option

34.
Cascade delete option……
is used to delete all the records of all tables in a database
will repeat the recent delete operation to all the records of current table
is available in Edit relationship dialog box which make sure that all the related records will be deleted automatically when the record from parent table is deleted
None of the above
Answer: Option

35.
Which of the following statement is true….
Reports can be used to retrieve data from tables and calculate
Queries can be printed in well formatted manner and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are used to print but reports to display on screen only
Answer: Option

36.
Which is not database object?
Page
Macro
Format
None of the above
Answer: Option

37.
……leads you through the process of creating a table?
Wizard
Assitant
Relation
Coach
Answer: Option

38.
The two form layout types will display multiple records at one time are tabular and……
Columnar
Justified
Data Sheet
Piviot Table
Answer: Option

39.
Queries can be created in MS Access by……
Using Query Wizard
Typing Queries in SQL view
Drag 7 Drop Fields on query builder
All of the above
Answer: Option

40.
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
Answer: Option

41.
You can set a controls boarder type to make the border invisible.
Transparent
Invisible
Do not display
No border
Answer: Option

42.
What is a form in MS Access?
It is a printed page where user will write their data to fill it up
It is an input screen designed to make the viewing & entering data easier
This is an important part of database used by analysis to draw conclusion
All of the above
Answer: Option

43.
To achieve AND effect when you are entering criteria in a query design windows…..
write criteria values vertically one in a row
write criteria values horizontally
write criteria values in same field separated with AND
write criteria values in same field separated with &
Answer: Option

44.
Which is not a type of relation?
One to One
One to Many
Many to One
Many to Many
Answer: Option

45.
When a picture or other graphic image is placed in the report header section it will appear……
Once in the beginning of the report
At the top of every page
Every after record break
On the 1st and last pages of the report
Answer: Option

46.
The ……. Operator will cause a record to be selected only if two or more conditions are satisfied.
OR
IF
RANGE
AND
Answer: Option

47.
Queries in MS Access can be used as……
View, change and analyze data in different ways
A source of records for forms and reports
Only A
Both A & B
Answer: Option

48.
While creating relationship whwn you drag a field of a field to drop into another table the mouse pointer changes into……
a doctor's sign
thin + sign
outline rectangle
None of above
Answer: Option

49.
To duplicate a controls formatting you can use……
Manager
Wizard
Painter
Control
Answer: Option

50.
……enables you to view data from a table based on a specific criterion.
Form
Query
Macro
Report
Answer: Option

#buttons=(Ok, Go it!) #days=(20)

Our website uses cookies to enhance your experience. Check Now
Ok, Go it!