National Computer Rank Examination Level 2 VF Examination Outline
basic requirement
1, with basic knowledge of database system.
2, basic understanding of the concept of object-oriented.
3. Master the basic principles of relational database.
4, master the database programming method.
5, can use VISUAL FOXPRO to build a small database application system.
Examination content
First, the basic knowledge of VISUAL FOXPRO
1, basic concept
Database, data model, database management system, classes and objects, events, methods.
2. Relational database:
(1) Relational database: relational model, relational schema, relationship, tuple, attribute, domain, primary keyword and external keyword.
(2) relational operation: selection, projection and connection.
(3) Consistency and integrity of data: entity integrity, domain integrity and citation integrity.
3. The characteristics and working mode of 3.VISUAL FOXPRO system;
Characteristics of (1)WINDOWS version database.
(2) Data type and main file type.
(3) Various devices and wizards
(4) Working mode: interactive mode (command mode, visual operation) and program running mode.
4. Basic data elements of 4.VISUAL FOXPRO:
(1) Constants, variables, expressions.
(2) Common functions: character processing function, numerical calculation function, date and time function, data type conversion function and test function.
Second, the basic operation of VISUAL FOXPRO database
1. Establishment, modification and validity test of databases and tables;
Establishment and modification of (1) table structure.
(2) Browse, add, delete and modify table records.
(3) Create a database and add or delete tables from the database.
(4) Set field-level rules and record rules.
(5) Index of table: main index, candidate index, general index and unique index.
2. Multi-table operation:
(1) Select a workspace.
(2) Establish the association between tables: one-to-one association; One-to-many association.
(3) Set referential integrity.
(4) table connection: internal connection; External connection: left connection, right connection and complete connection.
(5) Establish temporary association between tables.
3, establish the view and data query:
(1) Query file creation, execution and modification.
(2) Create, view and modify view files.
(3) Establish multi-table query.
Third, the relational database standard language SQL
Data definition functions of 1 and SQL:
(1) Create table SQL
(2) modify the table SQL
2. Data modification function of 2.SQL:
(1) Delete SQL
(2) Insert SQL
(3) Update SQL
3. The data query function of 3.SQL:
(1) Simple query.
(2) Nested query.
(3) Connection query.
(4) Grouping and computing queries.
(5) *** and operation.
Four. Use of Project Manager, Designer and Wizard
1, using the project manager:
(1) Use the Data tab.
(2) Use the "Documents" tab.
2, using the form designer:
(1) Add and modify control objects in the form.
(2) Set the data environment.
3. Use the menu designer:
(1) establishes the main option.
(2) Design a submenu.
(3) Program code for setting menu options.
4. Using Report Designer:
(1) Generate a quick report.
(2) Modify the report layout.
(3) Design grouping reports.
(4) Design multi-column reports.
5. Use the application wizard.
Verb (abbreviation of verb) VISUAL FOXPRO programming
1, command file creation and operation:
Establishment of (1) program file.
(2) Simple interactive input and output commands.
(3) Debugging and execution of application programs.
2. Structured programming:
(1) sequence structure programming.
(2) Choose structured programming.
(3) Program design of circular structure.
3. Procedures and procedure calls.
(1) subroutine design and call.
(2) Process and process documents.
(3) Parameter transfer and procedure call in local variables and global variables.
Examination mode
1, written test: 90 minutes.
2. Computer operation: 90 minutes.
Computer operations include:
(1) Basic operation.
(2) simple application.
(3) Comprehensive application. ......& gt& gt
Question 2: What is the content of the computer level 2 exam? Level 2 C: DOS command, computer composition principle, multimedia, database operation, computer network, c language programming, computer examination.
Secondary C++: According to the new syllabus, the teaching contents include: overview of C++ language, data types of C++ language, operators and expressions, basic control statements, arrays, pointers and references, functions, number and object inheritance, templates, etc.
Secondary VB: According to the new syllabus, the teaching contents include: basic concepts of VB, integrated development environment, visual programming methods, basic input and output, functions and usage of common controls, VB control structure statements, etc.
Secondary VF: According to the new syllabus, the teaching contents include: basic knowledge of database system and VF, basic operation of database, structured query language SQL, VF programming, the use of designers and project managers, etc.
Secondary Access: According to the new syllabus, the teaching contents include: database system, database and tables, database query tables, reports, data access pages, macros, modules, etc.
Secondary JAVA: According to the new syllabus, the teaching contents include: introduction to JAVA language, JAVA data types, operators and expressions, process control, class, array and string operation, exception handling, input/output and file operation, thread and object serialization, writing graphical user interface, APPLET programming: download and operation of JZSDK, and Java application.
Question 3: What does the second computer level include? The best thing is to visit. If you don't believe me, you can find a training class in Baidu. It's easier to live, and it's not like the downstairs saying that learning software costs 3 thousand.
Question 4: What is the content of the computer level 2 exam? Level 2: Examination of basic computer knowledge and basic skills of programming with advanced computer languages and debugging on computers. Examination subjects: language programming (C, C++, Java, C#, Visual Basic, Delphi) and database programming (Visual FoxPro, Access)*** seven subjects. Examination content: the second-level post is a programmer, and the examination content includes basic knowledge and program design. All subjects have unified requirements for basic knowledge and adopt a unified public basic knowledge examination outline and tutorial. The proportion of the basic knowledge of the second-level public * * * in the written test of each subject is 30%(30 points). The programming part accounts for 70%(70 points), which mainly examines the basic ability of candidates to use programming languages, programming and debugging. Examination form: The examination of all subjects in Level 2 still includes two parts: written examination and computer examination. The written test time of Level 2 C is changed from 120 minutes to 90 minutes, and the computer time is changed from 60 minutes to 90 minutes. The written test time of all the second-level subjects is 90 minutes, and the computer time is 90 minutes. System environment: The application software of computer examination for secondary subjects is: Chinese professional version Access 2003, Chinese professional version Visual Basic 6.0, Chinese professional version Visual FoxPro 6.0, Visual C++ 6.0, secondary C computer examination application software Visual C++6.0, secondary Java computer examination application software special integrated development environment NetBeans China Education Examination Edition 2007 (related websites will provide free downloads), and secondary Delphi uses Delphi 7. The second-class certificate shows that the holder has basic computer knowledge and basic application ability, can write programs and debug programs in high-level computer languages, and can engage in computer program compilation, primary computer teaching and training, and business and marketing work of computer enterprises. Textbooks include: National Computer Rank Examination Level II Course-Public Basic Knowledge (20 10), National Computer Rank Examination Level II Course -C Language Programming (20 10), National Computer Rank Examination Level II Course -c++ Language Programming (20 10) Kloc-0/0) Java programming (20 10) -Visual Basic programming (206538
I hope I can help you.
Question 5: What learning content does computer level 2 include? Brief introduction of national computer grade examination
-
First, the nature of the examination.
The National Computer Rank Examination (NCRE) is a national computer proficiency examination system approved by the former State Education Commission (now the Ministry of Education) and sponsored by the Examination Center of the Ministry of Education. It is geared to the society and used to test candidates' computer application knowledge and ability.
Second, the purpose of the exam
The application of computer technology in various fields in China has developed rapidly. In order to meet the needs of the development of knowledge economy and information industry, operating and applying computers has become a basic skill that people must master. Many units and departments regard mastering certain computer knowledge and application skills as one of the important bases for cadre recruitment, job promotion, job title evaluation and job qualification. In view of the objective needs of the society, with the approval of the former State Education Commission, the former State Education Commission Examination Center introduced NCRE to the society with 1994. Its purpose is to promote learning by examination, popularize computer knowledge to the society, and provide a unified, objective and fair standard for the recruitment and assessment of staff in the employing department.
Third, organization
NCRE implements a two-level management system of the examination center of the Ministry of Education and the undertaking institutions of all provinces (autonomous regions and municipalities directly under the Central Government). The examination center of the Ministry of Education is responsible for organizing examinations, formulating relevant rules and regulations, compiling examination outlines and corresponding guidance materials, formulating examination papers, answers and grading standards, developing computer software necessary for examinations, and conducting examination research and publicity. The examination center of the Ministry of Education shall set up provincial-level contractors in all provinces (autonomous regions and municipalities directly under the Central Government), which shall be responsible for the publicity, promotion and implementation of examinations in this province (autonomous regions and municipalities directly under the Central Government), and set up examination centers, organize marking, process scores and issue certificates of conformity according to regulations.
Fourth, the level setting
NCRE currently * * * sets four levels:
Level 1: It aims to meet people's application of computers in general work, with emphasis on the assessment of operational ability. The assessment content mainly includes the basic knowledge of microcomputer and the basic skills of using office automation software and Internet. The certificate winner should have the ability to engage in secretarial and office information computerization in organs, enterprises and institutions.
Level 2: As a computer programmer, it can be described as a blue-collar computer. The examination content mainly includes the basic knowledge of computer, the basic skills of programming with a high-level computer language (including QBASIC, C, FORTRAN, FoxBASE, Visual Basic and Visual FoxPro) and debugging on the computer. Certificate holders should be engaged in computer programming, primary computer teaching and training, business and marketing of computer enterprises.
Level 3: positioned as a development engineer, focusing on design, management, testing and technical support. The three levels are divided into four categories: PC technology, information management technology, database technology and network technology. PC technology examines the hardware composition of PC, the basic knowledge of Windows operating system and the basic skills of PC use, management, maintenance and application development. Information management technology examines the basic knowledge of computer information management application and the basic skills of development and maintenance of management information system projects and office automation system projects. Database technology examines the basic knowledge of database system and the basic skills of database application system project development and maintenance. Network technology examines the basic knowledge of computer network and the basic skills of computer network application system development and management. PC technology examines assembly language programming on computers, while other categories examine C language programming on computers. The winner of the third-level certificate should have the basic ability to develop and maintain its corresponding hardware or software system.
Level 4: positioned as system design engineer and project supervisor. The examination contents include computer principle, data structure and discrete mathematics. & gt
Question 6: What is the content of the National Computer Level 2 Examination? Computer secondary subjects are divided into two categories, one is language programming (C, C++, Java, Visual Basic, Delphi), and the other is database programming (Visual FoxPro, Access). For example, if you apply for Level 2 C, you should take the written test and computer test of C language. The written test is mainly about choosing, filling in the blanks and buying a book to read! * * * Three questions on the computer, program error correction, program fill in the blanks, and a programming question! Secondary VB and C are relatively simple.
Question 7: What is the second-level office test of computer? Adopt paperless examination and computer operation.
Examination time: 120 minutes
Software environment: operating system Windows 7.
Office software Microsoft Office 20 10
Multiple-choice questions (20 points) (including the basic knowledge of Public * * * 10 points), and complete the following operations within the specified time: 2. Word operation (30 points) 3. Excel operation (30 points) 4. PowerPoint operation (20 points).
First, the basic knowledge of computer 1. The development, types and application fields of computers. 3. Representation and storage of data in computer. 4. The concept and application of multimedia technology. 2. Composition and main technical indexes of computer software and hardware system. 5. The characteristics, classification and prevention of computer viruses. Second, the function and usage of Word 6. The concept, composition and classification of computer network; The concept and prevention of computer and network information security. 7. The concept, principle and application of Internet network service. 1.Microsoft Office application interface usage and function settings. 2. Basic functions of 2.Word, such as document creation, editing, saving, printing and protection. 3. Set fonts and paragraph formats, apply document styles and themes, adjust page layout and other typesetting operations. 4. Make and edit tables in the document. Enter and edit. 5. Edit and process graphics and image (film) objects in documents, use text boxes and document components, and use symbols and mathematical formulas. 6. Document column, page and section operations, document header and footer settings, and document content reference operations. 7. Document review and revision. 8. Use the mail merge function to make and process documents in batches. Third, the function and use of Excel 9. Multi-window and multi-document editing, using document view. 10. Analyze the graphic data, and extract relevant information according to the requirements and quote it into the Word document. The basic functions of 1 Basic operations of Excel, workbooks and worksheets, and control of working views. 2. Enter, edit and modify worksheet data. 3. Cell formatting operation and data formatting. 4. Protection, enjoyment and modification of workbooks and worksheets. 5. Reference of cells, use of formulas and functions. 6. Linkage operation of multiple worksheets. 7. Creation, editing and modification of mini-graphs and charts. 9. Use of PivotTable and PivotChart. 10. Data simulation analysis and operation. 1 1. Simple use of macro function. 12. Obtain external data and analyze and process it. 8. Data sorting, screening, classified summary, grouped display and consolidated calculation. 13. Analyze the data, and extract relevant information according to the requirements and quote it into the Excel document. The basic functions and operations of 1.PowerPoint, the viewing method and use of the presentation. 2. Theme setting, background setting, and the mastery and use of slides in the presentation. 4. Interactive settings such as object animation, slide switching effect and link operation in slides. 5. Slide setting, presentation packaging and output. 3. Edit and apply the text, graphics, SmartArt, images (movies), charts, audio, video, wordart and other objects in the slide. 6. Analyze graphic materials, and extract relevant information according to requirements and quote it into PowerPoint documents.
Question 8: What is the content of Level 2 of the National Computer Rank Examination now? There are many kinds of computer level 2 exams in China, including C language, vb and vf.
I reported that C language is divided into written test and computer written test, mainly including functions, arrays and pointers. Computer examination ring
In Microsoft Visual C++ 6.0, the winding time is 90 minutes and the written test time is 60 minutes.
Zhong will take the exam on April 3.
Generally, there are 100 sets of written test questions online. If you want to buy a book, the National Computing published by the Examination Center of the Ministry of Education.
Computer rank examination is very popular in all major bookstores of Higher Education Press.
Question 9: what is the content of PS test in computer level 2 exam ~? There is no ps in the second-level exam
The subjects of Level 2 examination are: Level 2 C:
DOS command, computer composition principle, multimedia, database operation, computer network, C language programming, computer examination.
Auxiliary C++:
According to the new syllabus, the teaching contents include: overview of C++ language, data types of C++ language, operators and expressions, basic control statements, arrays, pointers and references, functions, numbers and object inheritance, templates, etc.
Secondary VB:
According to the new syllabus, the teaching contents include: basic concepts of VB, integrated development environment, visual programming methods, basic input and output, functions and usage of common controls, VB control structure statements, etc.
Secondary VF:
According to the new syllabus, the teaching contents include: basic knowledge of database system and VF, basic operation of database, structured query language SQL, VF programming, the use of designers and project managers, etc.
Auxiliary access:
According to the new syllabus, the teaching contents include: database system, database and table, database query table, report, data access page, macro, module and so on.
Secondary Java:
According to the new syllabus, the teaching contents include: introduction to JAV language, JAVA data types, operators and expressions, process control, class, array and string operations, exception handling, input/output and file operations, serialization of threads and objects, writing a graphical user interface, setting NCRE as a small program, and adopting a unified national proposition and unified examination form. All subjects in Level 2 are in the form of written examination and computer operation examination. [2] Edit the examination time of this paragraph.
The exam is held twice a year, in March and September respectively, and the specific date is subject to the official announcement. On the afternoon of the written test, the computer test begins, and the time limit for the computer test is five days, which is arranged by the test center according to the number of candidates and equipment. The written test and computer test time is 90 minutes. [2] meter: JZSDK download and operation, JAVA application.
Question 10: what do you need to learn at the second level of computer? Basic knowledge of the second-level subjects of the National Computer Rank Examination (revised in 2002).
This book is organized by the Examination Center of the Ministry of Education, under the guidance of the National Computer Rank Examination Committee, and is written by relevant experts in strict accordance with the requirements of the public * * * part (computer basic knowledge) of the National Computer Rank Examination Level 2 (2002 Edition). The main contents include number system conversion and character coding, the composition and application of computer system, DOS operating system, computer security, computer network and multimedia technology, and the use of Windows operating system. This book is only for candidates who take QBASIC, C and FoxBASE+ exams.
This book is a necessary teaching material for those who take the corresponding subjects of computer grade examination, and can also be used as a teaching material or self-study reference book for basic computer courses in colleges and universities.
4. QBASIC language programming, the second-level course of National Computer Rank Examination.
This book is organized by the Examination Center of the Ministry of Education, under the guidance of the National Computer Rank Examination Committee, and is written by relevant experts in strict accordance with the requirements of the QBASIC language programming examination in the National Computer Rank Examination Syllabus (2002 Edition). The main contents include the basic concept of QBASIC, sequential programming, selection structure programming, loop structure, functions and subroutines, arrays, character processing, screen control and drawing, files, how to use QBASIC and computer guidance, and a certain number of exercises are attached to each chapter for readers to practice and self-test.
This book is a necessary teaching material for those who take the QBASIC language programming test, and can also be used as a reference book for college students to learn QBASIC language programming.
5. Foxbase+database management system, the second-level course of National Computer Rank Examination.
This book is organized by the Examination Center of the Ministry of Education, under the guidance of the National Computer Rank Examination Committee and in strict accordance with the requirements of the FoxBase+ Database Management System Examination in the National Computer Rank Examination (2002 Edition). Based on FoxBase+, this book introduces the basic knowledge of database system, database maintenance, database statistics and reorganization, operation of multiple databases, data elements and common functions of FoxBase+, and systematically introduces the program design, system environment and state parameters of the application system. A certain number of exercises are attached to each chapter for readers to practice and test themselves.
This book is a necessary counseling material for those who take the examination of FoxBase+ database management system, and can also be used as a reference book for college students to learn FoxBase+ database management system.
6. National Computer Rank Examination Level 2 course -C language programming.
This book is organized by the Examination Center of the Ministry of Education, under the guidance of the National Computer Rank Examination Committee, and compiled by relevant experts in strict accordance with the requirements of the C language programming examination in the National Computer Rank Examination Outline (2002 Edition). This paper introduces the basic knowledge of C language programming, the main structure of C language programming, various data types involved in C language, functions in C language, scope and storage class of user identifiers in C language, compilation preprocessing and dynamic storage allocation, structure, * * * users and user-defined types, bit operations, files and computer instructions, and a certain number of exercises are attached to each chapter for readers to practice and self-test.
This book is a necessary teaching material for those who take the second-level C language programming test, and can also be used as a reference book for college students to learn C language programming.
7. The second-level course of the National Computer Rank Examination-Visual Basic Language Programming (Revised Edition)
This book is organized by the Examination Center of the Ministry of Education, under the guidance of the National Computer Rank Examination Committee, and is written by relevant experts in strict accordance with the requirements of the National Computer Rank Examination (Visual Basic Language Programming) (2002 Edition) Level 2 Examination Outline. The contents include: the programming environment of Visual Basic 6.0 Chinese version, the functions and usage of common internal controls, control structure, array, procedure, menu, dialog box, multi-form programming technology, mouse and keyboard events and file processing. Each chapter is accompanied by a certain number of ... >>