NEW
Font size
WorksheetsUnit 5 revision - MS Access/ Database
Total questions: 27
Worksheet time: 22mins
Which Of The Following Is Not A Type Of Microsoft Access Database Object
A) Table
B) Form
C) Worksheets
D) Modules
What Are The Columns In A Microsoft Access Table Called
A) Rows
B) Records
C) Fields
D) Columns
Which Of The Following Is Not A Database Object?
A) Tables
B) Queries
C) Relationships
D) Reports
What Is The Maximum Length A Text Field Can Be?
A) 120
B) 255
C) 265
D) 75
The Database Language That Allows You To Access Or Maintain Data In A Database?
A) DCL
B) DML
C) DDL
D) None Of Above
DCL Provides Commands To Perform Actions Like
A) Change The Structure Of Tables
B) Insert, Update Or Delete Records And Data Values
C) Authorizing Access And Other Control Over Database
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
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
In A Database Table, The Category Of Information Is Called
A) Tuple
B) Field
C) Record
D) All Of Above
This Key Uniquely Identifies Each Record
A) Primary Key
B) Key Record
C) Unique Key
D) Field Name
It Is An Association established Between Common
line
relationship
primarykey
records
To create relationship between two tables
drag the foreign 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
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
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
.………………………………is a set of written rules which explains how people should behave
A) Principals
A) Ethics
A) Codes of practice
A) None of the above
If you write criteria values vertically (one in a row) it will mean
OR conditions
AND conditions
NOT condition
None of above
Which Of The Following Is Not A Database Object?
Tables
queries
relationships
reports
Formal work instructions of how work to be done and by whom
A) Occupational safety and health
B) Standard operating procedure
C) Criteria
D) A and B
What guidelines should be followed by all staff members and users?
A) Privacy law.
A) Copyright law.
A) Industry policies.
A) Code of practice.
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.
Why are numeracy skills important when using databases?
To organize information.
To create queries.
To read procedures.
To present details
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
DCL
DML
DDL
All of the above
Which Of The Following Statement Is True?
Foreign Key Fields Don\'t Allow Duplicate Values
In Primary Key Field You Can Enter Duplicate Value
In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon
All Statements Are True
Following Is Not A Database Model
Network Database Model
Relational Database Model
Object Oriented Database Model
None
. Cascade delete option
A) is used to delete all the records of all tables in a database
B) will repeat the recent delete operation to all the records of current table
C) is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
D) None of above
Referential integrity means
A) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
B) Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
C) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
D) All of above
cascade update option
A) means do not change the value in the primary key field if that record has related records in another table
B) means change all the related records in child tables if the record in parent table is changed
C) Both of above
D) None of above
