试卷分析评价系统--、外文翻译、文献综述(编辑修改稿)内容摘要:
年 月 日 指导教师审阅意见 : 翻译原文专业文章 2 篇,字符数 超过要求一倍以上; 英语功底较深厚,翻译稿语句较通顺,语法运用基本得当,意思翻译较准确; 本专业基础较扎实,因此对原文的专业内容阅读能力较强,理解能力较好。 指导教师签名 . 年 月 日 所译外文资料附件 (含封面、封底、目 录、翻译部分页码的复印件等一并予以装订) 第一篇英文稿: Creating Tables Introduction to Tables Tables are grids that store information in a database similar to the way an Excel worksheet stores information in a workbook. Access provides three ways to create a table for which there are icons in the Database Window. Doubleclick on the icons to create a table. the Database Window Create table in Design view will allow you to create the fields of the table. This is the most mon way of creating a table and is explained in detail below. Create table using wizard will step you through the creation of a table. Create table by entering data will give you a blank datasheet with unlabelled columns that looks much like an Excel worksheet. Enter data into the cells and click the Save button. You will be prompted to add a primary key field. After the table is saved, the empty cells of the datasheet are trimmed. The fields are given generic names such as Field1, Field2, etc. To rename them with more descriptive titles that reflect the content of the fields, select Format|Rename Column from the menu bar or highlight the column, rightclick on it with the mouse, and select Rename Column from the shortcut menu. Create a Table in Design View Design View will allow you to define the fields in the table before adding any data to the datasheet. The window is divided into two parts: a top pane for entering the field name, data type, and an option description of the field, and a bottom pane for specifying field properties. Field Name This is the name of the field and should represent the contents of the field such as Name, Address, Final Grade, etc. The name can not exceed 64 characters in length and may include spaces. Data Type is the type of value that will be entered into the fields. Text The default type, text type allows any bination of letters and numbers up to a maximum of 255 characters per field record. Memo A text type that stores up to 64,000 characters. Number Any number can be stored. Date/Time A date, time, or bination of both. Currency Moary values that can be set up to automatically include a dollar sign ($) and correct decimal and ma positions. AutoNumber When a new record is created, Access will automatically assign a unique integer to the record in this field. From the General options, select Increment if the numbers should be assigned in order or random if any random number should be chosen. Since every record in a datasheet must include at least one field that distinguishes it from all others, this is a useful data type to use if the existing data will not produce such values. Yes/No Use this option for True/False, Yes/No, On/Off, or other values that must be only one of two. Description (optional) Enter a brief description of what the contents of the field are. Field Properties Select any pertinent properties for the field from the bottom pane. Field Properties Properties for each field are set from the bottom pane of the Design View window. Field Size is used to set the number of characters needed in a text or number field. The default field size for the text type is 50 characters. If the records in the field will only have two or three characters, you can change the size of the field to save disk space or prevent entry errors by limiting the number of characters allowed. Likewise, if the field will require more than 50 characters, enter a number up to 255. The field size is set in exact characters for Text type, but options are give for numbers: Byte Positive integers between 1 and 255 Integer Positive and negative integers between 32,768 and 32,768 Long Integer (default) Larger positive and negative integers between 2 billion and 2 billion. Single Singleprecision floatingpoint number Double Doubleprecision floatingpoint number Decimal Allows for Precision and Scale property control Default Value There may be cases where the value of a field will usually be the same for all records. In this case, a changeable default value can be set to prevent typing the same thing numerous times. Set the Default Value property. Primary Key Every record in a table must have a primary key that differentiates it from every other record in the table. In some cases, it is only necessary to designate an existing field as the primary key if you are certain that every record in the table will have a different value for that particular field. A social security number is an example of a record whose values will only appear once in a database table. Designate the primary key field by rightclicking on the record and selection Primary Key from the shortcut menu or select Edit|Primary Key from the menu bar. The primary key field will be noted with a key image to the left. To remove a primary key, repeat one of these steps. If none of the existing fields in the table will produce unique values for every record, a separate field must be added. Access will prompt you to create this type of field at the beginning of the table the first time you save the table and a primary key field has not been assigned. The field is named ID and the data type is autonumber. Since this extra field serves no purpose to you as the user, the autonumber type automatically updates whenever a record is added so there is no extra work on your part. You may also choose to hide this column in the datasheet as explained。试卷分析评价系统--、外文翻译、文献综述(编辑修改稿)
阅读剩余 0%
本站所有文章资讯、展示的图片素材等内容均为注册用户上传(部分报媒/平媒内容转载自网络合作媒体),仅供学习参考。
用户通过本站上传、发布的任何内容的知识产权归属用户或原始著作权人所有。如有侵犯您的版权,请联系我们反馈本站将在三个工作日内改正。