Information and communications technology 51-100

How many relations may exist between tables in databases?

• 1

• 2

• 3

• 4

• 5

What the object used for printed on paper the database in a Microsoft Access?

• Form

• Macros

• Query

• Report

• Table

Which data type is better to use for storing phone number in the following format “977-1-1234567”  in Access?

• Attachment

• AutoNumber

• Number

• Text

• Memo

Which criteria return only those addresses beginning with the letter “K” in Access??

• Address = “K*”

• Address = “*K”

• Address = “K?”

• Address = “K”

Which criteria return only a phone number ending the number "5" in Access??

• number phone = “*5”

• number phone =  “5”

• number phone = “?5?”

• number phone = “?5*”

Which of the following Data Type is used to store picture in MS Access?

• Image

• OLE Object

• Picture cannot be stored in MS Access

• Memo

• Picture

What is the maximum length a Text field can be in MS Access?

• 75

• 265

• 256

• 120

• 255

What is the extension of Access Database files (2007 and later)?

• mbd

• accdb

• accdc

• accbd

• mdb

The number of rows in Excel 2007 worksheet is:

• 4194304

• 8388608

• 4096

• 256

• 1048576 

What key should be used to edit the content of a cell?

• F2

• F4 

• F3

• F5