Have an account?
Skip to Content
Build your own quiz
21 questions
Show Answers
See Preview
- 1. Multiple Choice
Which Of The Following Is Not A Type Of Microsoft Access Database Object
A) Table
B) Form
C) Report
D) All of the above applied
- 2. Multiple Choice
What Are The Columns In A Microsoft Access Table Called
A) Rows
B) Records
C) Fields
D) Columns
- 3. Multiple Choice
What Is The Maximum Length A Text Field Can Be?
A) 522
B) 255
C) 265
D) 50
- 4. Multiple Choice
What is a report in MS Access
A) It is a printed page where users can display data
B) It is an input screen designed to make the viewing and entering data easier
C) This is an important part of database used by analysts to draw conclusions
D) All of above
- 5. Multiple Choice
What Are The Different Views To Display A Table?
A) Datasheet View
B) Design View
C) Pivote Table & Pivot Chart View
D) All Of Above
- 6. Multiple Choice
To create relationship between two tables
drag the primary key of a table into the primary key of another table
drag any field from parent table and drop on child table
drag the primary key of a table into foreign key of another table
Any of above can be done to create relationship
- 7. Multiple Choice
What happens when you release mouse pointer after you drop the primary key of a table into foreign
A) A relationship is created
B) Edit relationship dialog box appears
C) Error occurs
D) Nothing happens
- 8. Multiple Choice
The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables
relationship
join
query
none of the above
- 9. Multiple Choice
If you write criteria values vertically (one in a row) it will mean
OR conditions
AND conditions
NOT condition
None of above
- 10. Multiple Choice
In A Database Table, The Category Of Information Is Called
Tuple
field
record
all of the above
- 11. Multiple Choice
Why are communication skills important when creating databases?
To enter text and data.
To categorize information.
To correct errors in data.
To clarify what is needed.
- 12. Multiple Choice
Why are numeracy skills important when using databases?
To organize information.
To create queries.
To read procedures.
To present details
- 13. Multiple Choice
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
DCL
DML
DDL
All of the above
- 14. Multiple Choice
…………….is like looking for Customer requirements and specifications
Reports
Fields
Queries
Forms
- 15. Multiple Choice
1. Queries in Access can be used as
A) view, change and analyze data in different ways
B) Display data
C) None of the above
D) Both a and b
- 16. Multiple Choice
2. To create queries in Access
A) You can drag and drop fields on query builders
B) you can type the SQL command in SQL view
C) You can use query wizard or design view
D) All of above
- 17. Multiple Choice
What does the show check box in query design window indicate
A) It indicates whether the field is to be used or not
B) It indicates whether the field is to be displayed in query result or not
C) It indicates whether the field names to be displayed in query result or not
D) None of above
- 18. Multiple Choice
Query design window has two parts. The lower part shows
A-Tables with fields and relationships between tables
B-Criteria
C-Check box
D- B and C
- 19. Multiple Choice
What does SOP stand for
Service Operating process
Standard only power
Standard Operating Procedure
None of the above
- 20. Multiple Choice
What does OSH stand for
Occupational Standard and Health
Occupational Security and Health
Occupational Safety and Health
None of the above
- 21. Multiple Choice
What's Occupational Standard and Health ?
A planned system of working to prevent illness and injury where you work by organizing and identifying hazards and risks
A planned system of working to prevent any challenges
A planned system of working to follow the rules and regulations
None of the above
- Answer choicesTagsAnswer choicesTags