What is VFP?

Introduction to the Introduction to the Introduction to the Introduction to the Introduction of the III VFP Exam

The public basic knowledge section 30 points

professional language part 70 points

basic requirements
1 , Basic Knowledge of the Database System
2. Basic understanding of the concept of object -oriented
3. Master the basic principles of the relationship between the database of the database
4. Master the database program design method
5. Can be used to use Visual FoxPro establishes a small database application system
The test content
. Visual foxpro basic knowledge
1. Basic concepts
database, data model, database management system, class and objects, events, events ,method.
2. Relationship database:
(1) Relations Database: Relationship model, relationship mode, relationship, relationship, group, attributes, domain, main keywords and external levels
keywords.
(2) Relations operation: Select, projection, and connect.
(3) The consistency and integrity of data: physical integrity, domain integrity, reference integrity.
3. Visual foxpro system features and working methods:
(1) The characteristics of the Windows version database.
(2) Data type and main file types.
(3) Various devices and wizards
(4) Working method: interactive method (command method, visual operation) and program operation mode.
4. Basic data elements of Visual FoxPro:
(1) constant, variables, expression.
(2) Common functions: character processing function, numerical calculation function, date time function, data type conversion function,
test function.
. The basic operation of the Visual FoxPro database
1. The establishment, modification and effectiveness of the database and table:
(1) the establishment and modification of the table structure.
(2) The browsing, increase, deletion and modification of the records.
(3) Create the database and add or delete the table from the database.
(4) Set field -level rules and record rules.
(5) Sets: main index, candidate index, ordinary index, unique index.
2. Multi -table operation:
(1) Select the working area.
(2) Create the association between tables: one -to -one association; one -to -many association.
(3) Set the reference integrity.
(4) The connection of the table: internal connection; external connection: left connection, right connection, complete connection.
(5) Establish temporary association between the table.
3. Create view and data query:
(1) The establishment, execution and modification of the query file.
(2) Establishing, viewing and modifying the view file.

(3) Create a multi -table query.
. The relationship between the standard language of the database of the database SQL
1, SQL data definition function:
(1) Create Table -SQL
(2) Alter Table — SQL N 2 2 2 2 2 2 2 2 2 2 2 2 2 2 , SQL data modification function:
(1) Delete -SQL
(2) Insert — SQL
(3) UPDATE -SQL
3. SQL data query function:
(1) Simple query.
(2) nested query.
(3) Link to query.
(4) Grouping and calculation query.
(5) The collection and calculation.
. The use of the project manager, designer and guide
1. Use item manager:
(1) Use the "Data" tab.
(2) Use the "Document" tab.
2. Use the form designer:
(1) Add and modify the control object in the form.
(2) Set the data environment.
3. Use menu designer:
(1) Create the main option.
(2) Design sub -menu.
(3) Set the menu option program code.
4. Use reporting designer:
(1) Generate fast reports.
(2) Modify the layout of the report.
(3) Design group reports.
(4) Design multi -column report.
5. Use application wizard.
5. Visual FoxPro program design
1. The establishment and operation of the command file:
(1) the establishment of the program file.
(2) Simple interactive input output command.
(3) Debugging and execution of the application.
2. Structural program design:
(1) Sequential structural program design.
(2) Select structural program design.
(3) Circle structure program design.
3. Process and process call.
(1) Sub -program design and call.
(2) Process and process files.
(3) Parameter transmission in local variables, global variables, process calls.
The test method:
1. Written test: 90 minutes.
2. Play operation: 90 minutes.
The operation of the upper machine includes:
(1) Basic operation.
(2) Simple application.
(3) Comprehensive application.
The test form

Swritten test part: a total of 60 points, 20 points for single -choice questions for basic knowledge (the same language is the same, 1 point for each question), 10 points for single choice questions for VFP knowledge (each each (each each) The question is 1 point), and the VFP knowledge is 30 points (1 point per empty).

The answer requirements: The answer to a single question must be placed on the special answer card; One empty and one line is not one question, because some questions contain multiple empty).

If parts: 40 points in total, the content of each test is different, but the question type and knowledge points are similar. They are all about 4 operation questions about VFP. Each question ranges from 5-15 points. Essence The four major items for each session are: 1. Basic operations of projects and databases 2. Design query 3. Design menu 4. Design form. It is worth noting that the content of the program design is getting larger and larger, and the test form is in the process code of the form or menu design.

