According to the Outline of the National Computer Rank Examination for Secondary Access Database Programming (version 20 18), the contents of the national computer secondary access examination mainly include: basic knowledge of databases, basic operations of databases and tables, queries, tables and reports. The examination is in the form of computer examination, the examination duration is 120 minutes, and the full score is 100. Details are as follows:

First, the basic knowledge of the database

1, basic concept

Database, data model, database management system, etc.

2. Basic concepts of relational database.

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

3. The basic concept of relational operation

Selection operation, projection operation and connection operation.

4.SQL command

Query command, operation command.

5. Basic concepts of access system

Second, the basic operation of database and table

1, create a database.

Step 2 create a table

3, the basic operation of the table

Third, query

1, query basic concepts

2. Select a query

3. Cross-table query

4. Generate a table query

5. Delete the query

6. Update the query

7. Additional query

8. Structured query language SQL

Fourth, form.

1, the basic concept of the form

Types and views of forms.

Step 2 create a form

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

Verb (abbreviation for verb) declaration

1, the basic concept of the statement

Step 2 Create a report

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

Sixth, the macro

1, the basic concept of macro

2, the basic concept of events

3. Common macro operation commands

Vii. VBA programming foundation

1, the basic concept of module

2. Create a module

3. VBA Programming Foundation

Eight, VBA database programming

Basic concept of 1 and VBA database programming

2.VBA database programming technology