VF上机题目详细答案及操作步骤.pdfVIP

基本题:(1)CREATEDATABASEordermanagementADDTABLEemployeeADDTABLEorders

(2)1.OpenandmodifythedatabaseMODIFYDATABASEordermanagement

2.InDatabaseDesigner-OrderManagement,selectthetableordersandright-click,selecttheModifycommand,inTable

Designer-orders.dbf,clicktheIndextab,thenentertheindexnameje,selectDownArrowinSortfordescendingorder,selectthe

typeasNormalIndex,theexpressionasAmount,finallyclicktheOKbutton,andthenclickYes(Y)tocreatetheindex.

(3)CREATETABLEcustomer(customernumberC(4),customernameC(36),addressC(36))

Holdquantity0,enterHoldquantitycannotbe0intheInformationfield,andfinallyclicktheOKbutton.

(4)1.OpenandmodifythedatabaseMODIFYDATABASEordermanagement

2.InDatabaseDesigner-OrderManagement,selectthetablecustomerandright-click,selecttheModifycommand,in

TableDesigner-customer.dbf,clicktheIndextab,thenentertheindexnameCustomerNumber,selectthetypeasPrimary

Index,theexpressionasCustomerNumber,finallyclicktheOKbutton,andthenclickYes(Y)tocreatetheindex.

3.InDatabaseDesigner-OrderManagement,selectthetableordersandright-click,selecttheModifycommand,inTableDesigner-orders.dbf,clickthe

Indextab,thenentertheindexnameCustomerNumber,selectthetypeasNormalIndex,theexpressionasCustomerNumber,finallyclicktheOKbutton,and

thenclickYes(Y)tocreatetheindex.

4.InDatabaseDesigner-OrderManagement,selectthemainindexkeyCustomerNumberinthecustomertableand

holditdown,thenmovethemouseanddragittotheindexkeyCustomerNumberintheorderstable,andreleasethemouse.

Simplequestions(1)1.OpenandmodifytheformMODI