The answer requirements: first run the "on -board test" program on the A drive from the resource manager, enter your own admission certificate number, name and test paper code, confirm and exit. Then enter the VFP application interface, set the default path of the system to a disk, and then start directly on the test disk as required. Do not draw a soft disk at will. In the label, you need to fill in the school name, your own name and admission ticket number, the language of the exam and the vFP XX.

Qualified standards

VFP secondary exams The final qualification line was previously determined by the province. The 60 -point pass line required by the examination outline, the qualified line of 2000 autumn is 50 points (of which the on -board score must not be less than 18 points), the qualified line in the spring of 2001 is 56 points (of which the on -board score must not be lower than that 24 points), but the minimum score of the written test has not been required.

The noteworthy is that as the number of exams increases, the content of the exam is getting wider and wider, and the difficulty is getting more and more difficult. However The higher the coming, it can be expected that the qualified score line this autumn may be higher than before.

is worth mentioning that it was learned from the provincial computer -level examination seminar held this summer vacation that the provincial -level examination center has arranged the top 20 of the province's universities in the province. Among them, the results are good. May our teachers and students work harder and strive to achieve a higher pass rate and excellent rate, and make people truly feel that the students of Huai Workers are as great with excellent performance!

The test strategy

1. Regarding the on -board (40 points)

From the exam situation of the years, the on -board part of the VFP is easier to get it. Students who have good grasp of the test knowledge points and skilled on the aircraft can generally get 30-35 points. It is recommended to do more targeted training, be proficient in experimental guidance and various operations involved in the previous on-board test questions, and strive to strive Get more than 30 points.

If according to the test center, the VFP on the on -board test will adopt a unified data platform -that is, the teaching database, the content and form are the same as the same. It is to prevent candidates from facing a new data platform during the exam and cause tension, which affects the normal level. It is recommended to be familiar with this data platform before the exam and do more related exercises.

2. Basic knowledge part of the written test (20 points)

The two -tier test questions are exactly the same, the knowledge points are basically fixed, including the basic concept of computer soft and hardware. , Basic concepts of virus, network, information coding, information media, software engineering, etc., it is recommended to take a closer look at the first six chapters of "New Computer Application Basis". In the past, some test questions were almost the original words in the tutorial; but the application part (Windows, Word, Excel) Test some operating experience and skills. It seems that the effect of the textbook is not obvious. It is best to do more previous test questions. The key is to grasp the test knowledge points and understand the relevant concepts. This part generally has 1-2 points that reflect the latest knowledge. It is difficult to get high scores. You should strive to get 12-16 points. Excel is a new part. It is recommended to find some questions to see.

The remind everyone to note: In the autumn and spring of 2002, although this part of the test questions are all on the textbook, the knowledge points are relatively biased and generally the general exams are poor. Generally Only 6-7 points were scored, only about 10 points. I hope everyone will read the first six chapters of textbooks when reviewing.

Im reminder: This time the exam is mainly based on the 2001 students. The textbooks used in the "Computer Cultural Basis" are different from the designated textbooks designated by the provincial grade examination, because although the main content of the two books The same, but the detailed knowledge points are different. The original words in the designated textbook often appear in the exam. The knowledge points appear are unfamiliar.

3. Single questions for written tests (10 points)

This part is relatively simple, generally examines the understanding of the basic concepts of VFP and the application of common functions. It is recommended Do more VFP learning guidance and topics in previous test papers, and understand and master the related concepts and common functions of VFP in the process of doing questions. This part is easier to score, and you should strive to get 8 points or more.

4. Filling in the written test (30 points)

The knowledge involved in this part is relatively wide, of which: the basic concepts, common commands and functions of the database are: the database of the database Use, SQL command, reading comprehension program, concepts for object -oriented programming, setting of common attributes, etc. It is recommended to look at the textbooks first, be proficient in the content of each chapter, and then do some exercises, focusing on understanding. This part is more difficult to score and should score more than 15-18 points.

5. Precautions for test

