Current location - Training Enrollment Network - Books and materials - Urgent! ! Access to the database, in addition to the sales system and the book system, you can do anything else.
Urgent! ! Access to the database, in addition to the sales system and the book system, you can do anything else.
1. There are no more teaching management systems and book sales systems;

2. Design the data tables included in the system, including the fields and primary keys of each table and the relationship between tables. Select the appropriate data type for each field of the table, use the input mask (used at least once in the whole database) and the validity rule (used at least once in the whole database) as needed when establishing the table structure, and the number of data tables in the system should not be less than 3;

3. Input data: input data into data tables, each table has no less than 20 records;

4. Query: design the required query according to the system functional requirements, and require the use of calculated fields and totals; There are at least five different types of queries (select query, parameter query, crosstab query, update query, delete query, generate table query, append query and SQL specific query);

5. Form: Design the required form according to the requirements of the system, so that all functions of the system can be completed through the form;

6. Reports: establish reports to realize statistics and output of data;

7. Macros: Design the required macro objects according to the requirements of the system;