Chapter one Subject: CT Class f4
Name_____________________________________________________________
Part one: multiple choice s
[Link]’s a single piece of information such as name or product stored in table.
A. Record
B. Field
C. Table
D. Row
2. Which of the following is not include MS database objects?
1. Table C. Query
2. Form D. Primary
[Link] of the following type relationship is?
3. One to many relationships
4. Many to many relationships
5. One to one relationship
6. Many to one relationship
[Link] of the followings is not table elements?
A. Row
B. Text
C. Column
D. Cell
[Link] ,sometimes abbraviated as DB is an organized
A. Collection of related information C. Collection of related data
B. collection of related database D. collection of related fact
1
[Link] left side window that holds MS access objects and allows quick and easy access is
A. Form window pane
C. Bound pane
B Navigation pane
D. Panel pane
[Link] stands for
A. Database management service
B. Database management system
C. Database management software
D. Database manager system
[Link] of the steps correct to create a table in a design view?
A. Click the table design----choose data type ----------give the field name
B. Click the view ------------give the field name -------choose data type
C. Click the data type ------give the field name -------table design
D. Click the table design----give the field name-------choose data type
Structured questions 1
2
[Link] the blanks into words inside boxes
Software Hardware Data Producer Procedures Database access
language
• _________________: physical electronic equipment ex: Hard disk drive and computers
• ______________: set of programs used to manage and control the database ex: OS
• __________: are facts or pieces of information about an object ex: person’s name
• _______________: refers to the instructions used in database management system
• __________________: is a programming language for accessing, updating, and deleting
data from database.
Questions: answer all below questions
1. Differentiate between RDBMS and DBMS?
…………………………………………………………………………………………
…………………………………………………………………………………………
……………………………………………………………………………………..
2. State the common example of DBMS software?
…………………………………………………………………………………………
…………………………………………………………………………………………
3. What are the responsibility of Database administrator (DBA)?
…………………………………………………………………………………………
………………………………………………………………………………………
4:Compare bound forms and unbound forms
Bound forms Unbound forms
3
[Link] the following terms
a. Table …………………………………………………………………
b. Form …………………………………………………………
c. Query……………………………………………………………
d. Report ………………………………………………………………..
6. List any five data types of MS access database table?
…………………………………………………………..
…………………………………………………………..
……………………………………………………………
…………………………………………………………….
[Link] using the below picture, write the steps to create the new database while MS access is
existing or opening
Step1:……………………………………………………………………………….
Step2:……………………………………………………………………………..
Step3:………………………………………………………………………….
Step4:……………………………………………………………………………
4
[Link] the process or steps to sort data either ascending or descending?
1
3
Step1: .,……………………………………………………………….
Step2………………………………………………………………..
Step3:………………………………………………………………
[Link] is the different between sorting and filtering?
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
[Link] primary key and foreign key?
………………………………………………………………………………………………
………………………………………………………………………………………………
……………………………………………………………………………………………
[Link] Microsoft access and write its advantages?
………………………………………………………………………………………………
………………………………………………………………………………………………
…………………………………………………………………………………………….
5
[Link] the steps to apply filtering below depicted picture?
Step1:……………………………………………………………………………….
Step2:…………………………………………………………………………….
Step3:……………………………………………………………………………….
Step4:…………………………………………………………………………….
b. After finishing the filtering process what will be the result?
………………………………………………………………………………….
[Link] is data validation mean and write the field properties of data validation
……………………………………………………………………………………
………………………………………………………………………………….
6
[Link] is query and write query types?
…………………………………………………………………………………………..
………………………………………………………………………………………..
[Link] is relationship and how many types of relationships there are?
And show with diagram
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
[Link] the database terminologies
………………………………………………………………………………………………
………………………………………………………………………………………………
…………………………………………………………………………………………….
[Link] is record and give example about a record??
………………………………………………………………………………….
……………………………………………………………………………….
7
[Link] down the steps to create a blank database?
Step1:……………………………………………………………..
Step2……………………………………………………………..
Step3:……………………………………………………………..
Step4:……………………………………………………………..
19..Write the steps /process to create a form using form wizard
Step1:……………………………………………………………..
Step2……………………………………………………………..
Step3:……………………………………………………………..
Step4:……………………………………………………………..
[Link] down steps/process to create a query by using a query design?
Step1:……………………………………………………………..
Step2……………………………………………………………..
Step3:……………………………………………………………..
Step4:……………………………………………………………..
Step5:……………………………………………………………..
21. Write down the process to delete a record?
Step1:……………………………………………………………..
Step2……………………………………………………………..
[Link] the database components of MS access?
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………….
[Link] down the steps of changing form properties and list the three most
important of form properties?
Step1:………………………………………………………..
Step2……………………………………………………………...
………………………………………………………………………………………………
……………………………………………………………………………………………..