Level 2 ACCESS outline of Computer Grade Examination

The public basic knowledge is the same as the public basic knowledge section (P27-P29) in the Level 2 (C language programming) examination syllabus ). Basic Requirements for Access Database Program Design 1. Basic knowledge of database systems. 2. Basic understanding of object-oriented concepts. 3. master the basic principles of relational databases. 4. Master the database program design methods. 5. Use Access to create

The public basic knowledge is the same as the public basic knowledge section (P27-P29) in the Level 2 (C language programming) examination syllabus ). Basic Requirements for Access Database Program Design 1. Basic knowledge of database systems. 2. Basic understanding of object-oriented concepts. 3. master the basic principles of relational databases. 4. Master the database program design methods. 5. Use Access to create

Basic public knowledge

SameLevel 2(C language programming)ExamOutlinePublic Basic Knowledge (P27-P29 ).

Access Database Program Design

Basic Requirements

1. have basic knowledge of the database system.

2. Basic understanding of object-oriented concepts.

3. master the basic principles of relational databases.

4. Master the database program design methods.

5. You can use Access to create a small database application system.

　　ExamContent

I. Basic Database knowledge

1. Basic concepts:

Databases, data models, database management systems, classes, objects, and events.

2. Basic concepts of relational databases:

Relational Model (entity integrity, reference integrity, user-defined integrity), relational model, relational, tuples, attributes, fields, fields, values, primary keywords, etc.

3. Basic concepts of relational operation:

Select Operation, projection operation, and join operation.

4. Basic SQL commands:

Query command and Operation Command.

5. Access System introduction:

(1) Basic Features of the Access system.

(2) Basic objects: tables, queries, forms, reports, pages, macros, and modules.

Ii. Basic operations on databases and tables

1. Create a database:

(1) Create an empty database.

(2) Use the Wizard to create a database.

2. Create a table:
(1) create a table structure: Use the wizard, the table designer, and the data table.

(2) Set field attributes.

(3) input data: directly input data to obtain external data.

3. Create and modify the relationship between tables:

(1) Concept of the relationship between tables: one-to-one, one-to-many.

(2) create a relationship between tables.

(3) set the integrity of the reference.
4. Table maintenance:

(1) modify the table structure: Add a field, modify a field, delete a field, and reset the primary keyword.

(2) EDIT table content: Add records, modify records, delete records, and copy records.

(3) Adjust the appearance of the table.

5. Other table operations:

(1) Search for data.

(2) Replace data.

(3) sorting records.

(4) filter records.

III. Basic query operations

1. query category:

(1) SELECT query.

(2) query parameters.

(3) Submit * Table query.

(4) operation query.

(5) SQL query.

2. query criteria:

(1) operator.

(2) functions.

(3) expression.

3. Create a query:

(1) Use the Wizard to create a query.

(2) Use the designer to create a query.

(3) calculate in the query.

4. operate on the created query:

(1) run the created query.

(2) edit the fields in the query.

(3) edit the data source in the query.

(4) sorting query results.

4. Basic Form operations

1. Form classification:

(1) vertical column form.

(2) table form.

(3) Main/subforms.

(4) data table form.

(5) chart form.

(6) PivotTable form.

2. Create a form:

(1) Use the Wizard to create a form.

(2) create a form using the designer: the definition and type of the control, add and modify the control in the form, and set common properties of the control.
5. Basic Report operations

1. Report category:

(1) Vertical Column reports;

(2) Table-based reports.

(3) Chart reports.

(4) label report.

2. Use the Wizard to create a report.

3. Use the designer to edit the report.

4. Calculate and summarize data in the report.

6. Basic page operations

1. Concept of data access page.

2. Create a data access page:

(1) automatically create a data access page.

(2) Use the Wizard to access the page.

VII. macros

1. Basic concepts of macros.

2. Basic macro operations:

(1) create a macro: Create a macro and create a macro group.

(2) run the macro.

(3) conditions used in macros.

(4) set macro operation parameters.

(5) common macro operations.

8. Module

1. Basic concepts of the module:

(1) class module.

(2) standard module.

(3) convert a macro into a module.

2. Create a module:

(1) create a VBA module: Add a macro to the module and execute a macro in the module.

(2) Writing events: Keyboard Events, mouse events, window events, Operation events, and other events.

3. Call and parameter transfer.

4. VBA program design basics:

(1) Basic concepts of object-oriented programming.

(2) VBA programming environment: Enter the VBE and VBE interfaces.

(3) Basics of VBA programming: constants, variables, and expressions.

(4) VBA program process control: Sequence Control, select control, and cyclic control.

(5) debugging of VBA program: set breakpoints, single-step tracking, and set monitoring points.

　　ExamMethod

1. Written Examination: 90 minutes, out of 100 points, including 30 points of public basic knowledge.

2. machine operation: 90 minutes, out of 100 points.

Machine operations include:

(1) Basic operations.

(2) simple application.

(3) Comprehensive Application

Author: