NEW
Font size
WorksheetsRevision"Database"-"Retrieving records"
Total questions: 22
Worksheet time: 39mins
…………………..is a collection of data in different formats so it can be easily accessed, updated and managed
Fields
Reports
Database
Records
…………….is like asking a detailed question of your database and look for Customer requirements and specifications
Reports
Fields
Queries
Forms
................... is a set of principles of moral values.
Principals
Ethics
Ideals
None of the above
………………………………is a set of written rules which explains how people should behave
Morals
Ethics
Codes of practice
None of the above
To edit a relationship between two tables
Click two times on the relationship line
Click one time on the relationship line
Right click on the relationship line
A and C
Which of the followings are Ethical principles
Protect customers’ information
Keep up-to-date regulations
Classify Data
A and B
What Is the Maximum Length of long text Field Can Be?
220
255
150
None of the above
Which of the below is a way of classifying data?
Alphabetical
Rows
Columns
A and B
Which of the below could go wrong when retrieving information
Information could be missing
The deadline cannot be met
You don’t have the authority to receive the information
All of the above
Is to display data to print
Form
Report
Table
None of the above
Is the datatype used for e-mail
Short text
Hyperlink
Wizard
Number
What are the filing systems
Electronic
Electricity
Paper Based
A and C
The interface of the database
Form
Query
Report
Field
1. Queries in Access can be used as
A) view, change and analyze data in different ways
B) a source of records for forms and reports
C) None of the above
D) Both a and b
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
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
What is a form in MS Access
A) It is a printed page where users will write their data to fill it up
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
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command
A) File menu
B) View Menu
C) Database Menu
D) Tools Menu
Which of the following is not a type of relationship that can be applied in Access database
A) One to One
B) One to Many
C) Many to Many
D) All of above can be applied
To create relationship between two tables
A) drag the foreign key of a table into the primary key of another table
B) drag the primary key of a table into foreign key of another table
C) drag any field from parent table and drop on child table
D) Any of above can be done to create relationship
…………….is something that can be checked and backed up with evidence
Fact
Opinion
None of the above
It's looks like it's sunny outside
Fact
Opinion
None of the above
