Question

Choose the correct option :-
1. Which part of the database are you most likely to use for inputting information?
A. Forms.
B. Tables.
C. Queries.
2. When you input data into a form, where does it end up?
A. In the Queries object
B.In the Reports object.
C. In the Tables object 3. A question asked about the data stored in the database.
A. Report
B. Macros.
C. Query. 4. Which of the following can be best described a query?
A. A Query enables people to enter or view data in database easily.
B. A Query summarizes and prints data.
C. A Query retrieves data that satisfies conditions set by you.
5. A Report can contain data from
A. Some fields of a table
B. All fields of Table/Query
C. All of them
6. Which database object allows you to retrieve specific data from tables based on criteria you entered?
A. Reports
B. Queries
C. Forms
Read the following statements and name the database objects :-
1. A user friendly way of entering, editing and viewing the information in the table.
.................... .
2. An object in database that performs actions based on one or more tables in the database or questions or queries given by the user.
................... .
3. An object used to summarize and present data using the information in tables or queries.
.................. .
4. A set of columns or rows, with each column referred to as a field.
................. .
5. The form that shows a form view in the upper section and a datasheet view in the lower section of a window.
................. .
6. It is used to summarize and present data using the information in tables or queries.
............... .
7. It gathers data from one or more tables based on criteria.
............... .​

Answer 1

Answer:

1. form
2. into one or more related tables.
3. A query
4. A query retrieves data that satisfies conditions set by you

Answer 2

Answer:

1. Forms area part of database which is more likely to be used for inputting information.
2. When we  input data into a form, it ends up in the Tables object.
3.  A question asked about the data stored in the database is Query.
4. .A Query retrieves data that satisfies conditions set by you.
5. A Report can contain data from, All of them.
6. Queries database object allows you to retrieve specific data from tables based on criteria you entered.

FILL IN THE BLANKS:

1. A user friendly way of entering, editing and viewing the information in the table is forms

2. An object in database that performs actions based on one or more tables in the database or questions or queries given by the user queries

3. An object used to summarize and present data using the information in tables or queries pivot table

4. A set of columns or rows, with each column referred to as a field. table

5. The form that shows a form view in the upper section and a datasheet view in the lower section of a window. split form

6. It is used to summarize and present data using the information in tables or queries pivot table

7. It gathers data from one or more tables based on criteria.

​join operator