wap2010计算机考点,2010年全国计算机二级access上机考试考点总结（In 2010, the national computer two access computer test site...-优快云博客

2010年全国计算机二级access上机考试考点总结(In 2010, the national computer two access computer test site summary)

In this paper, 120 contributions are made by Skywalker

DOC documents may experience poor browsing on the WAP side. It is recommended that you first select TXT, or download the source file to the local view.

In 2010, the national computer two Access computer test site summary

The query's basic operations query is a tool for Access processing and analyzing data. It can extract data from multiple tables for users to view, change and analyze. To understand and learn how to use the query capabilities of Access, you should familiarize yourself with the basic concepts of queries, the basic operations, and the creation and use of queries. This section requires mastering the concepts of queries, the classification of queries, the criteria for querying, the creation of queries, and the operation of queries that have been created. 1. query classification a) select query: according to the specified query criteria, to obtain data from one or more tables, and display the results. B) crosstab query: field derived from a table by grouping a set of columns in the data table on the left, a set of columns in the upper part of the data table, then statistics show a field value in a table at the intersection of the table rows and columns. C) parameter query: a query that uses dialog boxes to prompt users for input criteria, and can retrieve records that meet the appropriate criteria based on user input criteria. D) operation query: you can edit and edit the results in a query operation, including generating table queries, deleting queries, updating queries and appending queries. E) SQL query: a query created by a user using the SQL statement, which consists of Federated queries, delivery queries, data definition queries, and subquery. 2. query criteria a) the operators in the guidelines: relational operators, logical operators, and special operators. (b) functions in a standard: numerical fu