Page 226 - IT_V1.0_Class10
P. 226

Create Table by Using Wizard

              Creating a table using the wizard in LibreOffice Base simplifies the process by guiding you step-by-step
              through the necessary configurations. The wizard provides a structured method to define fields, set data
              types, and configure primary keys, ensuring that your table is correctly set up for your specific needs.
              Follow the given steps to create a table using wizard:

              Step 1:  Click on the Use Wizard to Create Table option from the Tasks pane.
                       The  Table Wizard  will  open.  This  wizard  shows  two  pre-existing  categories  of  databases,  i.e.,
                       Business and Personal.

              Step 2:  Click on the Personal radio button to create table related to some kind of personal database or click
                       on the Business radio button to create table that can be related to business. In our case, we have
                       clicked the Business radio button.
              Step 3:  Select  the  desired  table  from  the  Sample tables  list.  In  this  case,  we  have  selected  the
                       Customers table.

                       The fields of the Customers table are displayed in the Available fields list box.
              Step 4:  Select the CustomerID option from the Available fields list box

              Step 5:  Click on the    button to move the selected field to the Selected fields list box.










                                   2

                                                                                                   3

                                                                                                   5





                                   4





                       Similarly, you can move the Company Name, Address, City, CountryOrRegion, EmailAddress
                       and StateOrProvince fields from the Available fields list box to Selected fields list box.

                       When you click on the      button, it allows you to move one field from the Available fields list
                       box to the Selected fields list box; while, when you click on the    button it allows you to move
                       all the available fields together in one go from the Available fields list box to the Selected fields
                       list box.
                       If a field from the Selected fields box is not required, then select the field that is to be moves back
                       to the Available fields list box, then click on the    button. If all fields from the Selected fields box
                       is not required, then click on the    button.






                224     Information Technology Play (Ver 1.0)-X
   221   222   223   224   225   226   227   228   229   230   231