access（接近）.docVIP

access（接近） Qujingguo Keep a grade: ACCESS machine test 100 program design (second chapters ~ eighth chapters), two, 30, three, 40, four or five, six or seven,, eight, 30 22~26 Written test 100 programming (Chapter I ~ eighth chapters) and public course eighth chapter 30~35 public course, 30~35 6 Chapter 1: development time of database Time: late 1960s Role: a large amount of data structures store data sharing Data: Symbols Data processing: process Database management system: its a software Role: a software (DBMS) specially configured for the establishment, use and maintenance of a database ACCESS is an office software developed by the Microsoft Corp in the United States, Office 2003 Task pane: Ctrl+F1 New file: Ctrl+N Open file: Ctrl+O Create an empty database. The function of the file new database dialog box: 1, save the location of the new file 2, the new files saved name 3, save the type of new file Type of file to master in ACCESS test: 1, Excel.Xls 2, Access.Mdb 3, text document.Txt Alt+F+X database files and software Create a database using the wizard (template) Second chapters Table composition: table structure and table content Field: 1, field name 2, data type 3, field properties Table structure: table names and field properties Table contents: Records Table structure: Field naming rules: 1, 1~64 characters 2, cannot start with spaces 3. 4 symbols that cannot be included:.! [] Character: it is a symbol, a Chinese character is a character, an English is also a character Byte: the place where the characters are stored. It is a unit of measurement, a Chinese character is two bytes, and an English is also a byte Two, data type 1 text: the combination of storing text or text and numbers (an arithmetic number that cannot be counted, such as a phone number). The 0~255 character defaults to 50 characters. 2: Note: storage of text can not be stored! 64000 characters, such as: resume 3: numbers, such as age, that can perform arithmetic operations Calculation of age f