教材表和查询上机演习题(国外英语资料).doc

教材表和查询上机练习题 Computer exercises Copy the subscribe management database from the learning materials folder on the server to the local and complete the task with the following requirements. This exercise is kept in your own folder, waiting for the notification to be submitted. The basic operation of the table Related table structure operations: (1) in the customer table, the title of the phone field is set to cell phone, and the input mask is only in the form of 11 digits. (2) in the table in the paper, the publication fields default Settings for issue, and create access attributes for the field, a display control of the combo box , line source type for the list of values, line source for issue; weekly; a Thursday issue; a Friday and a publication on Saturday. The validity of the subscription year field is set to greater than zero and the validity text is: the price must be greater than zero. (3) in the subscribe table, the format of the subscription date field is set to a short date and the default value is set to the current date of the system. Table and record editing operations: (1) backup the customer, newspaper and subscribe 3 tables in the current database, and the name of the backup is kehu, baozhi and dingyue. (2) in kehu increase customer type field in the table, and use the reference guide to establish the field of data types, check list personal and unit and members three values. (3) in the baozhi delete masthead field in the table, and then inserted before the annual subscription price field subscription price of half an year fields, data types for the number (single precision, currency format, the decimal digits 2). (4) as baozhi table setting validity rules: the subscription price of half an year the value of the field must be less than the annual subscription price the value of the field, effective text is: the data input is wrong. (5) move the subscription date field to the subscribe number field in the dingyue table. (6) two records are added in the