Access操作步骤（Access operation steps）.docVIP

Access操作步骤（Access operation steps） Aaccess operation questions specific steps ~ welcome to share! Source: log 1001 Basic operation questions: (1) (2) primary key: worker ID (3) validity rule: IS NOT NULL (5) input mask: 00000 (two) (2) primary key: number (3) validity rule: =DateSerial (Year (Date ()) -1,5,1) (4) the input mask of the mailbox password field: PassWord or password; The input mask for the contact field: 010-, (three) (2) primary key: number (3) default value: Date () -1 (4) the decimal number of the unit price field is set to 2, and the format of the field is set as fixed or standard (5) input mask: AAAAAAAA (four) (2) open the properties window of the table: The effectiveness of the rules for input: [tCourse].[hours]= [tCourse]. [credit] Enter in the valid text line: the class hours must be the same as the credits (3) default value: DateSerial (Year (Date ()), 9,1) (5) when importing the text file Test.TXT into the table tTemp, you should select the first row containing the field name check box in the second step of the import text wizard, or import errors will occur. (7) rename the macro mTest to AutoExec. (five) (1) validity rule: 0 (6) in the link data table wizard in the first step in the selection of Sheet1 working table, select the first row contains column header check box in the second step, enter the link table name tTest in the third step, click finish. (7) select the line table and right-click, select export in the open shortcut menu... Open the corresponding Export dialog box; in the dialog boxs save type, select the text file, enter Line.TXT in the file name, and click the export button; In the second step of the export text wizard, select the first row, including the field name check box, and the select the semicolon option button under the field separator, and others follow the prompts. Simple application questions: (1) samp14.mdb (1) [operation steps] Step 1: select the query object, click the new button, select design view,