17使用表单向导选择商品表生成一个文件名为good_form的表单（17 use the form wizard to select the commodity table and generate a form named good_form）.docVIP

17使用表单向导选择商品表生成一个文件名为good_form的表单（17 use the form wizard to select the commodity table and generate a form named good_form） Seventeenth sets I. Basic operation Complete the following operations in the candidate folder: 1. establish the project supermarket management and add the commodity management database to the project; 2. adds the field for the commodity table: the sales price N (6,2), which allows null values, and defaults to.NULL; 3. set the validity rule for the sales price field: the selling price =0; the error prompt message is: the selling price must be greater than or equal to zero.. 4. use the report wizard to create a report for the commodity table: the report includes all the fields in the commodity table, and the report style is run. The data in the report is arranged in ascending order according to the commodity code, and the report file name is report_a.frx. The rest is set by default. Answer： First class 1. click the file, click new, file type left click project, click new document, create a pop-up dialog box, in the create dialog box and enter the project file name supermarket management then left click the save button. 2., in the project manager, click the data tab, right-click add, in the open dialog box, right-click the commodity management.Dbc, and then click ok. Second a. 1. left click the plus sign in front of the database, click the plus sign in the front of the commodity management, and then click left to modify. 2. in database designer - commodity management, the mouse clicks the right mouse button on the commodity table, and left click to modify it. 3. in the table designer - commodity table.Dbf, In the final at the input field structure called the sale price and then select the type to numeric and enter the width 6 decimal digits 2 tick NULL left click, click OK, click . Third a. 1. in database designer - commodity management, the mouse clicks the right mouse button on the commodity table, and left click to modify it. 2. in table design