Final MISY 5325 question n answers graded A+ 2023/2024 already passed

Final MISY 5325Calculated- - correct answer automatically calculate and store data for the field using data from other fields Calculated- - correct answer automatically calculate and store data for the field using data from other fields Calculating Statistics- - correct answer Click totals icon, total row inserted in design grid, select avg, add grouping field in total Calculated Data Type- - correct answer Expression builder type: [Amount Paid]+[Current Due] "Get External Data" - correct answer wizard- browse, locate excel file Filter by Selection- - correct answer Place cursor in any cell, Home tab, click Selection on the Sort and Filter group and select equal PA, Remove by clicking on picture beside column filter was applied to, check Select All, and click OK Update/Delete Query- - correct answer Update/Delete Query- Design tab,options change in design grid, field, table, delete/update, criteria, Message nforming how many records deleted/updated, cant recover deleted Cross Tab Query - correct answer to extract data in a spreadsheet-like format. An Update Query - correct answer Can be used to input a specific data value into a large database, without having to type it in every record. Delete Query - correct answer Data Cant be recovered, Calulating satistics - correct answer Design Grid—Totals Icon (average, sum) Crosstab query - correct answer Allows you to perform 2 demensional grouping Multi attribute key - correct answer When a Primary Key consists of more than 1 field Look up key - correct answer Drop down ( one or multiple values) Report Layout View - correct answer Rearrange data