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

