Microsoft Access 2007- Review Exam For 3rd Year Mcs Students Part 2

45 Questions | By Johnwyne | Updated: Mar 20, 2022 | Attempts: 207

Questions

Settings

Feedback

During the Quiz End of Quiz

Play as

Quiz Flashcard

Create your own Quiz

Microsoft Access 2007- Review Exam For 3rd Year Mcs Students Part 2 - Quiz

Part 2 Review Exam- Bakbakan na!

Questions and Answers

1.

This is a form within a form that also displays data records from more than one table.
- A.
  
  List box
- B.
  
  Rectangle
- C.
  
  Line
- D.
  
  Sub form/Sub report
2.

This works like a combo box, but is displayed differently.
- A.
  
  List box
- B.
  
  Rectangle
- C.
  
  Line
- D.
  
  Sub form/Sub report
3.

This is used to provide users with a list of values that can either be bound to a field in a table, or Unbound which stores values not related with any of the tables.
- A.
  
  Label
- B.
  
  Text box
- C.
  
  Combo box
- D.
  
  Button
4.

It used to perform an action or set of actions when clicked.
- A.
  
  Label
- B.
  
  Text box
- C.
  
  Combo box
- D.
  
  Button
5.

It is one or more fields whose value or values uniquely identify each record in a table.
- A.
  
  Ctrl key
- B.
  
  Primary key
- C.
  
  One to one
- D.
  
  Relationship
6.

The key used to select one or more primary keys while clicking the field row selector.
- A.
  
  Ctrl key
- B.
  
  Primary key
- C.
  
  One to one
- D.
  
  Relationship
7.

It is an association established between common fields in two tables.
- A.
  
  Ctrl key
- B.
  
  Primary key
- C.
  
  One to one
- D.
  
  Relationship
8.

It is a relationship that can be established when one record in a table has only one matching record In another table.
- A.
  
  Ctrl key
- B.
  
  Primary key
- C.
  
  One to one
- D.
  
  Relationship
9.

It is the most common type of relationship.
- A.
  
  One too many
- B.
  
  Many too many
- C.
  
  Junction table
- D.
  
  Foreign keys
10.

It is an association between two tables in which one record in either table can relate to many Records in another table.
- A.
  
  One too many
- B.
  
  Foreign keys
- C.
  
  Junction table
- D.
  
  Many too many
11.

It is a table that contains common fields from two tables.
- A.
  
  One too many
- B.
  
  Foreign keys
- C.
  
  Junction table
- D.
  
  Many too many
12.

It ensures that relationships between records in related tables are valid and that you don't Accidentally delete or change related data.
- A.
  
  Design
- B.
  
  Referential
- C.
  
  Both A and B
- D.
  
  None of the above
13.

The contextual tab where the Edit Relationships button belongs.
- A.
  
  Design
- B.
  
  Referential
- C.
  
  Both A and B
- D.
  
  None of the above
14.

It is the most commonly used type of query which retrieves records from one or more tables.
- A.
  
  Action
- B.
  
  Cross tab
- C.
  
  Select
- D.
  
  Other
15.

This query is used to make changes to records or move a group of records.
- A.
  
  Action
- B.
  
  Cross tab
- C.
  
  Select
- D.
  
  Other
16.

This query is used to calculate and restructure data for easier analysis.
- A.
  
  Action
- B.
  
  Cross tab
- C.
  
  Select
- D.
  
  Other
17.

The group where the Query Wizard and Query Design belongs.
- A.
  
  Action
- B.
  
  Cross tab
- C.
  
  Select
- D.
  
  Other
18.

These are values such as numbers, characters, or dates, which Access evaluates exactly as Written.
- A.
  
  Literal Values
- B.
  
  Functions
- C.
  
  Constants
- D.
  
  Identifiers
19.

Elements in an expression with values that do not change are called______.
- A.
  
  Literal Values
- B.
  
  Functions
- C.
  
  Constants
- D.
  
  Identifiers
20.

In an expression, a function returns a valued based on the results of a calculation or other Operation.
- A.
  
  Literal Values
- B.
  
  Functions
- C.
  
  Constants
- D.
  
  Identifiers
21.

The value of a field, control, or property is referred to______.
- A.
  
  Literal Values
- B.
  
  Functions
- C.
  
  Constants
- D.
  
  Identifiers
22.

This is the area where you construct/build your expression.
- A.
  
  Expression elements
- B.
  
  Expression box
- C.
  
  Operator buttons
- D.
  
  None of the above
23.

These are commonly used operators that you can use in your expression
- A.
  
  Expression elements
- B.
  
  Expression box
- C.
  
  Operator buttons
- D.
  
  Both A and B
24.

This contains three columns: the left column displays the folder that list the tables, queries, forms And reports in your database, as well as the available functions.
- A.
  
  Expression elements
- B.
  
  Expression box
- C.
  
  Operator buttons
- D.
  
  None of the above
25.

These are ready- made databases formats with pre- designed objects available in MS Access 07.
- A.
  
  Templates
- B.
  
  Table templates
- C.
  
  Functions
- D.
  
  Fields templates