Grade 11 Data Operations Mock Exam

ALL of the following are data types in MS Access Except?

• Yes/NO

• Hyperlink

• Integer

• Text

Which of the following software is used to make a database?

• MS WORD

• MS EXCEL

• MS DATABASE

• MS ACCESS

Your Data operation teacher told you to enter one piece of data from a record in a table in your database. This piece of data to be entered is date of birth. This ONE piece of data is called a

• Row

• File

• Field

• Record

The object that is used to produce a list of records that meet a particular criterion is a:

• Form

• Table

• Query

• Relationship

Which field type will you select if you need to enter long text in that field?

• Text

• Memo

• Currency

• Auto number

Which of the following is not a type of MS Access database object?

• Table

• Form

• Worksheets

• Relationship

What can be the maximum length of a text field?

• 120

• 255

• 265

• 20

The columns in a Microsoft access table are also called _______

• Rows

• Records

• Fields

• Cells

In MS Access, a field is also referred to as a _______

• Record

• Table

• Attribute

• Column

In general, which of the following cannot be used as a primary Key?

• TRN number

• Age number

• Passport number

• Telephone number