Urgently ask for the key points of the written test of computer level 2 access!!

Supports all Windows 32-bit systems, including XP, Win7, Win8 32-bit.

Access Universal Edition:

All Windows systems are supported, including XP, Win7, Win8 32-bit and 64-bit.

The above is also a must-have for the exam, safe and non-toxic, follow the prompts, and you can use it permanently after the installation is completed.

Make sure to resolve the issue.

There are two types of exams: one is the National Computer Grading Examination (NCRE), commonly known as the National Exam; The other is the National Higher Education (Anhui Examination District) Computer Proficiency Test (CCT), which is commonly known as the provincial examination. It should be able to judge from the registration fee and examination time, the national examination is in September, and the registration fee is relatively expensive (I don't know how much Anhui Province is, anyway, it is more expensive than the provincial examination), and the provincial examination in Anhui Province is in December, and the registration fee is 35 yuan.

If you are taking the exam in September, then you should apply for the national exam.

The national examination is paperless, there is no written test, including 40 multiple-choice questions (including 10 questions of public basic knowledge, 30 questions of access theory and application), a total of 40 points, and the operation questions include 3 basic operation questions, simple application questions and comprehensive application questions, with a score of . Those with a total score of 60 points or more are qualified (90 points or more are considered excellent). Since September 2013, the examination environment of the national examination has been upgraded from the original Access 2003 to the 2010 version.

Revision materials refer to official textbooks and exam question banks. The textbooks are "National Computer Grading Examination Level 2 Course - Public Basic Knowledge" and "National Computer Grading Examination Level 2 Course - Access Database Programming", purchased in 2013 edition. In addition to the textbooks, the computer-based test question bank must also be prepared, and the 60-point operation questions during the exam are the original questions in it.

There are many versions of the question bank on the market, and the common ones are Nankai 100 questions, future education, new ideas, and tiger education, which can be used, but it is best to use the September 2013 version, don't use the previous one.

The focus of the revision should be on the operation questions, because the score is high and the test is the original question. If you want to get excellent, you can make a multiple-choice question in the written test of the previous years (before 2013, it was divided into written test and computer), and you don't need to look at the fill-in-the-blank questions. If you just want to read the textbook without needing to be excellent, you can figure out all the questions in the question bank.

According to the Syllabus of the National Computer Level 2 Access Database Programming Examination (2018 Edition), the content of the National Computer Level 2 Access Examination mainly includes: basic knowledge of databases, basic operations of databases and tables, queries, forms, reports, and other 8 major contents. The test format is a computer-based test, the test duration is 120 minutes, and the maximum score is 100 points.

The details are as follows:

1. Basic knowledge of databases.

1. Basic concepts.

Databases, data models, database management systems, etc.

2. Basic concepts of relational databases.

Relational models, relationships, tuples, attributes, fields, domains, values, keywords, etc.

3. Basic concepts of relational operations.

Select operations, projection operations, join operations.

4. SQL commands.

Query commands, operation commands.

5. Basic concepts of access system.

2. Basic operations on databases and tables.

1. Create a database.

2. Create a table.

3. Basic operations of the table.

3. Inquiries. 1. Query the basic concepts.

2. Select Query.

3. Cross-table query.

4. Generate table queries.

5. Delete the query.

6. Update the query.

7. Additional inquiry.

8. Structured query language SQL

Fourth, the form. 1. The basic concept of form.

The type and view of the form.

2. Create a form.

Common controls in forms, common properties of forms and controls.

5. Statements. 1. Basic concepts of reports.

2. Create a report.

Common controls in reports, common properties of reports and controls.

6. Macro 1, macro basic concept.

2. The basic concept of events.

3. Common macro operation commands.

7. VBA Programming Basics.

1. Basic concepts of the module.

2. Create a module.

3. VBA programming basics.

8. VBA database programming.

1. Basic concepts of VBA database programming.

2. VBA database programming technology.

There are a total of 40 multiple-choice questions of 40 points, and each question is worth one point, including 10 common foundation questions and 30 AC foundation questions. It is recommended to buy a question bank for future education to do it, bookstores sell it, but bookstores sell books and then send the question bank, in fact, books are useless, you can buy a question bank from a treasure is cheaper, if you do all the AC multiple-choice questions of future education, you can get more than 20 points in the exam or you are sure. Declaration:

I'm not advertising.

September 2018 Computer Level 2 Exam Access Questions and Answers (2).

1.The type of field that cannot be indexed is (a).

a) Remarks.

b) Numerical values.

c) Characters.

d) Date.

2.Use "@" in the Format property of the text type field; has not been entered", the following statement is correct (d).

a) Represents all entered data.

b) Inputs only"@"Symbol.

c) This field must not be blank.

d) If no data has been entered, it will be displayed"Not yet entered"4 words.

3.A text-type field can hold up to (d) Chinese characters.

a) 255

b) 256

c) 128

d) 127

4.A valid expression is (b).

a) Teachers' salaries between 2000 and 3000

b) [Gender]="Male"or[gender]="Female"

c) [Teacher's salary]>2000 [Teacher's salary]<3000

d) [Gender]like"Male"=[Gender]="Female"

5.To query information for students with grades between 60-80 (including 60 and not including 80), the query criteria for the grade field should be set to (b).

a) >60 or <80

b) >60 and <80

c) >60 and <80

d) in(60,80)

6.In the query design grid of the Query Designer, (c) is not an option in the field list box.

a) Sorting.

b) Display.

c) Type.

7.Operational queries do not include (c).

a) Update Queries.

b) Additional Inquiries.

c) Parameter queries.

d) Delete the query.

8.If you want to increase the product**, the most convenient way is to use the query (b) below.

a) Additional Inquiries.

b) Update the query.

c) Delete the query.

d) Generate table queries.

9.To create a query in Design View to find the name, gender, and overall score of female students with a total score of 255 or more (inclusive), the correct way to set the query criteria should be (c).

a) Type in the criterion cell: Total Score=255 and Gender="Female"

b) Type in the total score criterion cell: Total Score=255; In the guideline cell for gender, type:"Female"

c) Type in the total criterion cell: >=255; In the guideline cell for gender, type:"Female"

d) Type in the criterion cell: Total Score = 255 or Gender ="Female"

10.If you do not want to display the contents of the selected field in the query designer, the check number of item (b) for the field is canceled.

a) Sorting.

b) Display.

c) Type.

d) Guidelines.