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

