Philadelphia University
/ / Faculty of information TechnologyCoordinator: Mrs. Eman Alnaji / Department of Computer Science
Internal Examiner: Dr. Hasan Al Refai / Examination Paper
Computer Skills (9761111)
Computer Skills – Humanities (0710103) / Second Exam / First Semester of Academic Year 2014/2015
Date: 8 January 2015 / Time: 50 minutes A
Information for candidates
1. This examination paper contains 20 questions, totaling 20 marks
2. Marks of Each Question is 1.
Advice to Candidates
1. You should attempt all questions.
2. You should write your Answers clearly in the specified place in the first page.
Question / Answer1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q1: Microsoft Office Access is used basically for:
A) Database Management
B) Data Presentation
C) Data Editing and Formatting
D) Web Page Design
Q2: The extension (امتداد) of access files in MS-Access 2007 is:
A) mdb
B) dbx
C) accdb
D) docx
Q3: In the picture below, and based on (بناء على) the properties (خصائص) of "First Name" field in the table "Courses_Fees", which name of the following could be seen in the datasheet view?
A) ALI
B) ali
C) mi
D) MI
Q4: To enforce (يجبر) a user to fill a field and not to leave it empty in the Datasheet View, we need to set the ______property to “yes”.
A) Format
B) Validation Rule
C) Required
D) Validation Text
Q5: In the picture below, the button numbered by 1 is used to:
A) Move to last record
B) Move to next record
C) Move to first record
D) Add a new record
Q6: The icon which is used to delete a field from a table in the design view is:
A)
B)
C)
D)
Q7: In the picture below, number of created tables in the displayed database is:
A) 0
B) 6
C) 3
D) Unknown
Q8: Changes applied on Table fields in the design view:
A) Are saved automatically by Ms Access 2007, without giving you a warning message (رسالة تحذير) to save them.
B) Should be saved by the user, and gives a warning message (رسالة تحذير) if not saved.
C) Cannot be changed later on
D) All of the above.
Q9: The picture below displays the Report Wizard, number of field(s) grouped in this report is:
A) 1
B) 2
C) 3
D) 4
Q10: In the picture below, the result of count in the displayed query is:
A) 8
B) 0
C) 3
D) 11
Q11: In the picture below and depending on the displayed table; the query which returns the records of hana, rana, sana, and dana is:
A) Query 1
B) Query 2
C) Query 3
D) All of the above
Q12: In the picture below, the resulted names in First Name field after running the displayed query are:
A) James and Yazeed
B) Sean and Yazeed
C) Amr, Naiall and Yazeed
D) Naiall, Amr, James and Yazeed
Q13: In the picture below, names that result in First Name field after running the following query are:
A) Naiall
B) Niamh
C) Naiall and Niamh
D) Naiall, Niamh and Lina
Q14: A primary key field:
A) Should not contain null values.
B) Should not contain redundant (مكررة) values.
C) Its data type should be Auto number.
D) A and B.
Q15: In the picture below, the result of Query2 which depends on the relation between "books" table (primary table) and "borrower" table (related table) is:
A) Result 1
B) Result 2
C) Result 3
D) Result 4
Q16: In the picture below, depending on the displayed Query wizard, number of fields that will appear in the result of this query is:
A) 2
B) 6
C) 4
D) Unknown
Q17: In the picture below, data type of the gender field in the student table is:
A) text
B) Date/Time
C) Yes/No
D) Number
Q18: In the image below, what is the layout (type) of the displayed form?
A) Simple Form
B) Split Form
C) Multiple Items
D) None of the above
Q19: In the picture below, the result of total function in the displayed query is:
Query1 Query2 Query3
A) Query1
B) Query2
C) Query3
D) None of them
Q20: In the picture below, based on the properties of "stu_id" field, the value which makes you get an error message if you entered it in this field in the datasheet view is:
A) 0
B) 600
C) 700
D) All of the above
Good Luck!
[12/A]