1)To Enforce Entering Data to a Field, You Should Set to Yes the Property

Philadelphia UniversityQuiz #3

Computer Science DepartmentMS Access2010

1)To enforce entering data to a field, you should set to Yes the property:

A)Date Type

B)Required

C)Field Size

D)Validation Rule

2)To set a field as a primary key, it should be:

A)Unique and not null

B)Not unique and null

C)Unique and null

D)Not unique and not null

3)One of the following field number type accept decimal places:

A)Integer

B)Long Integer

C)Byte

D)Single

4)To create a one-to-many relationship between two tables, a new field should be created in the related table that is similar to the primary key in the primary table, in:

A)Data Type

B)Field Size

C)Date Type and Field Size

D)None of the above

5)In the image below, in table Students, if you entered “Business” in “Department” field, the following error message will be displayed:

A)Wrong Entry

B)Error in Department Entry

C)Error in Primary Key

D)Wrong Data

6)In the image below, if the query was applied, the result of the Count function will be:

A)1

B)2

C)3

D)4

7)In the image below, if the query was applied on Students table, the number of records resulted will be:

A)2

B)4

C)3

D)1

8)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

9)The picture below displays the Report Wizard, number of field(s) grouped in this report is:

A)1

B)2

C)3

D)4

10) In the picture below and depending on the displayed table; the query which returns the records of Ahmad, Mohammad and Maha is:

A)Query 1

B)Query 2

C)Query 3

D)None of the above

Q11: In the picture below, what is the layout (type) of the displayed form?

A)Simple Form

B)Split Form

C)Multiple Items

D)None of the above