Question

Answer the following as True or False.
Forms or queries can be created using single table only
Forms can also be used to modity the table's data
Cheries can extract the data only from the tables
Multiple criteria can also be set on a query
Reports can only be used in its printable form
Match the following:
Form wizard
(1) Displays and summa data
bQuery
(1) Connert tables on commented
c Report
d Navigation bar
(iv) Moving from or to another
e Relationship
(1) Retrieving data based on iteria
Fill in the blanks using the hints given in the Clue Box
Clue Box
Bottom
Tabular Common Queries Form wizard
form can display all records at a time
bUsing
option to create a form you add the selected tied to the town
Navigation buttons appear at the
can extract the information from the tables an d orta
Query on two or more tables can be generated if they have
these are related
Very short answer type questions.
a. What are forms?
b. What are queries?
c. Is it possible to extract information based on meie than one condition in a single query
Short answer type questions.
a. What is the difference between a form and a table
b. Write the steps to create simple select query
c. How do you relate the tables in Base?
monted questions.​

Answer 1

Answer:

true/false

a)true

b)false

c) false

d)true

Answer 2

Answer:

a. What are forms?

Forms are defined as a way for user to send data to the server for processing. User can fill the form either to get the data from the server or to send the data to the server.

b. What are queries?

Queries are nothing but the requests made by the client side to the database. These requests can include the information from the database or the permission to perform certain actions like inserting new information, deletion, or updation of pre-stored information.

c. Is it possible to extract information based on meie than one condition in a single query

Yes, it is  possible to extract information based on meie than one condition in a single query.

a. What is the difference between a form and a table

Form is used by the user to send or get the data from the server whereas a table is used to list some data or information in a tabular format consisting of rows and columns.

b. Write the steps to create simple select query.

• First write the command of the query language.
• Then specify the table on which the command should execute.
• Finally, write the condition for the query as criteria(optional)

#SPJ3