1 / 11

Performing Calculation

Performing Calculation. You can perform calculations on textual and numeric data to summarize all the records in the a table or selected records. You can perform some of the calculations using the Total row in the query Design window. . Top Values.

toya
Télécharger la présentation

Performing Calculation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Performing Calculation You can perform calculations on textual and numeric data to summarize all the records in the a table or selected records. You can perform some of the calculations using the Total row in the query Design window.

  2. Top Values You can use the Top Values property to return a specified number of records or a percentage of records that meet the criteria you specify. For example, you might want to return the top 10 values or the top 25 percent of all values in a field. Total ToolBar Top Values

  3. Creating Calculated Fields in Query A Calculated Field is a field, which is defined in a query, and it displays the result of an expression. To create a new query: • Enter the name of the new field in the Field row of a query grid followed by colon (:). • Enter the expression, with field names is square bracket [].

  4. e.g. Total Amount: [Price] * [Number Sold]

  5. Select Queries Select Queries retrieves data from one or more tables. You can also use a select query to group records and calculate sums, counts, averages, and other types of totals. Action Query: • Make Table Query. • Append Query. • Delete Query. • Update Query.

  6. Make-Table Query • Make-Table Query use to write results in new table. • Select the table whose record you want to make another table. • In the Query Design View, click the Query type icon, and then click Make-Table query. • In the Table Name box, enter the name of the table you want to create or replace. • Click Current Database to put the new table in the currently open database. Or click another Database.

  7. Step 2 Step 3 5. Drag the fields you want in the new table. 6. To create the new table, click Run from the toolbar.

  8. Append Query Append Query use these queries to add information from one table to another. • Select the table whose record you want to make another table. • In the Query Design View, click the Query type icon, and then click Append Query. • In the Table Name box, enter the name of the table you want upend record to. • Click Current Database to put the new table in the currently open database. Or click another Database.

  9. Delete Query You can use the Delete Query to deletes of entire groups of records. • Select the table whose record you want to make another table. • In the Query Design View, click the Query type icon, and then click Delete Query. • Drag the field you want from the table’s field list to the design grid. • In the query design grid, Where is displayed in the Delete cell of the fields you specify criteria for. • Click the Datasheet view to view the records that will be deleted. Run the query, click Yes to confirm the deletion and save the query.

  10. Update Query You can make global changes to a table. • Select the table whose record you want to make another table. • In the Query Design View, click the Query type icon, and then click Update Query. • Drag the field you want from the table’s field list to the design grid. • Enter the Criteria you want. • In the Update To, type the expression you want to use. • Run the query, click Yes at the update prompt.

More Related