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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
28.
Both conditions, display on the same row in the design grid when ……operator is in use.
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
Discuss about this problem:
Discuss in Forum
30.
Data can be imported into Access Database from……
Notepad Files
PowerPoint Files
Word Files
Excel Files
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
32.
In a database table, the category of information is called…..
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
36.
Which is not database object?
37.
……leads you through the process of creating a table?
38.
The two form layout types will display multiple records at one time are tabular and……
Columnar
Justified
Data Sheet
Piviot Table
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
40.
Which of the following is not a logical database structure?
41.
You can set a controls boarder type to make the border invisible.
Transparent
Invisible
Do not display
No border
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
44.
Which is not a type of relation?
One to One
One to Many
Many to One
Many to Many
Answer: Option
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
46.
The ……. Operator will cause a record to be selected only if two or more conditions are satisfied.
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
Discuss about this problem:
Discuss in Forum
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
Discuss about this problem:
Discuss in Forum
49.
To duplicate a controls formatting you can use……
All Right Reserved Copyright © MCQTayari.com
#buttons=(Ok, Go it!) #days=(20)
Our website uses cookies to enhance your experience. Check Now
Ok, Go it!