Which of the following pane is NOT available in Task pane?

Which of the following pane is NOT available in Task pane?

  • Slide Design
  • Master Slide
  • Slide Layout
  • Slide Transition

It is the most common type of query. It retrieves records from one or more tables and then displays the

It is the most common type of query. It retrieves records from one or more tables and then displays the

  • Parameter
  • Select
  • Crosstab
  • All of the above

Which of the following is a method to create a new table in MS Access?

Which of the following is a method to create a new table in MS Access?

  • Create table in Design View
  • Create Table using wizard
  • Create Table by Entering data
  • All of the above

While creating relationship, when you drag a field to drop into another table the mouse pointer changes into

While creating a relationship, when you drag a field to drop into another table the mouse pointer changes into

  • a doctor's sign
  • thin + sign
  • outline rectangle
  • None of above

Queries in Access can be used as

Queries in Access can be used as

  • view, change, and analyze data in different ways
  • a source of records for forms and reports
  • Only option a
  • Both option a and b

Which field type can store photos?

Which field type can store photos?

  • Hyperlink
  • OLE
  • Both of these can be used
  • Access tables can't store photos

The operator will cause a record to be selected only if two or more conditions are satisfied.

The operator will cause a record to be selected only if two or more conditions are satisfied.

  • Or
  • If or
  • Range
  • And

Unlike text data type, this can store up to maximum of 65, 535 characters

Unlike text data type, this can store up to maximum of 65, 535 characters

  • Memo
  • data/time
  • Number
  • All of the above

We can remove a relationship defined between two tables by

We can remove a relationship defined between two tables by

  • From Edit menu choose Delete Relationship
  • Select the relationship line and press Delete
  • Choose Delete option from the Relationship menu
  • All of the above

What is the purpose of a sub datasheet?

What is the purpose of a sub datasheet?

  • To provide a hierarchical view of related tables or queries in a single window
  • To display grouped data in a report
  • To display summarized data
  • All of the above