Question

Key words Long text, Calculated, Or, Lookup wizard, And, Short text, Like, In 1 Limited to 255 characters 2 Available in Design view. Not really a data type but will display in the list of data types. Links to fields in other tables 3 Opens the expression builder to create an expression based on existing fields or numbers 4 Lengthy text or combinations of text and numbers. Can hold up to 65,535 characters 5 Tests for values equal to existing members in a list 6 Matches pattern strings in text and memo fields 7 Specifies that all of the entered data must fall within the specified limits 9 Specifies that one of many entries can be accepted 10 The section called Field Properties applies an attribute or a characteristic to a field that controls the display and input of data, use: Select one: True False

Answer 1

1.Ans: Short text:

Short Text field is set to store 255 characters by default, but you can adjust the Character Limit property all the way up to 4000 characters.

2. Ans: Lookup table

A lookup field can display a user friendly value that is bound to another value in the source data table or value list.

3. Ans: Calculated:

CALCULATED enables you to use the results of an expression in the same SELECT clause or in the WHERE clause

4. Ans: TEXT

A TEXT field can hold 65,355 bytes of data whereas a long text can store upto 4GB of data.

5. Ans: IN

This keyword is used to check whether value is present in a list of values.

6. Ans: LIKE

LIKE can be used to match a particular substring inside a long string or text.

7. Ans: AND

The value of AND is set to be TRUE, if and only if all the criteria is satisfied.

9. Ans: OR

The value of OR is set to be TRUE even if any one of the criteria is met.