tailieunhanh - how to do everything with microsoft office access 2003 phần 4

, đó là thời gian để nhập dữ liệu và nhận được để làm việc. Trong chương cuối cùng, bạn đã thấy một số tính năng thiết kế giữ lỗi của cơ sở dữ liệu của bạn. Chương này thảo luận về các công cụ khối dữ liệu lỗi và tăng tốc độ quá trình nhập dữ liệu. | CHAPTER 7 Extract Information with Queries 145 The upper pane is the table pane which displays the field lists for all the tables in the query and shows the relationships among the tables. The lower pane is the design grid which shows the elements of the query design. The design grid shows the field names you selected in the wizard dialog box and includes the name of the table they came from. Here is where you specify which fields to include any filter criteria or sort orders and whether to show the field in the query result. The check marks in the Show row indicate which fields are to appear in the query result. Clearing the check mark hides the field from the query result. This is helpful when you want to filter or sort the results based on a field that you don t want to appear in the query results. The Query Design toolbar has some new buttons the menu bar also includes new options. Query Type Show Table Top Values Build Run Totals Properties 7 Without the Wizard To bypass the wizard and create your query from scratch select Design View from the New Query dialog box. The Show Table dialog box opens there you will select the tables or queries you want to question. As an example of creating a new query without the wizard Home Tech Repair needs a list of work orders showing the following fields from the Bid Data and Workorders tables arranged in the following order Bid Number Bid Data Supervisor Workorders Job Address Bid Data Description Workorders Award Date Bid Data Start Date and Completion Date Workorders Later we will add the customer s Last Name and Phone Number from the Customers table. We ll also add the cost data compute the total cost and add criteria based on start date total cost and other factors to limit the records in the result. To create the new query 1. Choose New in the Queries tab of the Database window. 146 How to Do Everything with Microsoft Office Access 2003 2. Select Design View and click OK. The Show Table dialog box opens with three tabs