Shulou(Shulou.com)05/31 Report--

This article to share with you is about how to use the table wizard to create tables in the Access database, Xiaobian feels quite practical, so share it with everyone to learn, I hope you can gain something after reading this article, not much to say, follow Xiaobian to see it.

1. Launch Table Wizard

In the database window, click the Table object. Then double-click the Create Table with Wizard option to launch the Table Wizard. After selecting the Table object, click New on the Database window toolbar to open the New Table dialog box. Select Table Wizard in the dialog box, and then click OK to start Table Wizard.

2. select the field

(1)Select the Business radio button in the Table Wizard dialog box.

(2)Select the Student table in the Sample Table list box, and then double-click Student ID in the Sample Field list box. The selected field will be automatically added to the Field in New Table box. Click the field first, and then click the button to add the selected field to the Field in New Table box. Click the button to delete the selected field added to the new table. Click the button to add all the fields in the sample fields to the new table, or click the button to delete all the fields that have been added to the new table. Double-click Name in Sample Field, and this field will be automatically added to Field in New Table box.

3. rename field name

To modify the name of a field in a table, select the field to be modified in the Fields in New Table box, for example, select Name, click Rename Field, enter the name of the new field in the renamed field dialog box that pops up, and click OK.

4. Specify the name of the table, set the primary key

Click the [Next] button and a dialog box page appears. Enter the name of the new table "Student Information" in the [Please Specify Table Name] text box. In the Set Primary Key with Wizard radio button group, determine how to set the primary key. If you select the No, let me set the primary key by myself radio button, and then click Next, a dialog box will pop up. Select a field as the primary key field in the drop-down list box of Please determine which field will have the data for each record. For example, select Student No. in this table, and then specify the data type of the primary key field. For example, select the Numbers and/or Letters I Enter When Adding New Records radio button, and then click Next. If you select the [Yes, Set a Primary Key for Me] radio button and click the [Next] button, the dialog box will not pop up, but the previous dialog box will be displayed, and you will jump to the next step to set the relationship between tables.

5. Determine whether the new table is related to other tables in the database as shown in the figure below. Click Relationship to open a dialog box, and select the radio button Match one record in Class Information with multiple records in Student Information. Then click OK to return to the dialog box page.

6. Select the actions after the wizard finishes creating the table. Click Next to pop up a dialog box, where you can select the actions after the wizard finishes creating the table. For example, select Modify Table Design radio button, and then click Finish.

7. Modify Table Structure Open the table's Design View to modify the table structure. The modification of table structure mainly includes modifying table design, changing fields, editing fields and modifying table display.

The above is how to use the table wizard to create tables in the Access database. Xiaobian believes that some knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.