1) On -board test: The most taboo is nervous, you should do it calmly from behind, remember: the operation of the card is left, the operation of the card is thrown away first. Then do it later, and then look back to solve these problems. You can view help when you encounter content that you can't encounter during the operation -use "index": enter the noun that you can't know directly, and then click the display, then the related content will appear. If you encounter an English explanation that you can't understand, Just look at the example (example) in it, which can generally find out the usage through examples.

This questions are divided by step. Each operation has a corresponding score. Do not give up easily, let alone pull down the question. It is worth noting that the current VFP on the machine has adopted machine review. It uses a method compared with standard answers, so when answering questions, you must not add or decrease to the space, punctuation, etc. Or code, don't be empty, fill in the content that is similar to that is better than anything. Generally, the total score and the qualified line are only 1 point. 1 point), maybe the teacher will show mercy, and give points to this situation.

This tests that are prone to crashes due to misunderstanding of candidates. Unfortunately, you must calmly cope with: press Ctrl Alt Del once to end the current task (sometimes the machine responds slowly, you should be patient, etc. For a moment, don't press those three keys, which will cause the machine to restart, delay a few minutes), turn off the VFP, and then re -enter the VFP system, and then do the question. At this time, you don't need to enter the admission ticket number.

If when the machine fails, it is impossible to rule out that the monitoring teacher should be reported in time to help solve or replace the machine and then examine.

2) Written test: The most taboo, you should see the meaning of the question (especially the students who do more usually do the exercises, let alone do it for granted. What differences), remember: If you encountering it, you will be decent. Do not submit the papers in advance, do n’t give up lightly, do n’t leave any questions, you ca n’t guess one.

The mentioned that the qualified line is determined according to the average score of the province. In short, students who have learned a little should strive to reach the qualified line.

VFP's focus and difficulty

VFP's main contents are divided into two parts: the basic operation and application development of the database. The key contents are:
(1) Basic operations of the database and data table, mainly include: creating and modifying data table structures, setting up advanced attributes of library table fields, input and maintenance of records, establishing structural composite indexes, establishing a structural composite index, establishment The relationship between multiple tables and setting reference integrity.
(2) Design query and view of the query designer
(3) Common commands, mainly: opening, modification and deletion of the database, browsing, screening, screening, statistics, finding, copying, copying, copying, copying, copying, copying, copying, copying,. Additional, replaced and deleted, the execution of programs and forms, setting of the system environment, etc.
(4) Common functions, especially some commonly used data conversion functions, date and time functions, character functions, numerical functions, database operation functions.
(5) SQL command, especially Select-SQL, Update-SQL, Create Table-SQL command.
(6) Basic concepts for object -oriented programming
(7) The key events, attributes and methods of common controls
(8) Use table direction guide and form designer design and data binding Types
(9) Design custom classes with class designers and form designers
(10) Design various menus with the menu designer

VFP content::
(1) Set the validity rules of the field in the database table
(2) Set the reference integrity between multiple tables
(3) Constructing multi -field index expression
(4) Multi -table query and parameterization view containing expression and group conditions
(5) Write event code and method program
(6) Add new attributes and methods to custom class

VFP is the abbreviation of Visual Foxpr, and it is a database development software launched by Microsoft.
Visual FoxPro originated from the database product Foxbase launched by Fox Software, the United States, running on the DOS, compatible with the Xbase series. Foxpro was originally a enhanced version of Foxbase. The highest version has been 2.6. After that, Fox Software was acquired by Microsoft and developed, so that it could run on Windows and renamed Visual Foxpro.
This knowledge:

: Visual FoxPro 9.0 is a tool for creating and managing high -performance 32 -bit database applications and components; released in 2007, it is the last version of VFP; currently the current; The service package version is SP2, and there are 3 HOTFIXES packages, that is, the final version is 09.00.0000.7423.
: Visual FoxPro 9.0 System configuration requirements:
1. Pentium processor
2. Operating system: Microsoft Windows 2000 Service Pack 3 or higher Microsoft Windows XP or higher Microsoft Windows Server 2003 or higher
3. Memory: 64M, recommended 128M or higher
4. Hard disk: The program installation requires 165m, and the additional 20 MB hard disk space is used for installation system for the necessary program
5. Optical drive: CD-ROM or DVD-ROM
6. Show: VGA 800 x 600 256 color
7. Mouse: Microsoft mouse or compatible mouse