Page 41 - Code Craft Computer-8
P. 41

Try It Out                                                                   #Problem Solving

              Write down the steps to delete a record in a table.
              1.   _________________________________________________________________________________
              2.   _________________________________________________________________________________
              3.   _________________________________________________________________________________
              4.   _________________________________________________________________________________



                          Flashback Time


                    ¨  A table is a database object, which is used to store information in an organised manner.
                    ¨  A table consists of rows and columns.
                    ¨  A field stores one type of information about all the objects or items.
                    ¨  Data types are used to declare the fields of a table.
                    ¨  A data type determines the type of data in it. Once the data type is defined, we cannot enter a
                       different type of data in it. If we try to do so, an error message will be displayed.
                    ¨  The data types available in MS Access 2021 are – Short Text, Long Text, Number, Data/Time,
                       Currency, AutoNumber, Yes/No, an OLE (Object Linking and Embedding) object, Hyperlink,
                       Attachment, Calculated and Lookup Wizard.

                      Knowledge Check


              A.     Mark the correct response.
                                                                                               OMR Sheet
                     1.  Which of the following data types lets you store an integer that is
                          incremented automatically as you add records?                        Use only blue/black ball
                                                                                               pen to fill the circles. It
                          a. Currency                     b. Yes/No                            should   be   darkened
                                                                                               completely and properly.
                          c. AutoNumber                   d. Long Text                         Wrong methods
                     2.   Find the odd term out.
                                                                                               Correct method
                          a. Date/Time                    b. Field Size

                          c. Required                     d. Allow Zero Length                 1.   a   b    c    d
                     3.   A field that has a unique value for every record and cannot be
                          left blank is called the __________.                                 2.   a   b    c    d

                          a. Special key                  b. Primary key
                                                                                               3.   a   b    c    d
                          c. Unique key                   d. DBMS key
                     4.                is the symbol used to describe :
                                                                                               4.   a   b    c    d
                          a. Sorting                      b. Design View

                          c. Datasheet View               d. Primary key                       5.   a   b    c    d
                     5.   Which of the following field properties is used to put conditions
                          on the data that can be entered in a table?

                          a. Field Size                   b. Format
                          c. Validation Rule              d. Required

                                                                 41
   36   37   38   39   40   41   42   43   44   45   46