Page 28 - ModularV1.1 _c8_flipbook
P. 28

SETTING A PRIMARY KEY

                  A primary key is a field in a table that uniquely identifies each
                  records  in  the  table.  The  primary  key  field  does  not  accept
                  duplicate or null values. A table can have only one primary key.
                  Follow these steps to set a primary key in a table:

                  Step 1  Open the table in the Design view.
                  Step 2  Right-click on the row header of the field on which you
                          want to apply primary key. A context menu appears.

                  Step 3  Select the Primary Key option. A key icon will appear in           Setting a primary key
                          front of the field name.
                     Recap


                          MS Access 2010 is an easy-to-use Relational Database Management System developed
                         by Microsoft.
                          The data types are used to declare the type of the fields in the database.
                          There are two types of views in MS Access: Datasheet view and Design view.


                                                         Exercise



                           ü
                  A.  Tick ( ) the correct option.
                     1.  Which of the following is not a relational database?
                       a. MySQL                             b. MS Access                  c. MS Excel

                     2.   Which option is present on the left side of the Access window that displays the names of the
                        objects used in the database such as Table, Query and Form?

                       a. Navigation pane                   b. Work Area                  c. Ribbon
                     3.   Which of the following data types is used to store a large amount of text or a combination of text
                        and numbers?

                       a. Text                              b. Memo                       c. Number

                     4.  In which of the following views, the records are not visible?
                       a. Datasheet                         b. Template                   c. Design

                     5.  Which of the following data types are used to store currency values?

                       a. Money                             b. Currency                   c. Memo

                  B.  Write ‘T’ for true and ‘F’ for false.

                     1.   The Field Properties Pane is used to set the properties of the fields
                        defined in the table.                                                            ............................
                     2.  Navigation Pane is present on right side of MS Access window.                   ............................



                  26      Modular (Ver. 1.1)-VIII
   23   24   25   26   27   28   29   30   31   32   33