Page 312 - TP_IT_V1.0_C10_flipbpookl
P. 312

Use Wizard to Create Table
              A wizard is a step-by-step process of doing a specific task through a set of dialog boxes. Creating tables using wizards
              offers a convenient and efficient approach to database design, particularly for users who are less experienced or who
              need to quickly prototype database structures. On the other hand, for some users creating the table using wizard
              restricts to use the same fields in the pre-designed tables. It may not solve the purpose in real scenario, as it will create
              a table with the different columns that are not matching with the user’s column choice.
              Following are the given steps to create a table using wizard:

              Step 1:  Open the School.odb database.
              Step 2:  Select Tables (default) option in the Database pane.
              Step 3:  Click on the Use Wizard to Create Table option from the Tasks pane.

              The Table Wizard will open.


































              This wizard contains four steps. Let us read about those steps.
              1.   Select fields: You have a choice of two categories of suggested tables: Business and Personal. Each category contains
                 its own suggested tables from which you can choose any. Each table has a list of available fields.
              Step 4:  Select the Personal option from the Category section.

              Step 5:   Select the desired option form the Sample tables drop-down menu. In this case, we have selected the Library
                      option.
                      The fields related to the Library table is shown in the Available fields list box.
              Step 6:   Select the BookID option from the Available fields list box and click on the    button to move the selected
                      field to the Selected fields list box.
                        Similarly, move the Publisher, Title, and AuthorID fields from the Available fields list box to Selected fields
                      list box.









                310   Trackpad Information Technology (Ver. 1.0)-X
   307   308   309   310   311   312   313   314   315   316   317