Chapter 7 - Problem solving using access. Learning objectives of this chapter include: Describe the process of using the simple query wizard using access, describe the process of using the design view for creating a query using access, describe the process of adding a calculated field to a query using access, describe the process of using aggregate functions to calculate totals in queries, describe how to format results displayed in calculated fields. | TECHNOLOGY PLUG-IN T7 Problem Solving Using Access LEARNING OUTCOMES Describe the process of using the Simple Query Wizard using Access Describe the process of using the Design view for creating a query using Access Describe the process of adding a calculated field to a query using Access Describe the process of using aggregate functions to calculate totals in queries. Describe how to format results displayed in calculated fields INTRODUCTION A query is a tool for extracting, combining, and displaying data from one or more tables, according to criteria you specify In a query, you can sort information, summarize data (display totals, averages, counts, and so on), display the results of calculations on data, and choose exactly which fields are shown You can view the results of a query in a tabular format, or you can view the query’s data through a form or on a report Creating Simple Queries Use the Simple Query Wizard to create a select query A select query displays data from a table or | TECHNOLOGY PLUG-IN T7 Problem Solving Using Access LEARNING OUTCOMES Describe the process of using the Simple Query Wizard using Access Describe the process of using the Design view for creating a query using Access Describe the process of adding a calculated field to a query using Access Describe the process of using aggregate functions to calculate totals in queries. Describe how to format results displayed in calculated fields INTRODUCTION A query is a tool for extracting, combining, and displaying data from one or more tables, according to criteria you specify In a query, you can sort information, summarize data (display totals, averages, counts, and so on), display the results of calculations on data, and choose exactly which fields are shown You can view the results of a query in a tabular format, or you can view the query’s data through a form or on a report Creating Simple Queries Use the Simple Query Wizard to create a select query A select query displays data from a table or tables, based on the fields that you select, but it does not sort or filter the data Creating Simple Queries To create a query using the Simple Query Wizard: Open the file You will see a Security Warning Click on the Options button and select Enable Click OK Click the Create tab and then click the Query Wizard button Double-click Create query by using wizard Click the Tables/Queries box drop-down arrow Click Table: CUSTOMER Creating Simple Queries Creating Simple Queries Add all the fields by clicking on the right double arrow button Click Next Make sure that the radio button Detail is selected and click Next Type Customer Query as the Query title Click Finish to view the query in Datasheet view Close the query (it will automatically be saved) Creating Simple Queries Reordering Columns In The Select Query Datasheet You can reorder columns by clicking and dragging To reorder columns: Open the Customer Query by double-clicking on it from the Navigation pane .
