In Excel, the Find and Replace commands not only find text but also. in values and formulas in a single worksheet or across an entire workbook. styles alignments numbers discrepancies As with all financial functions that use a Rate argument, Rate must be expressed in terms of the time period as the payments. same future past projected To create a calculated field in a query, click the button on the Query Tools Design tab. Property Sheet Parameters Totals Builder If you select Calculated Field and a data type for a new field in an Access table, the Expression Builder opens a new blank field is added to the table the Calculation AutoComplete list opens the Property Sheet opens to the General tab In an Access table, you can guide users into entering the proper type of data by using a(n) for text and data fields. SQL clause SmartTag input mask default value Sum, average, min, max, count, and similar functions are known as functions because they summarize data. summation aggregate combining total perform an action on the records that meet the query specifications. Action queries Embedded queries Appended actions Linked actions You can use wildcards when defining criteria in the WHERE clause just as you can when entering criteria in the Criteria row in Query Design view. Which of the following matches any string of any length? ? # (a) Which type of query can be useful for purging outdated records? Append queries Make Table queries Delete queries Update queries Rearrange tables in the Access Relationships window by clicking the title of each table box and it to a new location. copying joining dragging dumping In Access, displaying a well-designed navigation can eliminate the need for the Navigation Pane. table report form query