Available Answers

1. 1.

   Multiple Choice Questions.

   1. The __________ is used to create a relationship between two tables.
      1. Primary Key
      2. Candidate Key
      3. Foreign Key
      4. Alternate Key
   2. What is a form in MS Access?
      1. It is a printed page where users will write their data to fill it up.
      2. It is an input screen designed to make the viewing and entering data easier.
      3. This is an important part of database used by analysts to draw conclusions.
      4. All of above
   3. To create queries in Access
      1. You can drag and drop  fields on query builders.
      2. You can type the SQL command in SQL view.
      3. You can use query wizard or design view 
      4. All of above
   4. Queries in Access can be used as 
      1. View, change and analyze data in different ways.
      2. A source of records for forms and reports.
      3. Print Data
      4. both a and b,
   5. Two tables can be linked with relationship so that the data interiority can be enforced. Where can you find Relationship command?
      1. File menu
      2. View Menu
      3. Database Menu
      4. Tools Menu
   6. Which of the following database object can be used if you need to mail the invoice to customers?
      1. A Form
      2. A Query
      3. A Report
      4. A Table
   7. The result of a query is displayed in a 
      1. Record
      2. Query datasheet
      3. Query table
      4. Form
   8. This is not one of the sections of the Form Design window.
      1. Form Footer
      2. Form Content
      3. Form Header
      4. Form Detail
   9. The ___________ option is used to run a query.
      1. Run option on the Tools menu.
      2. Query option on th Run menu.
      3. Run option on the Edit menu.
      4. Run option on the Query menu.
   10. To preview a report before printing, the ________ options used.
       1. Print option on the File menu.
       2. Print option on the Edit menu.
       3. Print Preview option on the Edit menu.
       4. Print Preview option on the View menu.
2. 2.

   Fill in the blanks.

   1. The result of a query is known as _________.
   2. The___________ option can be used to find replace a record.
   3. The ________ and __________ keys are used to invoke the Find and Replace dialog box.
   4. The Sort option on the __________ menu is used to invoke the Find and Replace dialog box.
   5. A query can be created using the __________ or the __________ option.
   6. The __________ option is used to search for the records in a form.
   7. A __________ is used for presenting information in a customized format on screen and paper.
   8. Reports can be printed using the _________ option.
   9. RDBMS stands for _____________.
   10. The quickest way to crest a form is to use of __________ feature. 
3. 3.

   What is Query ? What is its importance ?

4. 4.

   What is Form ? Name the various ways of creating Form ?

5. 5.

   What is Report ? What purpose does it serve ?

6. 6.

   Write the steps to sort a query.